Cell references have changed???

E

Excel_Oz

Hi All,

For some reason my Excel has changed the cell references to another
format, i.e. instead of being cell A1, it has changed to R1C1. Is
there a way to change this back to be the cell references that I am
use to dealing with?

Thanks in advance!!
 
S

ShaneDevenshire

Hi,

Choose Tools, Options, General, and uncheck R1C1 reference style

If this helps, please click the Yes button
 

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

de-apply names 2
hlookup with the sheet name is a reference from another cell 2
Word VBA to update cross-referencing 0
Excel 2007: Column Reference changed from Alpha to Numeric, ? 2
Need Adaptable Macro 9
Unable to set FormulaArray property of the Range class 2
Nested cell references? 1
Conditional Formatting to Compare Two Sheets of Data 1

Top