ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   In Excel how do I convert back from having row and column NUMBERS. (https://www.excelbanter.com/excel-discussion-misc-queries/13195-excel-how-do-i-convert-back-having-row-column-numbers.html)

Willem Duyvesteyn

In Excel how do I convert back from having row and column NUMBERS.
 
For unknown reasons the row and column numbering has changed from say "C7"
and "D10" to "R7C3" and "R10C4", presumanly "R" menas Row and "C" means
Column. When I want to say multiply C7 by 10 with the result reporting in
cell D10, the cell formula becomes: 10*R[-3]C[-1].

I don't care for this system, and I just want to get back to my old system.
How do I do that?

Thank you

Willem Duyvesteyn

Dave O

This is an easy fix: you may have accidentally changed a setting while
clicking about the menu.

Please click Tools Options General and de-select "R1C1 Style".



All times are GMT +1. The time now is 08:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com