| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
My columns in excel are numbered rather than lettered-how to fix?
How do I fix this?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
My columns in excel are numbered rather than lettered-how to fix?
hi
you didn't say what version xl you are using so.... 2003 and earlier on the menu bartoolsoptionsgeneral tabuncheck R1C1 reference 2007 Office buttonExcel optionsformulasuncheck R1C1 reference regards FSt1 "Ladybug" wrote: How do I fix this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
My columns in excel are numbered rather than lettered-how to fix?
Go to the Tools menu, choose Options, then the General tab. There,
uncheck the "R1C1 reference style" setting. Cordially, Chip Pearson Microsoft Most Valuable Professional, Excel, 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com On Mon, 1 Mar 2010 12:53:01 -0800, Ladybug wrote: How do I fix this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel columns are now numbered instead of lettered | Excel Discussion (Misc queries) | |||
| Why are my columns numbered instead of lettered? | Excel Discussion (Misc queries) | |||
| Columns are Numbered rather than lettered? | New Users to Excel | |||
| Why are columns in some Excel files numbered instead of lettered? | New Users to Excel | |||
| How do I convert numbered columns to lettered columns? | Excel Discussion (Misc queries) | |||
Hybrid Mode
