#1   Report Post  
Posted to microsoft.public.excel.misc
Amanda Lynn
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Duke Carey
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Sloth
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default 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
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
Print Column Headings Mark D. Brown, MSW Setting up and Configuration of Excel 2 January 9th 06 07:13 PM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
Positioning Numeric Values Resulting from 6 Column Array Formula Sam via OfficeKB.com Excel Worksheet Functions 2 January 5th 06 02:03 AM
Lookup Table Dilemma Karen Excel Worksheet Functions 2 June 10th 05 08:22 PM
move column headings from row to column EducatingMom Excel Worksheet Functions 1 June 3rd 05 05:06 PM


All times are GMT +1. The time now is 09:01 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"