Lock a row at top for titles of columns?

  • Thread starter Thread starter Guest
  • Start date Start date
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 |:>)
 
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.
 
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
 
But.....................

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


Gord
 
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?
 
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
 
Back
Top