| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
column designation has started to appear as numbers
All of a sudden the designation of columns has appeared as numbers (as well
as the rows) on some spreadsheets. It makes it difficult to track formulas. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
column designation has started to appear as numbers
Tools|Options|General tab|Uncheck R1C1 Reference style
Bert wrote: All of a sudden the designation of columns has appeared as numbers (as well as the rows) on some spreadsheets. It makes it difficult to track formulas. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
column designation has started to appear as numbers
Thank you very much. I was in the Options section last week and must have inadvertently checked that box. It has had me frustrated since. Bert "Dave Peterson" wrote: Tools|Options|General tab|Uncheck R1C1 Reference style Bert wrote: All of a sudden the designation of columns has appeared as numbers (as well as the rows) on some spreadsheets. It makes it difficult to track formulas. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
column designation has started to appear as numbers
This setting is picked up from the first workbook you open in that excel
session. If you share a workbook with a co-worker and that co-worker likes R1C1, you may find that you have to toggle this setting again (and again and again...). You'll want to remember how to do it (or just yell at that co-worker!) Bert wrote: Thank you very much. I was in the Options section last week and must have inadvertently checked that box. It has had me frustrated since. Bert "Dave Peterson" wrote: Tools|Options|General tab|Uncheck R1C1 Reference style Bert wrote: All of a sudden the designation of columns has appeared as numbers (as well as the rows) on some spreadsheets. It makes it difficult to track formulas. -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change the column designation from a numeric to an alpha | Excel Discussion (Misc queries) | |||
| cell designation | Excel Discussion (Misc queries) | |||
| Columns with # designation | Excel Discussion (Misc queries) | |||
| Binocular search tool, Excel, loses column designation at "Find" | Excel Discussion (Misc queries) | |||
| How do I eliminate the "A" designation in column "1" and substitu. | New Users to Excel | |||
Hybrid Mode
