See all How-To Articles

How to Insert a Logo in Excel & Google Sheets

This tutorial demonstrates how to insert a logo in Excel and 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 the cell where you want to put your logo.

 

insert logo 9

 

  1. 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

 

  1. The Insert Picture window appears. From there, choose the picture you want to insert and click Insert.

 

insert logo 10

 

As a result, the logo is 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 appears 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

 

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

 

insert logo 5

 

  1. This brings up the Header window. Choose the section (left, center, or right) where you want the logo, and click on the Insert Picture icon.

 

insert logo 7

 

  1. After clicking on the Insert Picture icon, the Insert Picture window appears. From there, choose the picture and click on Insert.

 

insert logo 10

 

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

 

insert logo 11

 

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

 

insert logo 12

 

  1. After you click OK, your logo is 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 appears 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 serves as header.

  1. Select a cell in a first row. Then in the Menu go to View > Freeze > 1 row.

 

insert picture header 5

 

  1. 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

 

  1. Now, in the Menu, go to Insert > Image > Image in cell.

 

insert picture header 7

 

  1. The Insert image window appears. Choose Upload, then Browse to upload the picture you want to insert.

 

insert picture header 8

 

The logo appears in the cell you selected.

 

insert logo 14

 

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

 

insert logo 15