Adding a Picture to a Header or Footer in Microsoft Excel 2010

 

In this article, we will learn how to add a picture to a header or footer in Microsoft excel 2010.

To add a picture to a Header/Footer, follow the below mentioned steps:

 

  • Click on Page Layout ribbon
  • Click on Print Titles

 
img1
 

  • The Page Setup dialog box will be displayed

 
img2
 

  • Select Header/Footer tab
  • Click on Custom Header

 
img3
 

  • Select a section (Left, Center or Right), and click on Insert Picture.

 
img4
 

  • You can either search web for image or you can attach an image from the local hard disk by selecting From a file option

 
img5
 

  • Click on Insert button after selecting the image.

 
img6
 

  • You can see in the Right section, there is a picture code will be displayed as &[Picture]
  • Click on OK
  • You will be able to see image of Tiger & Header dropdown has been changed from [none] to [&Picture]

 
img7
 

  • Click on Print Preview, and you will see image in Right corner of the Header section.

 
img8
 
Similarly, you can add image in Footer section.
 
 



3 thoughts on “Adding a Picture to a Header or Footer in Microsoft Excel 2010

  1. Wouldn’t it just be easier to use the ISERROR function nested in an IF function to print a blank space if the function produces an error? If it is done one the first formula and copied to the rest of the spreadsheet, it doesnt really take that much extra time to do. EX: =IF(ISERROR((B4*5)/S4),” “,(B4*5)/S4) or =IF(T4=””,””,IF(ISERROR((B4*5)/T4),B4*5,(B4*5)/T4)) While this may seem complicated, it covers many different errors. It is one of the most useful functions I know for making spreadsheets look professional.

  2. Wouldn’t it just be easier to use the ISERROR function nested in an IF function to print a blank space if the function produces an error? If it is done one the first formula and copied to the rest of the spreadsheet, it doesnt really take that much extra time to do. EX: =IF(ISERROR((B4*5)/S4),” “,(B4*5)/S4) or =IF(T4=””,””,IF(ISERROR((B4*5)/T4),B4*5,(B4*5)/T4)) While this may seem complicated, it covers many different errors. It is one of the most useful functions I know for making spreadsheets look professional.

  3. Thank you for your efforts, nice site with clean and precise tips. Additional image requirements with full automation can be assigned to Picture Manager For Excel which is an add-in for Excel that provides a necessary control when working with images in Microsoft Excel.

Leave a Reply

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

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>