Top Nav

How to Add a Header and Footer in Microsoft Excel

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.

Excel Header Footer 1

Then click on Header and Footer button in the Text section.

Excel Header Footer 2

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.

Excel Header Footer 3

Not only can you add text as a 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.

Excel Header Footer 4

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.

Excel Header Footer 5

It will show you the image header like this example of the groovyPost logo.

Excel Header Footer 6

Now, click on Go to Footer in the Navigation section.

Excel Header Footer 7

Similarly, you can add anything you want here (Page number, time, etc.)

Excel Header Footer 8

If you’re using Microsoft Word and want to add page numbers, check out my article here.

More Reading:

,

One Response to How to Add a Header and Footer in Microsoft Excel

  1. Chris June 8, 2012 at 11:48 am #

    Thanks !

Leave a Reply