View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bpeltzer bpeltzer is offline
external usenet poster
 
Posts: 171
Default How can change column title back to alphabet (A,B,C..)

From the menu bar, Tools Options, click General, deselect 'R1C1 reference
style' and click OK. (If it's already deselected, try to select, then OK,
then deselect and OK).

"Ray" wrote:

In my worksheet the column title are numbers (1,2,3....) and I would like to
change back to alphabetic (A,B,C...). Can some one help my. Thank you very
much.