View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How can I change column titles back to numbers?

In xl2003 menus:
Tools|Options|General tab|uncheck R1C1 reference style.

Gamer wrote:

When I created a current spreadsheet it had the normal alphas as column
headings. Now for some reason (don't know what I did) they have changed to
numbers and now the cell address for A1 is R1C1. How can I change it back?


--

Dave Peterson