Frozen rows
 

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

Frozen rows
 

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

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

Frozen rows
 

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

=ROW()-3

Rick


"Learning Excel" wrote in message
...
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

Frozen rows
 

YES! Thanks for the correction, it works!
--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.


"Rick Rothstein (MVP - VB)" wrote:

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

=ROW()-3

Rick


"Learning Excel" wrote in message
...
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

Frozen rows
 

That's what Gord meant<g

Thanks Rick

On Thu, 17 Jan 2008 23:04:45 -0500, "Rick Rothstein \(MVP - VB\)"
wrote:

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

=ROW()-3

Rick


"Learning Excel" wrote in message
...
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