Column Reference

M

mrawesomo

How do I change the column references from numbers back to letters? I.e.
instead of my cell being named A8, I show it as R8C1. How do I change my
column reference structure back to alphabetical vice numeric?
 
S

Sandy Mann

Tools > Options General uncheck R1C1 Reference style

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
F

FSt1

hi
on the menu bar....
Tools>options>general tab> uncheck R1C1 reference style
regards
FSt1
 
Top