Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel columns are now numbered instead of lettered
Suddenly the columns in my Excell worksheet are numbered, not lettered. My
old worksheets are fine. However, when I open the program to a fresh spreadsheet or go to this current one, both rows and columns are numbered. My current worksheet has correct "answers" for formulas, but the actual formulas are now really weird. Help! I've tried Help, Detect & Repair. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel columns are now numbered instead of lettered
Try Tools - Options - General
Uncheck R1C1 reference style "Kelly" wrote: Suddenly the columns in my Excell worksheet are numbered, not lettered. My old worksheets are fine. However, when I open the program to a fresh spreadsheet or go to this current one, both rows and columns are numbered. My current worksheet has correct "answers" for formulas, but the actual formulas are now really weird. Help! I've tried Help, Detect & Repair. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel columns are now numbered instead of lettered
Awesome! It worked. Now I can't help but wonder how in the world that
setting got changed in the first place. It was so weird--I had forwarded it to other computers and it would be "normal." Thanks so much for your help! "Barb Reinhardt" wrote: Try Tools - Options - General Uncheck R1C1 reference style "Kelly" wrote: Suddenly the columns in my Excell worksheet are numbered, not lettered. My old worksheets are fine. However, when I open the program to a fresh spreadsheet or go to this current one, both rows and columns are numbered. My current worksheet has correct "answers" for formulas, but the actual formulas are now really weird. Help! I've tried Help, Detect & Repair. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel columns are now numbered instead of lettered
Excel picks up this setting from the first workbook opened in that session.
If you happen to open a workbook that was saved in R1C1 reference style as the first workbook in that session, you'll see those numbers. So you'll want to remember how to toggle this setting. Kelly wrote: Awesome! It worked. Now I can't help but wonder how in the world that setting got changed in the first place. It was so weird--I had forwarded it to other computers and it would be "normal." Thanks so much for your help! "Barb Reinhardt" wrote: Try Tools - Options - General Uncheck R1C1 reference style "Kelly" wrote: Suddenly the columns in my Excell worksheet are numbered, not lettered. My old worksheets are fine. However, when I open the program to a fresh spreadsheet or go to this current one, both rows and columns are numbered. My current worksheet has correct "answers" for formulas, but the actual formulas are now really weird. Help! I've tried Help, Detect & Repair. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel columns are now numbered instead of lettered
For MS Excel 2007 versions go to:
Excel Options Formulas Working with formulas Uncheck R1C1 reference style. "Dave Peterson" wrote: Excel picks up this setting from the first workbook opened in that session. If you happen to open a workbook that was saved in R1C1 reference style as the first workbook in that session, you'll see those numbers. So you'll want to remember how to toggle this setting. Kelly wrote: Awesome! It worked. Now I can't help but wonder how in the world that setting got changed in the first place. It was so weird--I had forwarded it to other computers and it would be "normal." Thanks so much for your help! "Barb Reinhardt" wrote: Try Tools - Options - General Uncheck R1C1 reference style "Kelly" wrote: Suddenly the columns in my Excell worksheet are numbered, not lettered. My old worksheets are fine. However, when I open the program to a fresh spreadsheet or go to this current one, both rows and columns are numbered. My current worksheet has correct "answers" for formulas, but the actual formulas are now really weird. Help! I've tried Help, Detect & Repair. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into excel? | Excel Discussion (Misc queries) | |||
Why does my excel have numbered columns and rows | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) |