Frozen rows

  • Thread starter Thread starter Old_skills_lost
  • Start date Start date
O

Old_skills_lost

I have created a workbook that has three frozen rows at the top of the page.
Is there a way to start numbering the rows below those 3 first.
I.E.

XDate
XJim Glass huts
XSales record
 
For appearance sake..............................

You can enter =ROW(-3) in A4 then copy down.

Then uncheck Tools>Options>View>Row and Column Headers.

BUT for the sake of formulas, A4 is still A4 no matter that it says 1.


Gord Dibben MS Excel MVP
 
I'm lost, I tried the formula but it gives me an error in formula.
--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.


Gord Dibben said:
For appearance sake..............................

You can enter =ROW(-3) in A4 then copy down.

Then uncheck Tools>Options>View>Row and Column Headers.

BUT for the sake of formulas, A4 is still A4 no matter that it says 1.


Gord Dibben MS Excel MVP
Click to expand...
 
I think Gord may have meant to write this...

=ROW()-3

Rick


Learning Excel said:
I'm lost, I tried the formula but it gives me an error in formula.
Click to expand...
 
Back
Top