Change formula RC to Cell reference value Excel 2007

S

Smiley

How do I change the view in the formula bar for Excel 2007 to show the cell
reference values instead of the RC values? What are RC values?
 
T

Tyro

Do you mean R1, C1 reference style that you or someone working with your
copy of Excel turned on?

If so, Office Button/Excel options/Formulas/Working with formulas Uncheck
R1C1 reference style

Tyro
 

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

Copying a formula while leaving one cell fixed 1
to create a formula by removing RC[number] 2
Macro to search range for a portion of a specific value and if findit - then paste formula in anothe 2
Syntax error while applying a formula in a macro 3
To store the formula in a string 4
Macro from cell specific to whole column 4
Macro - Formula RC[?] with ? being a variable number 5
Word macro that can call cells out of Excel for a find and replace 0

Top