Excel columns are now numbered instead of lettered

K

Kelly

Suddenly the columns in my Excell worksheet are numbered, not lettered. My
old worksheets are fine. However, when I open the program to a fresh
spreadsheet or go to this current one, both rows and columns are numbered.
My current worksheet has correct "answers" for formulas, but the actual
formulas are now really weird. Help! I've tried Help, Detect & Repair.
 
K

Kelly

Awesome! It worked. Now I can't help but wonder how in the world that
setting got changed in the first place. It was so weird--I had forwarded it
to other computers and it would be "normal." Thanks so much for your help!
 
D

Dave Peterson

Excel picks up this setting from the first workbook opened in that session.

If you happen to open a workbook that was saved in R1C1 reference style as the
first workbook in that session, you'll see those numbers.

So you'll want to remember how to toggle this setting.
 
J

jtoy

For MS Excel 2007 versions go to:
Excel Options > Formulas > Working with formulas > Uncheck R1C1 reference
style.
 

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

columns are numbered???? 1
My spreadsheet shows 1, 2, 3... instead of A, B, C, for columns 2
Why are my columns numbered instead of lettered? 6
Columns and rows are numbered 3
columns should be lettered??? 1
My Excel columns are now denoted with numbers not letters, why? 1
Why are my excel worksheet columns are Numbered not Alpha 3
Why does my excel have numbered columns and rows 1

Top