Thread: Column headings to numbers and row headings to alphabets?
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 Column headings to numbers and row headings to alphabets?
Try

Tools|Options|general tab
un-check R1C1

Mike

"Juliana" wrote:

Hi there,
My spreadsheet has gone crazy and now the column headings are in numbers
instead of alphabets and at the same time, the row headings are in alphabets
instead of numbers. Can anyone advice on how to rectify this?

J
Reply With QuoteReply With Quote