Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I use the same footer for multiple worksheets in same workboo.
Is there a way to format multiple worksheets in a workbook to have the same
custom footer without having to setup each worksheet separately? |
#2
|
|||
|
|||
There's a couple of ways.
If you already have a sheet set-up with your footer, select that sheet. Now, hold <Ctrl, and click in the tabs of all the other sheets that you wish to have the same footer. When they're all selected (Grouped - tabs are white), and the main sheet's name is also "bold", meaning it's the sheet of focus, then: <File <PageSetup <OK And *all* the selected sheets will have the same footer. The caveat here, is that *all* the sheets will *also* have all the rest of the Page Setup "settings" as that of the main sheet. The other option is to select all the sheets in the same way as before from the very beginning, before other setup options are chosen. Then, go into Page Setup, create your custom footer, and then "Ungroup" the sheets before you create other individual Setup options for each sheet. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Bigkahuna" wrote in message ... Is there a way to format multiple worksheets in a workbook to have the same custom footer without having to setup each worksheet separately? |
#3
|
|||
|
|||
Thanks for your help on this.
"Bigkahuna" wrote: Is there a way to format multiple worksheets in a workbook to have the same custom footer without having to setup each worksheet separately? |
#4
|
|||
|
|||
Thanks for the feedback.
-- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "Bigkahuna" wrote in message ... Thanks for your help on this. "Bigkahuna" wrote: Is there a way to format multiple worksheets in a workbook to have the same custom footer without having to setup each worksheet separately? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting a footer with a top border-line | Excel Discussion (Misc queries) | |||
data entry on multiple worksheets | Excel Discussion (Misc queries) | |||
Multiple Worksheets and Print Merge function | Excel Discussion (Misc queries) | |||
Linked worksheets | Excel Discussion (Misc queries) | |||
Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) |