How to Insert or Delete a Header or Footer in Excel

This post will guide you how to insert or delete a header or footer in your worksheet in Excel. How to add a picture to a header or footer in Microsoft Excel.

Insert or Delete a Header or Footer


If you want to insert a header or footer into your current worksheet, you can do the following steps:

#1 go to INSERT tab, click Header & Footer command under the Text group. And the Header and Footer section will appear.

insert or delete header or footer1

#2 go to DESIGN tab under HEADER &FOOTER TOOLS, click Header command and select one Elements from the drop down menu list. If you want to add elements to footer section, just click Footer command, and select one elements as you need.

insert or delete header or footer2

#3 you should notice that one element you selected has been added into the header section.

insert or delete header or footer3

Insert a Picture to a Header or Footer


If you want to insert a picture into a header or footer in your worksheet, you can do the following steps:

#1 go to INSERT tab, click Header & Footer command under the Text group. And the Header and Footer section will appear.

#2 go to DESIGN tab under HEADER &FOOTER TOOLS, click Picture command to add a picture to the header or footer. And the Insert Pictures dialog will open.

insert or delete header or footer7

#3 select one picture from your computer or local network, you can click the Browse button to select one.

insert or delete header or footer4

#4 one text string is inserted into the selected header or footer. And then click any cell in your worksheet. You should see the image would be shown in your header.

insert or delete header or footer5

insert or delete header or footer6

 

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar