How to Make Headers In Excel [In 2 Easy Ways]

Whether It’s a company name, logo, page number, sheet name, file name, current date, or something else, we need to put it on the header. 

So that when we print the Excel sheet, the name or logo is at the top. And we don’t have to insert that in every page of the printed sheets manually.

To do that, we need to learn how to make headers in Excel. 

First, click on the “Insert” ribbon > Select the “Text” option on the far right side of the ribbon > And click on the “Header & Footer” option. It will open the headers in the Page Layout view. Or press “Alt + N + ZT + H1”.

There is another way to open the headers within two clicks, which I’ll show in the following sections.

Way #1: Make Headers In Excel From the Insert Ribbon

Let’s start with a real-life example. You have a general ledger or something where you want to put the company logo or name on every page when you want to print those pages.

Now, you want to make headers for that, and I’ll tell you exactly how to do that with pictures.

Step #1: Click on the “Insert” ribbon

How to Make Headers In Excel

Step #2: Go to the far right side of the ribbon > Click on the “Text” option > And click on the “Header & Footer”

How to Make Headers In Excel. Insert ribbon. Text option and then header and footer

The layout of the page will change, and it will display like this. Or you can press the “Alt + N + ZT + H1” shortcut to open the header and footer options in Excel.

Add your header (Company logo, name, current date, file path)

At the top of the page, you will see three boxes aligned left, middle, and right. You can add anything, such as the company logo or name. You can type in your company name or something else in these boxes. 

But, if you want to add a picture, page number, sheet name, or file name in the header box, the process is different. 

You can also see a new ribbon named “Header & Footer” added to the ribbon panel.

Click on that, and you will see a bunch of options, such as;

  • Page Number.
  • The number of pages.
  • Current Date.
  • Current Time.
  • File Path.
  • File name.
  • Sheet Name.
  • Picture.
Headers options

You can add anything of these you want. If you want to add a picture in the header, click on the “Picture” option. It will show a box like this.

upload your picture to add it on the header

Select your picture, company logo, or whatever you want to put in the header.

Sometimes, the picture size could be larger like this.

How to Make Headers In Excel

Now, you need to resize it. Go to the “Header & Footer” ribbon again. 

resize the picture in your header

Click on the “Format Picture” option. And it will open a box like this where you can resize the height or width of the picture, among other options.

picture resize in header in excel

Resize the picture and click ok. Press “Ctrl + P” to go to the print option to see if the logo, company, or whatever you inserted in the header is suited.

Way #2: Make Headers in Excel Within Two Clicks

There is another more straightforward way to open the “Header & Footer” option within two clicks.

You will find Zoom and three-page view options ( Normal, Page Layout, Page Break Preview) at the bottom left corner of every Excel sheet.

Page layout option open the header option in excel

Click on the “Page Layout” option to open the “Header & Footer” option. That’s the first click.

add your header

When you’re on the page payout, the “Header and Footer” option will automatically open. Just click on the Header box and insert the logo, name, date, or something. That’s the second click.


As I showed, you can make headers in Excel in two ways.

Way #1: Go to the “Insert” ribbon > Click on the “Text” option > Click on the “Header & Footer” option. Or press Alt + N + ZT + H1.

Way #2: Click on the “Page Layout” option at the bottom right corner of the sheet > Click on the header option at the top of the page.

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *