How to change column heading from numerical to alphabetical?
 

Hi,
I used to have excel spreasheet which was showing columns heading in
alphabetical order ABC, since some time when I open it, it appear to have
numbers 123. How can I change it?

Thanks
Ela

How to change column heading from numerical to alphabetical?
 

Tools Options General clear R1C1 ref style
--
Gary''s Student - gsnu200734


"Ela" wrote:

Hi,
I used to have excel spreasheet which was showing columns heading in
alphabetical order ABC, since some time when I open it, it appear to have
numbers 123. How can I change it?

Thanks
Ela

How to change column heading from numerical to alphabetical?
 

Goto ToolsOptionsGeneral and uncheck R1C1 Reference Style checkbox

--
HTH

Bob

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

"Ela" wrote in message
...
Hi,
I used to have excel spreasheet which was showing columns heading in
alphabetical order ABC, since some time when I open it, it appear to have
numbers 123. How can I change it?

Thanks
Ela