View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default how do I change cell labelling from R1C1 to A1?

Click TOOLS/OPTIONS on the menu and select the GENERAL tab. Remove the check
mark from R1C1 REFERENCE STYLE the first check box on the left side of the
tab page.
--
Kevin Backmann


"agua" wrote:

My excell is now labelling rows and columns as numbers. Instead of having
letters in the columns as usual, I prefer to say B4 when calling a cell than
R4C2. How can I change that?

thanks