See all How-To Articles

How to Insert a Logo in Excel & Google Sheets

In this tutorial  you will learn how to insert a logo in Excel & Google Sheets.

 

insert logo 8

 

Lock a Logo in a Cell

One option for adding a logo into a worksheet in Excel is to insert it as a picture. To lock the logo in a cell, follow the step below.

 

insert logo 1

 

1. First, select a cell where you want to put your logo.

 

insert logo 9

 

2. Now in the Ribbon, go to Insert > Pictures > This device (or you can use Stock Images or Online Pictures if you are importing pictures from there).

 

insert logo 3

 

3. The Insert Picture window will appear. From there, choose the picture you want to insert and click Insert.

 

insert logo 10

 

As a result, the logo will be inserted into the cell as a picture.

Insert a Logo Into the Header

You can also choose to insert a logo as a picture in the header, and it will appear at the top of each page when printed.

 

insert logo 8 1

 

1. First, in the Ribbon go to Page Layout and in the Page Setup group, click on the arrow in the bottom left corner.

 

insert logo 4

 

2. When you click on it, the Page Setup window appears. Click on the Header/Footer tab and choose Custom Header.

 

insert logo 5

 

3. Now you will see the Header window. (1) Choose the section (left, center, or right) where you want the logo, and (2) click on the Insert Picture icon.

 

insert logo 7

 

4. After clicking on the Insert Picture icon, the Insert Picture window will appear. From there, choose the picture you want to insert and click on Insert.

 

insert logo 10

 

5. This takes you back to the Header window, but now with the picture in the chosen section. If you need to scale the logo to fit, click on Format Picture.

 

insert logo 11

 

6. In the Format Picture window, adjust the height and width in Scale.

 

insert logo 12

 

7. After you click OK, your logo will be inserted in the header. To see how it looks, in the Ribbon, go to View > Page Layout.

 

insert logo 13

 

When you print the file, the logo will appear at the top of each page.

 

insert logo 8

 

NOTE: You can also use VBA code to insert a logo in the header.

Insert a Logo in the Header in Google Sheets

In Google Sheets, you can’t insert a picture in the header, but you can use the workaround by freezing the first row which will serve as header.

1. To do that select a cell in a first row, after that in the toolbar go to View > Freeze > 1 row.

 

insert picture header 5

 

2. Now you have – in effect – a header. To insert a logo, click on a cell where you want it to be (A1).

 

insert picture header 6

 

3. Now in the Toolbar, go to Insert > Image > Image in cell.

 

insert picture header 7

 

4. The Insert image window will appear. Choose Upload, then Browse to upload the picture you want to insert.

 

insert picture header 8

 

The logo will appear in the cell you selected.

 

insert logo 14

 

When you go to print view, you will see the final result, with the logo in the header. It will appear at the top of each page you print.

 

insert logo 15