View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Richard O. Neville
 
Posts: n/a
Default Can I change the page setup for an entire workwork?

Yes. Double-click any sheet tab name and choose "Select all." Make the
changes in Page setup, then be sure to "Ungroup sheets" by right-clicking
again. While you have all sheets selected, you can also enter common headers
and footers for all of them at once--such as page numbers or dates.

"Wease1967" wrote in message
...
I'm creating an Excel 2003 workbook containing ten worksheets. Can I
change
the page setup for all sheets at once instead of each individually?