Frozen rows
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" wrote:
For appearance sake..............................
You can enter =ROW(-3) in A4 then copy down.
Then uncheck ToolsOptionsViewRow and Column Headers.
BUT for the sake of formulas, A4 is still A4 no matter that it says 1.
Gord Dibben MS Excel MVP
On Thu, 17 Jan 2008 18:20:00 -0800, Old_skills_lost
wrote:
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
----------
1
2
3
|