Microsoft Excel Printing Worksheets - Microsoft Excel

What are Printing Worksheets in Excel 2010?

Quick Print

To print a copy of worksheet with no layout adjustment use Quick Print option.
The two ways of using this option is listed.

  • 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).

printing worksheet

Adjusting Common Page Setup Settings

The different ways in adjusting the print settings available in Page setup dialogue box are listed 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.

Choosing Your Printer

Choose File » Print and use the drop-down control to switch to a different printer. This option is in the Printer section to select any other installed printer.

setting printer

Specifying What You Want to Print

To print only a part of the worksheet rather than the entire active area. Choose File » Print. Then 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.

see what to print


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Microsoft Excel Topics