How to Insert a Picture in Excel Header

Someone can feel it odd to add pictures in an Excel header. But adding images to a spreadsheet header can be necessary in many cases. When we list products of a company to sell, buyers could like to see the product which can be very useful to impress a buyer. Or maybe you are creating a spreadsheet for your work, and one of the requirements is to include the company logo in the header. It can be tricky if you are not used to doing it. This article will guide you on how to insert a picture to the header in Excel and I hope it will be a simple task for you from now on.


Download Practice Workbook

You can download the free Excel template from here and practice on your own.


Creating a Header in an Excel Worksheet

For this article, we’ll use a dataset that represents some data of an online article publisher. Now follow the steps properly to insert a Header in our Excel dataset. If you know how to do it then you can skip this part.

Create a Header to an Excel Worksheet

Steps:

  • Select the cell where you want to add a Header.
  • Then click as follows-

Insert > Text > Header & Footer

Create a Header to an Excel Worksheet

Then the Header will be visible like the image below. Now, look that the header has three boxes.

Create a Header to an Excel Worksheet

You can change the alignment of the header from the left and right direction. Press anywhere in the sheet, and you will get the margin. If you keep the mouse in the left margin then you will see an arrow sign like the image below. Click and hold the icon by using the mouse and moving to left or right according to your requirement.

You can change the right margin the same way.

Read More: How to Add Same Header to All Sheets in Excel (5 Easy Methods)


How to Insert a Picture in an Excel Header

Now let’s go forward to our main task, insert a picture in an Excel Header.

Steps:

  • From the three-part of the Header select the one part where you want to insert a picture.
  • Then click serially-

Design > Picture

Soon after a dialog box named ‘Insert Pictures’ will appear.

Insert a Picture in an Excel Header

  • Select the option where your file is located.
    My file is on my pc so I clicked ‘From a file’.

Insert a Picture in an Excel Header

Later, select the image file and press Insert.

Insert a Picture in an Excel Header

After a while, you will observe that there is text into the Header- ‘&[Picture]’. Don’t worry! just press any cell outside of the Header and you will be able to see the image then.

Insert a Picture in an Excel Header

It will look like the image below after adding the picture.

Read More: How to Insert Picture in Excel Cell Automatically


Format the Picture in the Excel Header

Formatting the picture in Excel is pretty different from MS Word or PowerPoint. Here we’ll not be able to resize the picture by dragging the mouse by selecting any corner of the picture rather will have to use a formatting dialog box. Let’s explore that.

Steps:

  • Click on the picture by using the mouse.
  • Then click as follows-

Design > Format Picture

A dialog box named ‘Format Picture’ will open up.

Format the Picture in the Header

In the Size section, you will get many options to resize the picture like- Rotation, Scaling, etc. You can easily change the height and width of your picture by just putting the required values and then just press OK. Also, there is an option to lock the aspect ratio.

Format the Picture in the Header

I changed the height and width to 80%.

In the Picture section, you can crop the image by putting values relative to the left, right, top, and bottom sides. Besides that, there are options for color grading. You can change the color, brightness, and contrast.

Here, I increased the contrast to 70%. After clicking OK you will get the formatted result.

It’s the formatted output.

Read More: How to Insert Logo in Excel Header (4 Easy Ways)


Conclusion

I hope the procedures described above will be good enough to insert pictures in Excel Header. Feel free to ask any question in the comment section and please give me feedback.


Related Articles

Mithun

Mithun

Hello! I am Md. Sourov Hossain Mithun. Welcome to my profile. Currently, I am working at Exceldemy as an Excel and VBA Content Developer. Excel is amazing software. Here I will post excel related useful articles. I am a graduate of Bangladesh University of Engineering and Technology. I love to learn new things and work with them. Thank you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo