Inserting the same header/footer on all worksheets in a workbo
Thanks! This is great!
"PCLIVE" wrote:
Group the worksheets together. Click your first worksheet. Then while
holding Shift, click the last worksheet. The should all highlight in white
or other color that indicates the sheet is selected. Additionally, it will
show "Group" at the top next to the file name.
Then go to your header/footer settings.
HTH,
Paul
"ADP-Acctg" wrote in message
...
I have a workbook with multiple worksheets that I would like to have the
same
header/footer. Is there a way to insert the same one on each sheet
without
have to go into page set up for each sheet individually?
|