Want graphics in the header of an Excel spreadsheet? Sounds so easy to do, right? At first this task looks like a piece of cake, but after a while I realized that when I actually want to see the header on every page that I print, I ended up scratching my head.
My first try only printed the header on the first page but I wanted to have the header printed on all the pages. I will show you how to do this properly without pasting the header on every page break.
First open a new workbook in Excel then insert your choice of picture or image by clicking on the Insert Tab then click Picture
· Browse to the location of the picture or image and then click Insert.
· After the picture or image has been inserted, re size it to your preference.
· After resizing the picture or image, click on the Page Layout tab then click Print Titles.
· In the Page Setup window, choose the Sheet tab then click the icon of Rows to repeat at top. This is the most critical step since now we are telling Excel to print a repeated title on every page.
· You will see on the dialogue box $1:$4 because the image occupies cell 1 to 4. After selecting the cells occupied by the image hit enter then click ok on page setup window.
· Click Print > Print Preview to see the graphic header. The header will be displayed on every page of your worksheet.
· The figure below shows the example preview of each page in the workbook.