Columns have changed from letters to numbers

M

MDriggers

There's got to be a quick and easy answer to this problem. Somehow the
column designations on our Financial Secretary's computer have all changed
to numbers instead of letters. It was probably an accidental few keystrokes
or mouse clicks that did it. It makes it quite confusing to read cell
designations and makes formulas all but impossible to edit . What do I do
to change them back?

Thanks.

Morris Driggers, Minister of Music and staff tech advisor
First Baptist Church, Clinton, SC
 
A

Alan

'Tools' > 'Options' > 'General' tab, uncheck 'R1C1 Reference Style'
Regards,
Alan.
 

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

lettered columns changed to numbers 3
column changed to numbers 2
My column headings somehow changed from letters to numbers...help 1
Row headings have changed from letters to numbers. How do I undo? 2
Excel 2007: Column Reference changed from Alpha to Numeric, ? 2
How do you make the labels of the columns back to letters from numbers? 1
Columns headings have changed to numbers instead of letters 2
my columns have changed to show numbers and formula are different 3

Top