Converting column headings from numbers to letters

[gchapman]

I just opened up a new excel spread sheet and all of the columns are now numbered instead of being lettered. I opened up other spread sheets that I had saved and they all have numbered columns instead of letters like they used to.

I must have hit a wrong button for this global change to have occured.

How do I switch back to lettered columns instead of numbers.

Thanks.

Lost in Bethesda

[ConneXionLost]

Click the Office button and click Excel Options which you will find at the end near Exit Excel.

Go to Formulas tab and under Working with formulas, Check or uncheck R1C1 reference style to use it or to change it to A1 reference style.