Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I freeze my column labels so that they print every page?
I have a question, and I hope that you can help me.
In Excel, I know how to freeze panes so that I can view the column titles/labels as I scroll - however, do you know how to freeze them so that they will automatically print in a set position as column titles on each page? When I manually copy and paste them, each time I add rows it offsets the titles from the top, and as this is a sheet on which I am constantly updating data, it becomes a hassle. I have also thought about formatting them as a header, but there are too many column headings and headers do not allow for precise positioning as headings. I would appreciate any help that you could provide me on this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I freeze my column labels so that they print every page?
Look at File | Page Setup and then the [Sheet] tab. There is an entry for
"Rows to Repeat..." If you will identify the row(s) with your title(s) in it/them, then they will print at the top of each page in both print preview and actual printouts without you having to copy them all through the sheet. "canefish" wrote: I have a question, and I hope that you can help me. In Excel, I know how to freeze panes so that I can view the column titles/labels as I scroll - however, do you know how to freeze them so that they will automatically print in a set position as column titles on each page? When I manually copy and paste them, each time I add rows it offsets the titles from the top, and as this is a sheet on which I am constantly updating data, it becomes a hassle. I have also thought about formatting them as a header, but there are too many column headings and headers do not allow for precise positioning as headings. I would appreciate any help that you could provide me on this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I print the column headers in a freeze pane on all pag | Excel Discussion (Misc queries) | |||
Cannot print a complete page of labels | Excel Discussion (Misc queries) | |||
Print headings/labels on every page | Excel Discussion (Misc queries) | |||
Print row and headings/labels on every page in Excel? | Excel Discussion (Misc queries) | |||
How do I print a partial page of labels using Mail merge? | Excel Discussion (Misc queries) |