Can't find cell location!

  • Thread starter Thread starter Billie
  • Start date Start date
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.
 
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
 
Back
Top