#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 21
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 21
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 21
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Headers in Excel Linda Excel Discussion (Misc queries) 1 June 24th 08 08:25 PM
Excel headers Karissa Excel Worksheet Functions 6 September 12th 07 10:56 PM
headers in Excel DouglasGrantPhD Excel Discussion (Misc queries) 4 August 18th 07 03:46 PM
Headers in Excel rab Excel Discussion (Misc queries) 1 March 23rd 05 12:59 AM
Excel Headers Angelo New Users to Excel 1 March 15th 05 10:52 PM


All times are GMT +1. The time now is 10:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"