January 1, 2008

Why Are These Columns Numbered?

Here's a little tidbit that comes from a reader's question!

The reader was having difficulty with MS Excel's column labeling cialis wiki feature. Instead of letters for column headers, she had numbers.

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

It was driving her crazy, because 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!

Yes, it can be fixed!

To retrieve your beloved letter headings, simply begin with Excel's Options.

For older versions of Excel, they're found via the Tools menu, Options choice.

In the Options dialogue window, you're looking for the General tab.

In Excel 2007, you need the Excel Options button, which is located in the bottom right corner of the Office Button menu.

You need the Formulas section under Excel's options.

In any version, you'll need to uncheck the "R1C1 reference style" box.

Click OK.

Poof!

Your missing letters have been returned. If only everything could be so easy to retrieve!

Permalink • Print • Comment

Leave a comment

You must be logged in to post a comment.

Made with WordPress and Semiologic • Sky Gold skin by Denis de Bernardy