Excel > Excel 2007 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

You can print all the worksheets of the workbook using its default settings by clicking the Quick Print button.Quick Print button

This button is not displayed on the Quick Access Toolbar by default and needs to be added. To add the Quick Print button, click the Customise Quick Access Toolbar arrow and select Quick Print.

Adding the Quick Print button to the toolbar

Print settings

The Print settings are changed in the Print dialogue box.

To open the Print dialogue box, click the Office Button and then click Print or press Ctrl + P.

Change print settings

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 the Office Button and then click Print or press Ctrl + P
  3. Ensure Selected Chart is selected in the Print what panel of the Print dialogue box
  4. Printing the selected chart

    Adjust any settings as necessary

  5. 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 the Office Button and then click Print or press Ctrl + P
  3. Active sheet(s) should be selected in the Print what panel
  4. Adjust any settings as necessary

  5. Click Ok

Follow us on

Facebook  Twitter  You Tube