How to insert a graphic header in Excel

Posted on April 28, 2009 at 5:30 am

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, resize 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.

· A small arrow will appear. Use this arrow cursor to determine the location of the page header. Select the start and end rows of the graphic. In the example below I chose rows 1 to 4.

· 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.

This is cool for corporate people who work with Excel workbooks a lot and have to present data to other team members or supervisiors because you can add a little bit of flair to it by adding the company logo or something similiar. Enjoy!

Ben Carigtan shows you how it’s done.

» Filed Under MS Office Tips

Comments

One Response to “How to insert a graphic header in Excel”

ertai said on : April 28th, 2009 at 7:51 am

if you’re using MS word 2007,
you can do it the easier way.
just click the view tab, the click page layout,
in the main screen, click the add to header part.
that’s it. no need to do the long steps.

hope this helps.