Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I change the page setup for an entire workwork?
I'm creating an Excel 2003 workbook containing ten worksheets. Can I change
the page setup for all sheets at once instead of each individually? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I change the page setup for an entire workwork?
Yep. Select all your worksheets and then go into page setup. Any change you
make to one will be replicated across them all. To select multiple worksheets: click the left-most worksheet tab and then shift-click on the right-most worksheet tab. Alternatively use CTRL-click on individual tabs. "Wease1967" wrote: I'm creating an Excel 2003 workbook containing ten worksheets. Can I change the page setup for all sheets at once instead of each individually? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I change the page setup for an entire workwork?
Change the setup for the first sheet. then highlight all the sheets in the
workbook with this sheet as the first. then select File-- page setup and then hit OK. Normally the pagesetup of the first page will automatically get copied on all the sheets. You may need to set the print range individually on each sheet though. however the page setup parameters including the header, footer etc will get copied. See if this works. "Wease1967" wrote: I'm creating an Excel 2003 workbook containing ten worksheets. Can I change the page setup for all sheets at once instead of each individually? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I change the page setup for an entire workwork?
In article , ?B?ZGpjMTcxMQ==?= wrote:
Yep. Select all your worksheets and then go into page setup. Any change you make to one will be replicated across them all. To select multiple worksheets: click the left-most worksheet tab and then shift-click on the right-most worksheet tab. Alternatively use CTRL-click on individual tabs. "Wease1967" wrote: I'm creating an Excel 2003 workbook containing ten worksheets. Can I change the page setup for all sheets at once instead of each individually? .. and remember to select only one page before you continue after doing this. You can make a huge cock up by selecting multiple sheets and forgetting that you have done so :) Bruce ---------------------------------------- I believe you find life such a problem because you think there are the good people and the bad people. You're wrong, of course. There are, always and only, the bad people, but some of them are on opposite sides. Lord Vetinari in Guards ! Guards ! - Terry Pratchett Caution ===== followups may have been changed to relevant groups (if there were any) |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I change the page setup for an entire workwork?
Yes. Double-click any sheet tab name and choose "Select all." Make the
changes in Page setup, then be sure to "Ungroup sheets" by right-clicking again. While you have all sheets selected, you can also enter common headers and footers for all of them at once--such as page numbers or dates. "Wease1967" wrote in message ... I'm creating an Excel 2003 workbook containing ten worksheets. Can I change the page setup for all sheets at once instead of each individually? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change cell size from page to page on the same worksheet | Excel Worksheet Functions | |||
In excel how do I copy page setup format from one wsht to another | Excel Discussion (Misc queries) | |||
how dio i copy page setup formats from 1 spreadsheet to another? | New Users to Excel | |||
How to change default page setup for pivot tables? | Excel Discussion (Misc queries) | |||
Change number of columns mid page? | Excel Worksheet Functions |