Jun 15 2021 10:09 AM
Jun 15 2021 11:19 PM
Headers and footers in a worksheet
You can add headers or footers at the top or bottom of a printed worksheet in Excel. For example, you might create a footer that has page numbers, the date, and the name of your file. You can create your own, or use many built-in headers and footers.
Headers and footers are displayed only in Page Layout view, Print Preview, and on printed pages. You can also use the Page Setup dialog box if you want to insert headers or footers for more than one worksheet at a time. For other sheet types, such as chart sheets, or charts, you can insert headers and footers only by using the Page Setup dialog box.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Jun 16 2021 05:11 AM
Jun 16 2021 05:15 AM
Jun 16 2021 05:21 AM
Here is an example file with a header
Would you like to merge left, right and middle headers? ..in a header?
Jun 16 2021 07:35 AM
Jun 17 2021 01:08 AM
Here is a suggested solution with VBA ... as many headers as you want :))
I hope that it will help you despite the difficult birth.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here