Setting print area for entire workbook

S

scru_ball

I need to set the print area for every sheet in the workbook. When I tried
grouping the sheets first, my option to set the print area was disabled. Any
ideas?
 
S

scru_ball

I have 20 different workbooks each with 26 different worksheets so I would
like to find a way not to select each one individually. When I try to select
all sheets in a workbook, the option to set print area is grayed out.
 

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

how to set print area for the entire excel workbook 1
Print Area to include text box 10
How do I set a print area for every sheet in the workbook? 2
Need to print a workbook but worksheets have diff print areas 1
Set Print Area 1
Print Area Setting 1
Print Area Grayed out 1
setting page setup/print area for multiple sheets 6

Top