Restoring columns

  • Thread starter Thread starter astral
  • Start date Start date
A

astral

Excel 2003 workbook, column have number numeraton. Cells in Name Box have
strange numeration, i.e. first row and first column in Name Box marked as
"R1C1"; 1st row and 2nd column have "R1C2" and so on. I need add formulas in
some cell, but this numeration prevent formulas work correctly.
I.e. if I want multiply, R1C2 x R1C3, I got broken formulas like
=RC[-2]*RC[-1]

Something wrong here.
 
In xl2003 menus:
Tools|Options|General tab
uncheck R1C1 Reference style

In xl2007:
Office button|Excel Options|Formulas|Working with formulas
uncheck R1C1 Reference style

This option is picked up from the first workbook you open in that session. So
if someone is saving a workbook in R1C1 reference style, and you're unlucky
enough to open that workbook first, you'll have to change it again.

Excel 2003 workbook, column have number numeraton. Cells in Name Box have
strange numeration, i.e. first row and first column in Name Box marked as
"R1C1"; 1st row and 2nd column have "R1C2" and so on. I need add formulas in
some cell, but this numeration prevent formulas work correctly.
I.e. if I want multiply, R1C2 x R1C3, I got broken formulas like =RC[-2]*RC[-1]

Something wrong here.
Click to expand...
 
Dave Peterson said:
In xl2003 menus:
Tools|Options|General tab
uncheck R1C1 Reference style

In xl2007:
Office button|Excel Options|Formulas|Working with formulas
uncheck R1C1 Reference style

This option is picked up from the first workbook you open in that session.
So
if someone is saving a workbook in R1C1 reference style, and you're
unlucky
enough to open that workbook first, you'll have to change it again.

Excel 2003 workbook, column have number numeraton. Cells in Name Box have
strange numeration, i.e. first row and first column in Name Box marked as
"R1C1"; 1st row and 2nd column have "R1C2" and so on. I need add formulas
in
some cell, but this numeration prevent formulas work correctly.
I.e. if I want multiply, R1C2 x R1C3, I got broken formulas like
=RC[-2]*RC[-1]

Something wrong here.
Click to expand...
Click to expand...
 
Back
Top