| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excell 2000--My column headings have changed from letters to numb
-- Jay F |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excell 2000--My column headings have changed from letters to numb
My column headings have changed from letters to numbers--don't know how it
happened--how can I change it back. Now, instead of "C1" I have "3,1"--confusing, isn't it? -- Jay F "Jay F" wrote: -- Jay F |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excell 2000--My column headings have changed from letters tonumb
In Excel, click on Tools | Options | General tab | uncheck the
"R1C1 reference style" box | OK. Jay F wrote: My column headings have changed from letters to numbers--don't know how it happened--how can I change it back. Now, instead of "C1" I have "3,1"--confusing, isn't it? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excell 2000--My column headings have changed from letters to n
ToolsOptionsGeneralSettingR1C1 Reference Style
Uncheck it! HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "Jay F" wrote: My column headings have changed from letters to numbers--don't know how it happened--how can I change it back. Now, instead of "C1" I have "3,1"--confusing, isn't it? -- Jay F "Jay F" wrote: -- Jay F |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excell 2000--My column headings have changed from letters to n
How can you fix the same problem but in the 2007 version?
"Gary L Brown" wrote: ToolsOptionsGeneralSettingR1C1 Reference Style Uncheck it! HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "Jay F" wrote: My column headings have changed from letters to numbers--don't know how it happened--how can I change it back. Now, instead of "C1" I have "3,1"--confusing, isn't it? -- Jay F "Jay F" wrote: -- Jay F |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excell 2000--My column headings have changed from letters to n
The same thing happens in 2007! Go to excel options/formulas/working with
formulas. Un-toggle the R!C! reference style! Thank you thank you thank you! "garfield-n-odie [MVP]" wrote: In Excel, click on Tools | Options | General tab | uncheck the "R1C1 reference style" box | OK. Jay F wrote: My column headings have changed from letters to numbers--don't know how it happened--how can I change it back. Now, instead of "C1" I have "3,1"--confusing, isn't it? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| What is formula to repeat row at top when column headings are numb | Excel Discussion (Misc queries) | |||
| Changed column width keeps reverting back to original size | Excel Discussion (Misc queries) | |||
| My excell column letters have changed to numbers. I don't want th. | Excel Worksheet Functions | |||
| Excel column headings from numbers to letters | Excel Discussion (Misc queries) | |||
Linear Mode
