R1C1 Reference Style Default

  • Thread starter Thread starter Randy Stewart
  • Start date Start date
R

Randy Stewart

My worksheets are coming up with numbers for the column names as a default. I
know how to change them back to letters but can't seem to fiqure out how to
change them back to be defaulted to letters. Any ideas?
 
Hi Randy;
Go Tools/Options/General..
Here you will see checked the R1C1 option; it is the first option here.
Uncheck it. This should do it.

Argy
 
Excel uses whatever the first workbook opened in that session uses. If you're
unlucky enough to open a workbook that's in R1C1 reference style as the first
workbook, you'll have to toggle this setting again.
 
When I open Excel it always opens with R1C1 reference style so every time I
use Excel I need to change it back. Isn't there a way to change the default
setting?
 
Nope.

If you save a workbook in A1 reference style and then make sure you open that
first, you'll be in A1 reference style.

Remember to check your personal.xls workbook, too. Maybe that one is opening
first and screwing up your plans.
 

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
How do I change default cell referencing in excel from R1C1 to A1? 1
How do I get Excel column headings to be letters not numbers? 3
Excel 2007 column references 1
R1C1 reference 1
Column headers numbers instead of letters 2
R1C1 Reference Style won't STAY gone? 5
R1C1 switching automatically. 2

Back
Top