Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I edit headers/footers for an entire workbook?
Currently I am selecting each page in the workbook and editing each one --
there must be a faster way! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I edit headers/footers for an entire workbook?
Of course there is! :)
Select each sheet (tab) while holding the Ctrl key. Once you have your array of worksheets selected, goto File | Page Setup | Headers and Footers ... you know how to do it. From there, after you Ok out of that, just right-click any selected sheet and click Ungroup Sheets. HTH -- Regards, Zack Barresse, aka firefytr, (GT = TFS FF Zack) To email, remove the NO SPAM. Please keep correspondence to the board, as to benefit others. "On Line All The Time" <On Line All The wrote in message ... Currently I am selecting each page in the workbook and editing each one -- there must be a faster way! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I edit headers/footers for an entire workbook?
You can group the sheets (click on the first tab and ctrl-click on subsequent
tabs). Then File|page setup and change the headers/footers. Remember to ungroup the sheets (just rightclick on any of the grouped sheets and select ungroup sheets) or you may damage your workbook. Almost anything you do to a one sheet (of a group) is done to the rest of the sheets in that group. On Line All The Time wrote: Currently I am selecting each page in the workbook and editing each one -- there must be a faster way! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I FORMAT AN ENTIRE WORKBOOK ALL AT ONCE? | Excel Worksheet Functions | |||
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK? | Excel Worksheet Functions | |||
How to Search for word in the Entire Workbook | Excel Discussion (Misc queries) | |||
Excel should let me set the print default to "Entire Workbook". | Setting up and Configuration of Excel | |||
Unprotect Workbook | Excel Discussion (Misc queries) |