Can't find cell location!

B

Billie

Help! Something's wrong with my excel template. The rows &
column headings are all the same! That is they're 1, 2,
3, etc.

This makes entering functions into cells impossible
because the cell location is gone too!

Can anyone help with this issue. Not sure why this has
happened.
 
C

Chip Pearson

Billie,

Go to the Tools menu, choose Options, then the General tab.
There, uncheck the R1C1 reference style setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top