Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Custom List Header
Hello, I am trying to make a custom header that will show up at the top of each page. I have a long list (500 rows) of information with 7 columns, and I have the headers in the cells at the top of the list, but I'd like to have the column headers show up when I print it out without having to go through and insert them at each page break (this might mess with my formulas anyway). The custom header option only has left,right, and center, and it looks like it will take a while to space the headers out to match up correctly. Is there a better way to do this? Thanks in advance. -- GeyserPeak ------------------------------------------------------------------------ GeyserPeak's Profile: http://www.excelforum.com/member.php...o&userid=20746 View this thread: http://www.excelforum.com/showthread...hreadid=385572 |
#2
|
|||
|
|||
Hi, Geyser. Why don't you use the feature built in to Excel that allows you to select rows to repeat at the top of each page? Go to FilePage Setup and on the Sheet tab, enter the row(s) you want repeated on each page and click OK. Does this help? -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=385572 |
#3
|
|||
|
|||
There is an easy way: click File Page Setup, select the Sheet tab,
and specify "Rows to Repeat At Top". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating custom list with a comma in it | Excel Discussion (Misc queries) | |||
How to set a custom header as a row from the spreadsheet? | Excel Discussion (Misc queries) | |||
Custom Header and Footer | Excel Discussion (Misc queries) | |||
how do I permanetly add custom header to excel header list? | Excel Discussion (Misc queries) | |||
Custom Header | Excel Discussion (Misc queries) |