Microsoft Excel – adding company logo to header

When printing off an Excel spreadsheet, or indeed emailing it to a client, you may want to include your company logo as part of the header.

To insert a header, click the Insert tab, then in the Text group, click Header & Footer. (Alternatively, click on the Page Layout icon to the right of the Status Bar.).

Click in the Header section, in the area where you want to insert the icon, then on the Header & Footer tab, and in the Header & Footer Elements group, click Picture. Locate the logo you want to insert, then click Insert. Until you move your cursor away from the area you inserted the logo, all you will see is &[Picture].

Move your cursor to another part of the header and your logo will be revealed. It may well be too large, in which case, click on your logo again, then in the Header & Footer Elements group, click Format Picture. The Format Picture dialog box will be displayed. Click on the Size tab and select a suitable % in the Height and Width boxes. Click OK.

It may then be the size you require but still be covered by some of the data in your worksheet. In that case, go to File – Print and click Page Setup, then go to the Margins tab. Make the Top margin bigger, then click OK. This should mean you can see both logo and data appropriately.

Find out more about our Microsoft Excel training in the London area or our Microsoft Excel training in Wiltshire, Dorset, Somerset and Hampshire.

About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 for every time someone says "If only I'd known that." ....
This entry was posted in Excel 365, Microsoft Excel, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s