Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Headers in Excel
I am trying to use the first row of the document to repeat for each page.
However, I have gone into File, page setup and then clicked on row and column for printing and then print and I only get the headings of the columns on the first page printed. How do I get the column headings to show on each page -- Lynne |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Headers in Excel
Lynne,
If I'm understanding you correctly, you should go to Page Layout, Page Setup, click on the Sheet tab, put cursor in "repeat rows at top" then select the top rows you would like repeated. click ok. -- GA "Lynne" wrote: I am trying to use the first row of the document to repeat for each page. However, I have gone into File, page setup and then clicked on row and column for printing and then print and I only get the headings of the columns on the first page printed. How do I get the column headings to show on each page -- Lynne |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Headers in Excel
hi
filesetupsheet tab file in the "rows to repeat at top:" with the row number ie $1:$1 regards FSt1 "Lynne" wrote: I am trying to use the first row of the document to repeat for each page. However, I have gone into File, page setup and then clicked on row and column for printing and then print and I only get the headings of the columns on the first page printed. How do I get the column headings to show on each page -- Lynne |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Headers in Excel
One worksheet...........rows to repeat at top.
Cannot be done across multiple worksheets if that's what you're trying to do. Gord Dibben MS Excel MVP On Wed, 20 Aug 2008 12:29:17 -0700, Lynne wrote: I am trying to use the first row of the document to repeat for each page. However, I have gone into File, page setup and then clicked on row and column for printing and then print and I only get the headings of the columns on the first page printed. How do I get the column headings to show on each page |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Headers in Excel
Hi GA,
Where do I get into Page layout? I have been going in under "File, page setup, sheet". -- Lynne "GA@EC" wrote: Lynne, If I'm understanding you correctly, you should go to Page Layout, Page Setup, click on the Sheet tab, put cursor in "repeat rows at top" then select the top rows you would like repeated. click ok. -- GA "Lynne" wrote: I am trying to use the first row of the document to repeat for each page. However, I have gone into File, page setup and then clicked on row and column for printing and then print and I only get the headings of the columns on the first page printed. How do I get the column headings to show on each page -- Lynne |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Headers in Excel
Hi FSt1 - that worked great. Thanks.
How well do you know word (older versions and newer versions)? Lynne -- Lynne "FSt1" wrote: hi filesetupsheet tab file in the "rows to repeat at top:" with the row number ie $1:$1 regards FSt1 "Lynne" wrote: I am trying to use the first row of the document to repeat for each page. However, I have gone into File, page setup and then clicked on row and column for printing and then print and I only get the headings of the columns on the first page printed. How do I get the column headings to show on each page -- Lynne |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Headers in Excel
hi
i can type words and letters in it. sometimes complete sentences. but beyond that, i am a novice to word. regards FSt1 "Lynne" wrote: Hi FSt1 - that worked great. Thanks. How well do you know word (older versions and newer versions)? Lynne -- Lynne "FSt1" wrote: hi filesetupsheet tab file in the "rows to repeat at top:" with the row number ie $1:$1 regards FSt1 "Lynne" wrote: I am trying to use the first row of the document to repeat for each page. However, I have gone into File, page setup and then clicked on row and column for printing and then print and I only get the headings of the columns on the first page printed. How do I get the column headings to show on each page -- Lynne |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Headers in Excel | Excel Discussion (Misc queries) | |||
Excel headers | Excel Worksheet Functions | |||
headers in Excel | Excel Discussion (Misc queries) | |||
Headers in Excel | Excel Discussion (Misc queries) | |||
Excel Headers | New Users to Excel |