Home |
Search |
Today's Posts |
#1
|
|||
|
|||
any way to redisplay column headings after page break?
I have a worksheet which can sometimes go to more than one page.
Is there a way to have the column headings get added automatically after a page break? Gerald |
#2
|
|||
|
|||
Gerald, if this is for printing have a look at file, page setup, sheet, rows
to repeat at top and select the row you want -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Gerald Morris" wrote in message ... I have a worksheet which can sometimes go to more than one page. Is there a way to have the column headings get added automatically after a page break? Gerald |
#3
|
|||
|
|||
Gerald: For printing, we use File--Page setup--Sheet tab and choose the
Rows to Repeat at Top. For viewing, click on the cell just below your headings and in column A. Hit Window--Freeze Panes. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Gerald Morris" wrote in message ... I have a worksheet which can sometimes go to more than one page. Is there a way to have the column headings get added automatically after a page break? Gerald |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TYPING COLUMN HEADINGS IN EXCEL! | Excel Discussion (Misc queries) | |||
Printing the last column on every page printed. | Excel Discussion (Misc queries) | |||
how do you change column headings in excel? | Excel Discussion (Misc queries) | |||
Column headings | Excel Worksheet Functions | |||
pivot table row vs column headings | Excel Worksheet Functions |