Thread: My spreadsheet shows 1, 2, 3... instead of A, B, C, for columns
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
  
Posts: 964
Default My spreadsheet shows 1, 2, 3... instead of A, B, C, for columns
Toolsoptionsgeneral and clear R1C1 reference style

--


Regards,


Peo Sjoblom

"Culleoka" wrote in message
...
Suddenly my excel spreadsheets went from normal -- displaying numbered
rows
and alphebetized columns, to displaying numbered rows and columns, even in
spreadsheets I had previously created. The formulas in the cells look
completely crazy, which I assume is a by-product of this problem. For
example =R[-2]C[-1]*RC[-1]. Which should read =G28*G30. I have no idea
how
to fix this. Help.


Reply With QuoteReply With Quote