"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

Print The Same Cell Range On Multiple Excel Worksheets


As you know, an Excel workbook can contain many individual worksheets. Often you will find that some of your workbooks are made up of multiple worksheets that are identical in every way except for the input data. For example, you may have twelve monthly sheets plus a summary sheet.

You probably already know that you can print multiple sheets by holding down the CTRL key and selecting each sheet tab you want to print (or click the first sheet tab, hold down the SHIFT key and click on the last sheet tab). Sometimes you may want to print just a small identical selection from each sheet.

Here's how:

  1. Select the first worksheet you want to print.
  2. Select the range of cells that you want to print.
  3. Hold down the CTRL key and select each of the other sheets tabs you want to print. If the sheets are all together, you can click the first sheet tab, hold down the SHIFT key and click on the last sheet tab.
  4. Select File, Print, and click the Selection option in the 'Print What' section. At this point you may want to click the Preview button to make sure you've got it right.
  5. Click OK to print.


Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.