View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Alpha column references

Try,

Tools|options|general

Uncheck R1C1 style.

Mike

"grono" wrote:

some how my excel sheet got into r1c1 format and I would like the column
references to go back to alpha. I have the new version of excel so I cannot
go to the options general tab. How can i do this?