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.
The Print settings appear, along with a preview of the printout.
In the Copies box, click the up-increment arrow to change the value to 2.
Click the Print button to send the job to the printer.