Column heading changing

J

JudithJubilee

I have a delegate who has a spreadsheet that when he has
emailed it to a collegue the A, B C, etc on the columns
has changed to 1,2,3 etc. This only happens on 1 computer
the others are fine.

Has anyone seen this problem before and knows how to
change it back???

Thank in advance

JudithJubilee
 
N

Niek Otten

Tools>Options>General, Uncheck R1C1 reference style

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
D

DDM

"This only happens on 1 computer "

Judith, have that person select Tools > Options > General. Deselect the R1C1
Reference Style check box. Click OK.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com
 
Top