| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Columns are Numbers
I have an excel sheet that is listing the Columns as Numbers. How do I
switch this to being letters so the cells are listed as I35 rather than R35C9 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Columns are Numbers
Go to Tools Options General tab uncheck R1C1 reference style
"kristinm" wrote: I have an excel sheet that is listing the Columns as Numbers. How do I switch this to being letters so the cells are listed as I35 rather than R35C9 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Columns are Numbers
In xl2003 menus:
Tools|Options|General tab|Uncheck R1C1 Reference style. Excel picks up this setting from the first workbook you open in that session. If you have a co-worker who likes R1C1 Reference Style and you're unlucky enough to open a workbook that he saved as the first workbook in that session, you'll be making the same change again. kristinm wrote: I have an excel sheet that is listing the Columns as Numbers. How do I switch this to being letters so the cells are listed as I35 rather than R35C9 -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Columns are Numbers
Thank you.
"Sean Timmons" wrote: Go to Tools Options General tab uncheck R1C1 reference style "kristinm" wrote: I have an excel sheet that is listing the Columns as Numbers. How do I switch this to being letters so the cells are listed as I35 rather than R35C9 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Columns are Numbers
Thank you. Life is good again.
"Dave Peterson" wrote: In xl2003 menus: Tools|Options|General tab|Uncheck R1C1 Reference style. Excel picks up this setting from the first workbook you open in that session. If you have a co-worker who likes R1C1 Reference Style and you're unlucky enough to open a workbook that he saved as the first workbook in that session, you'll be making the same change again. kristinm wrote: I have an excel sheet that is listing the Columns as Numbers. How do I switch this to being letters so the cells are listed as I35 rather than R35C9 -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Columns are Numbers
not a poblem! Please come again. :-)
"kristinm" wrote: Thank you. "Sean Timmons" wrote: Go to Tools Options General tab uncheck R1C1 reference style "kristinm" wrote: I have an excel sheet that is listing the Columns as Numbers. How do I switch this to being letters so the cells are listed as I35 rather than R35C9 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split range of numbers in two columns to as many as numbers in ran | Excel Discussion (Misc queries) | |||
| Columns are in numbers | New Users to Excel | |||
| Find similar numbers from two columns of numbers | Excel Discussion (Misc queries) | |||
| Numbers in columns | Excel Discussion (Misc queries) | |||
| Numbers in Columns | Excel Discussion (Misc queries) | |||
Linear Mode
