Excel > Excel 2003 Foundation > Printing a worksheet

Printing the worksheet

There are various print options available when printing including selected areas of a page, printing a chart, and setting the number of copies to print.

Quick print

Click the Print icon on the Standard toolbar to print all the worksheets of the open workbook using the default settings.

Print settings

The Print settings are changed in the Print dialogue box.

To open the Print dialogue box, click File > Print or press Ctrl + P.

The default settings are to print one copy of every page for the current worksheet. If necessary you can:

1. Select a different printer from the Name: list box
2. Specify the pages that you wish to print by using the From: and To: spin boxes in the print range panel
3. From the Print what panel click Selection to only print the selected range on the worksheet, or Entire workbook to print every worksheet in the file
4. Set the number of copies from the Copies panel

After adjusting the settings as necessary, click Ok to print.

Printing a chart

1. Select the chart on the worksheet
2. Click File > Print or press Ctrl + P
3. Ensure Selected chart is selected in the Print what panel of the Print dialogue box



Adjust any settings as necessary

4. Click Ok

Print multiple worksheets

1. Select the worksheets you want to print by clicking on each sheet tab whilst holding down the Ctrl key on the keyboard
2. Click File > Print or press Ctrl + P
3. Active sheet(s) should be selected in the Print what panel

Adjust any settings as necessary

4. Click Ok

Using page breaks Excel 2003 Foundation quiz

Guides