How to Use the Page Break Preview in Excel 2013
How to Solve Page Break Problems in Excel 2013
Excel 2013: Using the Print Titles Feature

How to Print Worksheets in Excel 2013

You can print your work in Excel 2013 on paper to share with people who may not have computer access or to pass out as handouts at meetings and events. You can print the quick-and-easy way with the default settings or customize the settings to fit your needs.

By default, when you print Excel prints the entire active worksheet — that is, whichever worksheet is displayed or selected at the moment. But Excel also gives you other printing options:

  • Print multiple worksheets: If more than one worksheet is selected (for example, if you have more than one worksheet tab selected at the bottom of the Excel window), all selected worksheets are included in the printed version. As an alternative, you can print all the worksheets in the workbook. To select more than one worksheet, hold down the Ctrl key as you click the tabs of the sheets you want.

  • Print selected cells or ranges: You can choose to print only selected cells, or you can define a print range and print only that range (regardless of what cells happen to be selected).

In Excel 2013, Print Preview is built into Backstage view, so you see a preview of the printout at the same place where you change the print settings.

  1. Choose File→Print.

    The Print settings appear, along with a preview of the printout.

  2. In the Copies box, click the up-increment arrow to change the value to 2.

  3. Click the Print button to send the job to the printer.

blog comments powered by Disqus
How to Create a Custom Header or Footer in Excel 2013
How to Cancel Print in Excel 2013
How to Massage the Margins in Excel 2013
How to Print from the Excel 2013 Backstage View
How to Split the Worksheet into Windows in Excel 2013