Is there anyway to have the same header/footer print across an entire
workbook (ie multiple worksheets) without using the custom header footer on
each worksheet within the file? Thanks
Is there anyway to have the same header/footer print across an entire
workbook (ie multiple worksheets) without using the custom header footer on
each worksheet within the file? Thanks
This reply from Gord Dibben was posted a few days ago in response to a
similar enquiry:
Select the sheet with the custom header and footer.
Right-click on the sheet tab and "select all sheets".
Go into File>Page Setup>Headers and Footers.
Click on OK without doing anything else.
All sheets now have that header/footer.
Right-click and "ungroup sheets" or select any sheet but the active
sheet.
Gord Dibben MS Excel MVP
This assumes there is a custom header and footer already defined for
one sheet.
Hope this helps.
Pete
terry wrote:
> Is there anyway to have the same header/footer print across an entire
> workbook (ie multiple worksheets) without using the custom header footer on
> each worksheet within the file? Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks