ExcelBanter - HOW TO CHAGE COLUMN ADDRESS FROM NUMBERS TO ALPHABETS

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - HOW TO CHAGE COLUMN ADDRESS FROM NUMBERS TO ALPHABETS (https://www.excelbanter.com/excel-discussion-misc-queries/172286-how-chage-column-address-numbers-alphabets.html)

koneru

HOW TO CHAGE COLUMN ADDRESS FROM NUMBERS TO ALPHABETS

I have column addressing as numbers, how to change to alphabets ?

Gary''s Student

HOW TO CHAGE COLUMN ADDRESS FROM NUMBERS TO ALPHABETS

Tools Options... General cler the R1C1 reference style checkbox.
--
Gary''s Student - gsnu200764

"koneru" wrote:

I have column addressing as numbers, how to change to alphabets ?

Bob Phillips

HOW TO CHAGE COLUMN ADDRESS FROM NUMBERS TO ALPHABETS

ToolsOptionsGeneral and untick the R1C1 reference style checkbox

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"koneru" wrote in message
...
I have column addressing as numbers, how to change to alphabets ?

All times are GMT +1. The time now is 10:48 AM.