column names - chane from numbrts back to A- z
 

Another user of an excel sheet I created has changed the column names from
the alphabetic ones to numbers making the transfer of cells by thier ref.
difficultt . Instead of reading ref A1 for example it shows R1C1. Any ideas
how i can change it back - have searched help with no success

Go into Tools/Options/General and uncheck the R1C1 reference style box

Best rgds
Chris Lav

"genie" wrote in message
...
Another user of an excel sheet I created has changed the column names from
the alphabetic ones to numbers making the transfer of cells by thier ref.
difficultt . Instead of reading ref A1 for example it shows R1C1. Any
ideas
how i can change it back - have searched help with no success

Hi,
Maybe TOOLS/OPTIONS/GENERAL tab and uncheck R1C1 reference style

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=475639