Frozen rows

[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

 

[Gord Dibben]

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

 

[Learning Excel]

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.

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

 

[Rick Rothstein \(MVP - VB\)]

I think Gord may have meant to write this...

=ROW()-3

Rick

I'm lost, I tried the formula but it gives me an error in formula.

 

[Learning Excel]

YES! Thanks for the correction, it works!

 

[Gord Dibben]

That's what Gord meant<g>

Thanks Rick

I think Gord may have meant to write this...

=ROW()-3

Rick