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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Labels Over 3-Up Image 2
Word 2016 - Difficulties Learning Style Creation/Application 0
Problem with formula for finding last greater than/less than or equal to value 2
Issues when deleting cells with multiple versions of Excel 0
Column/Row headings gone! 2
IF statement not returning correct answer 3
Problem using IF statement with dates as part of the formula 4
Automatically sort alphabetically ignoring header 2

Top