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
 

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

Column/Row headings gone! 2
VLOOKUP return cell location and hyperlink 0
Hide Rows or Columns with +/- button above row/column label headin 2
Locate merged cells to sort on 3 columns 2
Excel Concatenate with line breaks but ignore blank cells 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Calculate the position of a formula and number of cells from it 2
matching columns to find differences. 0

Back
Top