ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Column Headings (https://www.excelbanter.com/excel-discussion-misc-queries/74837-column-headings.html)

Amanda Lynn

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.

Duke Carey

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.


Sloth

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.


Ron Coderre

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.



All times are GMT +1. The time now is 08:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com