Thread: Frozen rows
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Learning Excel Learning Excel is offline
external usenet poster
 
Posts: 98
Default 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