How to Print Worksheet in Excel

How to Print Worksheet in Excel

Before printing in Excel, select the print area, you will select the area to be printed in the excel sheet, if you are not satisfied with the print area, you can also change it.
  • Clicking on the File menu and clicking on the Page setup option, a dialog box of Page setup will appear.







On clicking the Sheet option in the above dialog box, the following dialog box will appear on the screen.






  • Determine the section of the worksheet to be printed in the print area.
  • After that, clicking on the Ok button, the selected range will be set in the Print area.

View the sheet before it is printed

If you can see the Print Preview on the screen before taking the print of the worksheet, then the problem of removing the wrong print can be avoided.
  • Click on File menu
  • By choosing the Print Preview option, your page will appear on the screen.
  • Click on the Zoom button to see the location of the page clearly.
  • If you want to print after viewing the preview, click on the print button.

Start Printing

After making all the settings, follow the procedure to start printing -
  • Click on the File menu.
  • Select print option
  • Select the printer name in the Printer name option
  • If you want to print all the pages in the page range, then you have to print all or a particular page, then type the number of those pages from from to in front of the page option.
  • In the Copies option, type the number of copies to be printed.
  • Clicking on the Properties option will open a dialog box where you can set Page Size, Portrait, Landscape etc.
  • Then click on Ok button
  • If you want to see what the worksheet will look like after printing, click on the Preview button.
  • On clicking the Print button, the worksheet will start printing.
Previous
Next Post »

Featured Post

Changing the background of selected slides of the presentation

Changing the background of selected slides of the presentation The following options are used to insert different backgrounds on differe...