page setup

J

JJ@ARC

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?
 
K

KC hotmail com>

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)...
 
G

Gord Dibben

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
 
G

Gord Dibben

Not true.

Page setup can be done on multiple selected sheets without a macro.


Gord Dibben MS Excel MVP
 
Top