Thread: How to change numbered columns to letters?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default How to change numbered columns to letters?
With XL2003 or earlier, click on Tools | Options | General tab,
unclick R1C1 reference style, then click OK.

Hope this helps.

Pete

On Dec 6, 12:17*am, anwillia
wrote:
My Excel spread sheets used to have letters across the top adn numbers down
the left side. *Now there are numbers both across the top and down the left
side. *How can I get back to the lettered columns?

Reply With QuoteReply With Quote