Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Headings
How do I get the headings to print on each page, without actually having to
type it in at the beginning of each page. This will not work since I am constantly adding to each page. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Headings
Under File-Page Setup go to the Sheet tab and in the box that reads "Rows to
repeat at top" use, for eaxample, 1:1 (repeats row 1) or 1:5 (repeats rows 1 thru 5) "Amanda Lynn" wrote: How do I get the headings to print on each page, without actually having to type it in at the beginning of each page. This will not work since I am constantly adding to each page. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Headings
File-Page Setup-Sheet Tab-Select "Rows to repeat at top"
"Amanda Lynn" wrote: How do I get the headings to print on each page, without actually having to type it in at the beginning of each page. This will not work since I am constantly adding to each page. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column Headings
Try this:
File|Page Setup|Sheet tab Set your Print Titles Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Amanda Lynn" wrote: How do I get the headings to print on each page, without actually having to type it in at the beginning of each page. This will not work since I am constantly adding to each page. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Column Headings | Setting up and Configuration of Excel | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
move column headings from row to column | Excel Worksheet Functions |