Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Printing Table headings at the top of every page
This is frustrating me to no end. I have a simple table with column headings
and I wish to re-print the column headings at the top of page 2 and page 3. I even see a place in the set-up dialogue box to enable me to do this, but it is greyed out. Why? And, more importantly, how do I tell Excel about the two rows I have devoted to column titles? |
#2
|
|||
|
|||
Do it in File=PageSetup, not in print preview.
then entry would be $2:$3 which you can enter by selecting in the sheet if you do it through page setup under the file menu. -- Regards, Tom Ogilvy "jayceejay" wrote in message ... This is frustrating me to no end. I have a simple table with column headings and I wish to re-print the column headings at the top of page 2 and page 3. I even see a place in the set-up dialogue box to enable me to do this, but it is greyed out. Why? And, more importantly, how do I tell Excel about the two rows I have devoted to column titles? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing Recto/Verso | Excel Discussion (Misc queries) | |||
Printing same table on reverse side of all pages. | Excel Discussion (Misc queries) | |||
Pivot table - printing specific data | Excel Discussion (Misc queries) | |||
Automatically print all page contents in pivot table. | Excel Worksheet Functions | |||
Can I invert a table so row headings are now column headings etc | Excel Worksheet Functions |