Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
page setup
I am trying to use page setup for all the sheets in a workbook by selecting
all sheets and then going to page setup but the feature is 'grayed out'. The freeze pane feature also does not work when I choose all sheets in the work book. Any Suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
page setup
No can do, must be done specifically for each sheet. Even in a macro, you
have to loop through the sheeets one by one (For Each ws in myBook)... -- Please remember to indicate when the post is answered so others can benefit from it later. "JJ@ARC" wrote: I am trying to use page setup for all the sheets in a workbook by selecting all sheets and then going to page setup but the feature is 'grayed out'. The freeze pane feature also does not work when I choose all sheets in the work book. Any Suggestions? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
page setup
After selecting all sheets do not try to use page setup when in Print
Preview mode. Regular page setup mode will allow multiple sheets to be setup. Gord Dibben MS Excel MVP On Thu, 23 Jul 2009 07:21:03 -0700, JJ@ARC wrote: I am trying to use page setup for all the sheets in a workbook by selecting all sheets and then going to page setup but the feature is 'grayed out'. The freeze pane feature also does not work when I choose all sheets in the work book. Any Suggestions? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
page setup
Not true.
Page setup can be done on multiple selected sheets without a macro. Gord Dibben MS Excel MVP On Thu, 23 Jul 2009 13:25:01 -0700, KC hotmail com <kcrippstein<atdot wrote: No can do, must be done specifically for each sheet. Even in a macro, you have to loop through the sheeets one by one (For Each ws in myBook)... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Page layout - page setup - items disabled | Excel Discussion (Misc queries) | |||
FORMAT EXCEL WORKBOOK (PAGE SETUP) ALL AT ONCE INSTEAD OF BY PAGE | Excel Discussion (Misc queries) | |||
Page Setup when saving a worksheet as a web page | Excel Discussion (Misc queries) | |||
HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE | Excel Worksheet Functions | |||
Under Page Setup the page option of Ledger - for Office XP | Excel Discussion (Misc queries) |