Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Set print area on several pages at once in Excell Workbook?
How can I set the print area on several pages of an Excell workbook at one
time instead of having to set it one page at a time? |
#2
|
|||
|
|||
You would have to write a macro to do this.
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "willow" wrote in message ... How can I set the print area on several pages of an Excell workbook at one time instead of having to set it one page at a time? |
#3
|
|||
|
|||
When you have the workbook open, there is a blank square above where the row
numbers are located. If you click on that little square your page will highlight as well as all of the pages in your workbook. Any changes you make when all of these are highlighted will affect the entire workbook. Shirley "willow" wrote: How can I set the print area on several pages of an Excell workbook at one time instead of having to set it one page at a time? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Clear Print Area | Excel Discussion (Misc queries) | |||
Volatile print area | Excel Discussion (Misc queries) | |||
Print area will only go up to 101 pages | Excel Discussion (Misc queries) | |||
set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
Printing - Have to set print area 1 column further than necessary | Excel Discussion (Misc queries) |