- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -

Now Why Are These Columns Numbered?

Posted By On November 22, 2004 @ 11:57 AM In MS Excel | Comments Disabled

Now Why Are These Columns Numbered?

Here’s a little tidbit that comes from a reader question.

The reader was having difficulty with the Excel labeling of the columns. Instead of letters for column headers, she had numbers!

image

(Did you notice the cell name given in the corner? Obviously not what most of us are used to.)

It was driving her crazy since it didn’t match the other systems she worked on at school and / or work.

So – what’s the deal here? Is the one system just “out of whack” or what?

Can it be “fixed”?

Good questions! (Thanks for asking since it brings me to the answer – which we all knew I was going to give anyway.)

Yes – it can be fixed. (Yeah!)

To retrieve our beloved letter headings simply begin with the Tools menu, Options choice.

In the Options window you’re looking for the General tab.

image

Now uncheck the R1C1 reference style box.

Click OK.

And Poof!

Your missing letters have been returned.

If only everything could be so easy to retrieve.


Article printed from Worldstart's Tech Tips And Computer Help: http://www.worldstart.com

URL to article: http://www.worldstart.com/now-why-are-these-columns-numbered/