In Excel how do I convert back from having row and column NUMBERS.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 (e-mail address removed)
 
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".
 
You must log in or register to reply here.

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

Using Macro to Hide Rows with Certain Values 2
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Find previous number and find next number in column 4
copy cells down a column (in order) to across a row (same order?? 1
how do I excel 0
Copying with transpose and VB code 1
Paste in column B using Last row of either column B, C or D. 10
How to covert rows to columns or columns to rows. 11

Back
Top