Lock a row at top for titles of columns?

[Guest]

Is there a way to lock the top row that contains the description of columns

 

[Guest]

Hi bart-

Make sure you are in Normal View (_not_ in Print Preview) & go to File>Page
Setup. On the Sheet page specify what Row(s) to repeat at top.

HTH |:>)

 

[Canopus]

I do not have a printer installed, nor want to nor will ever have. I use
Excel as a database then send my creation via email. I would like my title
row to not be numbered at all (or maybe "A") So that the row numbers
accurately reflecr the number of entries - one loses track when getting to
say, row #87, and one forgets to subtract 1.

 

[Gord Dibben]

Freeze row 1 by selecting A2 and Window>Freeze Panes.

Insert a column left of your data and in A2 enter =ROW()-1

Drag down as far as you wish.

Tools>Options>View. Uncheck "Row and column headers"

I think you have to have a printer installed.

Excel bases its settings on the default printer.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

But.....................

That won't change the actual real row address, just the display.


Gord

 

[Felicity11]

On the Sheet page - I have tried to tell it to freeze row 1 but If I type in
a 1 then it
says "reference not valid" If I type a1; IV1 it says formula contains
errors - so how do I tell it to keep row 1 at the top?

 

[Peo Sjoblom]

Use $1:$1 or just select it by clicking on that funny looking sheet icon to
the right of the little box and it will take you to the sheet, then click on
row 1 in the row header

--


Regards,


Peo Sjoblom