View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin Vaughn
 
Posts: n/a
Default How can I change the settings on the row headers/

Sounds like you accidentally turned on R1C1 view. Go into
Tools/Options/General and uncheck R1C1 reference style.

--
Kevin Vaughn


"Ngozi Nmezi" wrote:

How can I change the section on the row header so that the cells identities
are classified by alphabets and not numbers. example A1, A2, A# and NOT C2
R28, or C2 R45 and so on. This number setting is confusing?