Adding Header and Footer in Microsoft Excel is easy. Not only can you add text as Header / Footer, but also any image, worksheet name, time and date, page numbers and more. If you want to add Header and Footer to your worksheets, here’s how.
Open the Excel worksheet in that you want to add a Header/Footer to and click on Insert tab.
Then click on Header and Footer button in the Text section.
It will shift from Normal to Page Layout view with a cell selected where you can add Header. Type whatever you want in the header section and click on any other cell.
Not only can you add text as header, but also images, page numbers, file path and more. To do so, click on the header and select Design tab under Header & Footer tools.
Click on Picture (or any other element you want to add) under Header & Footer Elements and browse the image you want to use as Header. It will show you &[Picture] in the tab, so don’t worry about it and click on any other cell.
It will show you the image header like this example of the groovyPost logo.
Now, click on Go to Footer in the Navigation section.
Similarly, you can add anything you want here (Page number, time, etc.)
If you’re using Microsoft Word and want to add page numbers, check out my article here.