Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |