How to Add a Picture to the Header in Excel for Office 365

Adding pictures to a file is something that many people will associate with Microsoft Word or Powerpoint before the associate it with Excel, but there are many reasons why adding images to a spreadsheet can be useful.

Whether you have a listing of products that your company sells and prospective customers want to see what they’re buying, or you are keeping an inventory of a personal collection, the ability to add images to your cells can be useful.

But what if you are creating a spreadsheet for your work, and one of the requirements is to include the company logo in the header? This can be tricky if you’ve never had to do it before. Our guide below will show you how to add a picture to the header in Excel so that it appears on every printed page of the spreadsheet.

How to Insert a Picture into an Excel Header

The steps in this article were performed in the Excel for Office 365 version of the application.

Step 1: Open your file in Excel.

Step 2: Click the Insert tab at the top of the window.

click the Insert tab

Step 3: Select the Header & Footer option in the Text section at the right side of the window.

click the Header and Footer button

Step 4: Choose the section of the header where you want the image, then click the Picture button in the Header & Footer Elements section of the ribbon.

how to add a picture to a header in Excel for Office 365

Step 5: Select the location where the picture is stored.

find the location of the stored picture

Step 6: Browse to the picture and select it. Once added, you should see the &[Picture] text shown in the image below.

text indicating picture in Excel header

If you click inside one of the cells in the spreadsheet you will be able to see what the picture will look like with its current settings.

In many cases, that picture is probably going to be larger that you thought. You can adjust the size of the picture in the header by clicking the Format Picture button next to the Picture button from Step 4 above, then adjusting the Height and Width accordingly.

how to change the size of a picture in an Excel header

Trying to record a macro, but you can’t figure out how? Find out how to add the Developer tab in Excel for Office 365 to gain access to some additional features of the application, including macros.