Excell Question

[Ron P. Reagan]

Can you rename the actual A, B, C etc cells at the top of the spreadsheet? I want to create labels for each collumn, but if I write them in A1, B1, C1, etc, they wont print past the first page.

How can I fix this problem.

 

[warpus]

What do you mean "won't print past the first page"?

 

[Ron P. Reagan]

I mean if I have a very large spreadsheet (say, 300 rows, which will take several pages), the top row, (A1, B1, C1, D1), which have the Column titles, won't be on page 2. I need a single row to appear on every single page.

 

[kcwong]

Assuming you're not using Ribbon, but using the good old menu.

File | Page Setup
Go to Sheet tab

There's a "Print titles" section, with a box called "Rows to repeat at top". Click the box's button and select a range (select your header rows). Press OK to close.

You can then check the results in print preview.

 

[Zelig]

Or if you're using the useful menu:

Page Layout > Page Setup
Sheet tab

There's a "Print titles" section, with a box called "Rows to repeat at top". Click the box's button and select a range (select your header rows). Press OK to close.



Actually renaming the columns or rows can't be done, and it seems to me that it could cause confusion in locating a cell. (Instead of cell C14, navigate to cell Weight14, etc.)