How to Set Printing Options in Excel

By eHow Computers Editor

Rate: (0 Ratings)

Within the "Print" dialog box in Microsoft Excel, you can set a wide variety of options so you can print your spreadsheet just how you would like to have it printed. You can set where you want to print your spreadsheet and how you want to print the spreadsheet by setting the different options in this dialog box. Set your printing options for your spreadsheet by following the steps below.

Flag Article

Instructions

Difficulty: Easy

Things You’ll Need:

Microsoft Excel 2003

Step1

Start Microsoft Excel and open a spreadsheet that you would like to print.

Step2

Choose the "File" button and click "Print" to bring up the "Print" dialog box.

Step3

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.

Step4

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.

Step5

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.

Step6

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.

Step7

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.