"How To Excel" Mini-Tutorials|
"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.
- Select the first worksheet you want to print.
- Select the range of cells that you want to print.
- 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.
- 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.
- 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)