how create column headings in header in excel

March 15, 2011 at 10:31:38
Specs: Windows XP
I have a price book that will have various products and variable prices with each product.

I have a large number of pages of this price list, and I want the column heading to stay the same for each of the pages even though the products and prices will change below it.

Because of the fact that additional products/prices will be added over time, I want the column headings to stay at the top of each printed page without having to manually manipulate every time it's printed.

So is it possible to put these column headings into the 'Header'? Or is there another way to accomplish this task?

Thank you!

See More: how create column headings in header in excel

Report •

March 15, 2011 at 17:23:11
The process will vary depending on the version of Excel that you have... but as long as long as the "column headings are located in the row above the data, there is a very simple solution.

2007: Goto the Page Layout Ribbon. In the "Page Setup" group, you should see "Print Titles". Select this and a dialog box will open. In the dialog box the "Sheet" tab at the top should be selected (if for some reason it is not, click on it yourself.) There you will see two options that say, "Rows to repeat at top:" and below that "columns to repeat at left" If you just need the content a the first or first couple rows just enter the range here. For example: If your headings are in Row 1, all you need to do is click on the little icon on the far right of the "rows to repeat at top" and your cursor will turn into a solid black arrow. ALL YOU NEED TO DO IS SIMPLY CLICK ON ROW 1...or if you need Rows 1-3, just drag and select rows 1-3.

once you indicate which rows you want to repeat, just click OK. The range will be automatically entered for you. Then go to Print Preview to make sure this is what you're looking for.

For 2003, the steps are identical except for the first part obviously (no ribbons in 03!!) just open the Page Setup Box and indicate which rows and/or columns you need to be printed on each page!


Report •
Related Solutions

Ask Question