Columns and rows are numbered

[Slugger133]

For some really strange reason lately, when I'm working in Excel both my rows
and columns are numbered 1,2,3,4,5....This makes it really difficult to deal
with . How do I get excel to stop doing this I want my columns to go back to
being lettered A,b,c,d, etc....Anyone else ever have this happen or know how
to fix it. It's annoying. Thanks

 

[Guest]

Tools - options - general- R1C1 style- UNTICK.

 

[Frank Kabel]

Hi
Go to Tools-Options-General and uncheck the box marked "R1C1 reference
style"

 

[Bob Phillips]

http://www.xldynamic.com/source/xld.xlFAQ0003.html
My Columns Are Numbers Not Letters

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)