Adding a picture to a worksheet's header or footer
Click on the video icon for a demonstration.
- Open Excel and inside a blank worksheet click on the menu File | Page Setup.
- Click on the tab Header/Footer and then the button "Custom Header."
- To insert a picture click in of the section boxes provided.
- Click on the "Picture" button and then navigate to the picture's location.
- Click on the Print Preview button. If the picture is too big, you can either change the spreadsheet's top margin or resize the picture.
- To resize the picture, click on the button "Page Setup." Place the cursor back in the section where the picture was inserted and then click on the button "Format Picture."
- When the Format Picture dialog box opens, verify that the following boxes are checked, "Lock aspect ratio" and "Relative to original picture size."
- Adjusting either the height or width will maintain the picture's proportion. Click on "OK" twice.