Set print area for entire workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I set the print area to be the same for all the pages of a workbook
at one time?

I am using MS Office Excel 2007

Thanks for any help!
 
"Group" the tabs by holding the CTRL key and clicking each tab
individually or by selecting a tab, holding the SHIFT key, and
selecting another tab (which captures all the tabs in between). Then
perform the print setup: all the selected tabs will carry that setup.

CAUTION! Remember to ungroup the tabs (by right clicking on a selected
tab and clicking Ungroup) before you make other changes, or else any
typing, formulas, etc will appear on all selected tabs.

Enjoy your weekend!
 
On my Excel setup (Excel 2003), if I group the sheets, I can get to page
setup, but setting the print area is a function which is greyed out.
Similary the File menu/ Print Area command has setting and clearing the
print area greyed out when shhets are grouped.
Which version of Excel do you have which allows the command in this
situation, Dave?
 
Using VBA code you can set the same print range and rows to repeat at top on
each sheet in grouped sheets.

For anyone interested in the code see this google search result with Dave
Peterson and myself posting. The print area code is from Bob Flanagan.

http://snipurl.com/106kz


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

Setting print area for entire workbook 1
Print Area Setting 1
Need to print a workbook but worksheets have diff print areas 1
Excel 2003 - Print Area different for same worksheet on different 1
how to set print area for the entire excel workbook 1
email as pdf print area excel 2007 1
Set Print Area & print on one page 2
Remove print area from multiples pages 1

Back
Top