| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
My spreadsheet shows 1, 2, 3... instead of A, B, C, for columns
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
My spreadsheet shows 1, 2, 3... instead of A, B, C, for column
Thank you!!! That was exactly it! Not sure how that box got checked, but I
won't worry about that for now. "Peo Sjoblom" wrote: 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count # of times the same number shows up in Excel spreadsheet | Excel Worksheet Functions | |||
| Spreadsheet shows the formula in the cell but doesn't calculate | Excel Discussion (Misc queries) | |||
| Excel Spreadsheet Shows Nothing! | Excel Discussion (Misc queries) | |||
| A cell in an excel spreadsheet that does not print but shows in pr | Excel Discussion (Misc queries) | |||
| when I enter 5000 the spreadsheet shows 500. Why? | Excel Discussion (Misc queries) | |||
Hybrid Mode
