how to do a page set up for all the sheets at once in excel workbo

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

Guest

how to do a page set up for all the sheets at once in excel workbook (such as
header, footer, page size, page orientation etc).
 
HeJa, group the sheets, click on the first sheet and hold down shift and
click on the last sheet, do your page setup and then right click on a sheet
and ungroup, all sheets should now be setup the same
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
 
Heja

Note that some of the options are not available with grouped sheets.

Print Area, Print Titles(Rows to repeat at top, Columns to repeat at left).

These are not available.

Gord Dibben 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

Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel - Problem w/ printing more than one worksheet with same sett 0
Page layout/ orientation problem 1
Diff page margins in the same sheet 2
FORMAT EXCEL WORKBOOK (PAGE SETUP) ALL AT ONCE INSTEAD OF BY PAGE 1
copy page settings to multiple worksheets in excel? 1
Close all oben workbooks at once in Excel 2007 3
How can I do "page set up" for a every page in a workbook at one . 1

Back
Top