Column Headings

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Helen Trim - 24 Mar 2005 09:24 GMT

A colleague has Excel opening with the column headings as
numbers instead of letters.

Has anyone come across this before? How did it happen and
how can we change it back?

Thanks
Helen

Reply to this Message

Alan Perkins - 24 Mar 2005 09:43 GMT

Hi Helen,

It sounds like your colleague has R1C1 reference style selected. To get rid
of it, select
Tools | Options from the menu

Then in the dialog that appears, select the General tab, and uncheck the
"R1C1 Refernce style" option (in Excel 2002 it's the first option under
"settings")

HTH

Alan P.

>A colleague has Excel opening with the column headings as
> numbers instead of letters.
[quoted text clipped - 4 lines]
> Thanks
> Helen

Reply to this Message

Helen Trim - 24 Mar 2005 10:15 GMT

That's it, thanks.

Helen
x

>-----Original Message-----
>Hi Helen,
[quoted text clipped - 21 lines]
>
>.

Reply to this Message