How do I change column addresses from numeric to alpha?

S

Salsabueno

The old style Excel was formated so that alpha characters were the column
markers and the row characters were numeric. It was easy to reference a cell
such as 4D or 26RR telling you to go to the 4th row and column D or the 26th
row and column RR. The version of Excel I have is 2003 and all of the row
and column references are numeric. Can the column markers be changed
universally?

Thanks.
 
D

Dave Peterson

Tools|Options|General tab|Uncheck R1C1 reference style.

This is a setting that excel picks up from the first workbook that it opens in
that session. So if you have a workbook that has that setting (maybe a
co-worker likes R1C1 reference style) and you're unlucky enough to open it as
the first workbook, then you'll want to remember how to change it.

Ps. Older versions had the same feature. Believe it or not, lots of people
like it. Go figure, huh?
 

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

How do I change my column designator from Numeric to Alpha? 1
Converting RIC1 code to letter Column/Numeric Row 5
Delete row if cell in column "E" has 1 or more alpha characters 3
How do I create Alpha-Numeric Numbering in Word 07? IE: Word_1.0 1
Column and Row labels are numeric 2
Worksheet has numeric column headings. Change to alpha headings? 1
How do I quickly create toc in 70-pg doc that was styled in Normal 3
How: reset the column headings from numeric to alphabetic? 1

Top