Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Columns with # designation
Our company has an Excel document that appears to have been formatted for
excel from something else. The rows and columns both have numbers. If you open this document all new documents you make have # for rows and columns until you open an old document that has letters and numbers, then everything is great. What is up with this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Columns with # designation
Tools|Options|General Tab
Uncheck R1C1 Reference style. Excel will pick up this setting from the first workbook you open in that session of excel. swynne wrote: Our company has an Excel document that appears to have been formatted for excel from something else. The rows and columns both have numbers. If you open this document all new documents you make have # for rows and columns until you open an old document that has letters and numbers, then everything is great. What is up with this? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Columns with # designation
This is an Excel-wide setting, which means it is applied to all open
workbooks in that instance of Excel. You can change it (again, for all open workbooks): ToolsOptionsGeneral, uncheck R1C1 Reference style -- Kind regards, Niek Otten "swynne" wrote in message ... Our company has an Excel document that appears to have been formatted for excel from something else. The rows and columns both have numbers. If you open this document all new documents you make have # for rows and columns until you open an old document that has letters and numbers, then everything is great. What is up with this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Columns with # designation
Great. Thanks for the help. I would have looked for an hour.
"swynne" wrote: Our company has an Excel document that appears to have been formatted for excel from something else. The rows and columns both have numbers. If you open this document all new documents you make have # for rows and columns until you open an old document that has letters and numbers, then everything is great. What is up with this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort the data in 8 columns by two of the columns? | Excel Worksheet Functions | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |