Thread: Changing the headers on an excel worksheet from Numbers back to le
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Changing the headers on an excel worksheet from Numbers back to le
In xl2003 menus, it's:
Tools|Options|General Tab|Uncheck R1C1 Reference style

Excel picks up this setting from the first workbook you open in that session.

Maxine wrote:

Hi

I have somehow managed to change my worksheet default to have column numbers
rather than letters, and its driving me mad! Does anyone know how to change
them back?

Many Thanks

Maxine

--

Dave Peterson
Reply With QuoteReply With Quote