View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default My columns switched from letters to numbers, how do i fix?

Tools|Options|General tab
Uncheck R1C1 reference style.

This is picked up from the first workbook you open in that session of excel.
You'll want to save the workbook after the change.

Kmerkle wrote:

My columns switched from letters to numbers, how do i fix?


--

Dave Peterson