How to Set Printing Options in Excel

1. Start Microsoft Excel and open a spreadsheet that you would like to print.
2. Choose the 'File' button and click 'Print' to bring up the 'Print' dialog box.
3. Change the printer you are using by clicking the 'Name' list under the 'Printer' section of the 'Print' dialog box. You can view the printers you have installed and click on which printer you would like to use to print your spreadsheet.
4. Check the 'Print to file' check box in the 'Printer' section of the 'Print' dialog box to print the spreadsheet to another computer file instead of from a printer.
5. Set the print range of your spreadsheet by selecting the 'All' radio button to print all of the pages or 'Page(s)' radio button to print only a certain page or multiple pages in your spreadsheet. If you choose the 'Page(s)' option you will need to use your keyboard to specify which pages you would like to print.
6. Select what you would like to print by choosing either 'Selection,' 'Active sheet(s),' 'Entire workbook' or 'List' under the 'Print what' section of the 'Print' dialog box.
7. Set the number of copies that you want to print by using your keyboard to type in the number beside 'Number of copies' under the 'Copies' section of the dialog box. You can also choose to collate the spreadsheet by putting a checkmark in the 'Collate' check box in this same section.