i. Quick Print:
If you want to print a copy of a worksheet with no layout adjustment, use the Quick Print option. There are two ways in which we can use this option.
-
Choose File » Print (which displays the Print pane), and then click the Print button.
-
Press Ctrl+P and then click the Print button (or press Enter).
ii. Adjusting Common Page Setup Settings:
You can adjust the print settings available in the Page setup dialogue in different ways as discussed below. Page setup options include Page orientation, Page Size, Page Margins, etc.
-
The Print screen in Backstage View, displayed when you choose File » Print.
-
The Page Layout tab of the Ribbon.
iii. Choosing Your Printer:
To switch to a different printer, choose File » Print and use the drop-down control in the Printer section to select any other installed printer.
iv. Specifying What You Want to Print:
Sometimes you may want to print only a part of the worksheet rather than the entire active area. Choose File » Print and use the controls in the Settings section to specify what to print.
-
Active Sheets: Prints the active sheet or sheets that you selected.
-
Entire Workbook: Prints the entire workbook, including chart sheets.
-
Selection: Prints only the range that you selected before choosing File » Print.