I want consecutive page numbers on all 4 excel sheets, but I want different headers for all 4 sheets.
Is there a way to do this?
I want consecutive page numbers on all 4 excel sheets, but I want different headers for all 4 sheets.
Is there a way to do this?
Do you mean sheets within the same workbook? At least thru Excel 2003, if you highlight multiple sheets and print them, the page numbers will be consecutive like you want. Just set up each header as you want them; each sheet can have a different header/footer as long as you include page number in all of them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks