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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

page setup 2
copy footer without copying page setup 2
Save, save as, page setup dimmed out in unprotected excel sheet? 3
how to applythe page setup setings to allsheets in afile in excel 1
In excel how do I copy page setup format from one wsht to another 1
Copy & paste macro for multiple worksheets 8
Exel 2007: Export to pdf ignores page setup with SP2 installed 4
Printing Sheets in a Workbook 3

Top