Switch Column & Row numbering

D

David

In Excel 2003 is there a way to switch the row numbers 1,2,3... with the
column lettering a,b,c... or show the first two rows as 0 (or nothing) and
start the row numbering from line 3?
I have an document that the first two rows are frozen & scrolling starts
from row 3, information is updated each day. The trouble is people looking at
the data see row 3 as the 3rd (3.10.04) and not as the 1st (1.10.04) etc.
 
H

Helen

David said:
In Excel 2003 is there a way to switch the row numbers 1,2,3... with the
column lettering a,b,c... or show the first two rows as 0 (or nothing) and
start the row numbering from line 3?
I have an document that the first two rows are frozen & scrolling starts
from row 3, information is updated each day. The trouble is people looking at
the data see row 3 as the 3rd (3.10.04) and not as the 1st (1.10.04) etc.
Click to expand...

Hi

Do this>>>

TOOLS
OPTIONS
VIEW
In the section 'Window Options'
'Row & Column Headers' Uncheck the box
Click OK

That should help :O)

Helen
 
D

David

Helen

Thanks, you have just made me smile

Helen said:
Hi

Do this>>>

TOOLS
OPTIONS
VIEW
In the section 'Window Options'
'Row & Column Headers' Uncheck the box
Click OK

That should help :O)

Helen
Click to expand...
 
Top