R1C1 reference

G

Guest

Excel keeps changing to the R1C1 reference style, but only in one of my
workbooks (I believe in just one of the worksheets). I keep changing it back
(Tools - Options - General - R1C1 Reference Style), but when I move or copy
cells in the workbook, it changes back to R1C1. Anyone have an idea?
 
G

Guest

Look at the
TOOLS / OPTIONS / SETTINGS
is the 'R1C1 References Style' box checked?
If not, check it then save the workbook.
Not sure if this is your issue but it's worth a try.
Good Luck,
 

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

r1c1 reference style - how to make it default 4
R1C1 Reference Style won't STAY gone? 5
How do I get Excel column headings to be letters not numbers? 3
R1C1 1
R1C1 reference style as default while opening Excel 3
R1C1 Reference file 2
How do I turn off R1C1 reference type in Excel 2007? 3
R1C1 problems - Can't change 15

Top