How to Print Worksheet Groups in Excel

Save

Once you are finished formatting your Microsoft Excel 2007 worksheet group, you can print the worksheet group all at the same time. This is a quick way to print selected worksheets with making only a simple change to the print settings within Excel. Follow the steps below to find out how you can quickly print worksheet groups in Excel.

Things You'll Need

  • Microsoft Excel 2007
  • Printer
  • Start Microsoft Excel 2007 and open an existing workbook that contains worksheets that are grouped together that you are ready to print.

  • Verify that the worksheets are grouped together. The sheet tabs, which are located in the lower left corner of the screen, should be white indicating the corresponding worksheets are in a group.

  • Click on one of the white sheet tabs to select the worksheet group before you print it. This will set the worksheet group as the active selection within Excel.

  • Highlight and click the "Office" button in the top left corner of the Excel screen and click "Print" to bring up the "Print" dialog box.

  • Select "Active sheet(s)" in the "Print what" section of the "Print" dialog box. This will instruct Excel to print only the worksheets in the group.

  • Change any other print settings including the printer being used, number of copies and properties for your specific printer.

  • Complete the process by clicking the "OK" button. This will print the worksheets in the group and close the "Print" dialog box. You can now ungroup the worksheets if you are finished formatting them.

Promoted By Zergnet

Comments

You May Also Like

Related Searches

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!