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.
Step 3: Select the Header & Footer option in the Text section at the right side of the window.
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.
Step 5: Select the location where the picture is stored.
Step 6: Browse to the picture and select it. Once added, you should see the &[Picture] text shown in the image below.
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.
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.