| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column labels showing as 1 2 3 4 5 instead of A B C D E - how to f
This is a weird one. Some XL files are opening with column labels being
numbered instead of lettered. But not all of them. (all files are pre 2007 version) Is there some way to change the column labels from numbers back to letters in these files? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column labels showing as 1 2 3 4 5 instead of A B C D E - how to f
In Excel 2007:
Office buttonExcel OptionsFormulasWorking with formulasuncheck R1C1 reference styleOK out Other versions of Excel: ToolsOptionsGeneral tabSettingsuncheck R1C1 reference styleOK out -- Biff Microsoft Excel MVP "Geoff B" wrote in message ... This is a weird one. Some XL files are opening with column labels being numbered instead of lettered. But not all of them. (all files are pre 2007 version) Is there some way to change the column labels from numbers back to letters in these files? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column labels showing as 1 2 3 4 5 instead of A B C D E - how
Thanks for that, has solved the problem (was in Office 2007).
What is confusing me is why files are opening up with R1C1 enabled when they were not set with that originally and it is not consistant, some open this way and some don't, all files involved are pre 2007 version. Usually when you start an XL session, if the first file is set as R1C1 then all other files opened in that session follow the same rule, what is happening now is, for example, the first two files in the session are R1C1 then the next is R1CA and then the next will be R1C1. Is this a known bug or should I maybe reinstall office to see if it corrects the problem -- "T. Valko" wrote: In Excel 2007: Office buttonExcel OptionsFormulasWorking with formulasuncheck R1C1 reference styleOK out Other versions of Excel: ToolsOptionsGeneral tabSettingsuncheck R1C1 reference styleOK out -- Biff Microsoft Excel MVP "Geoff B" wrote in message ... This is a weird one. Some XL files are opening with column labels being numbered instead of lettered. But not all of them. (all files are pre 2007 version) Is there some way to change the column labels from numbers back to letters in these files? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column labels showing as 1 2 3 4 5 instead of A B C D E - how
Your understanding of how it works is correct. Why it would keep "switching"
I don't know. I haven't heard anything as far as this being a bug in Excel 2007. -- Biff Microsoft Excel MVP "Geoff B" wrote in message ... Thanks for that, has solved the problem (was in Office 2007). What is confusing me is why files are opening up with R1C1 enabled when they were not set with that originally and it is not consistant, some open this way and some don't, all files involved are pre 2007 version. Usually when you start an XL session, if the first file is set as R1C1 then all other files opened in that session follow the same rule, what is happening now is, for example, the first two files in the session are R1C1 then the next is R1CA and then the next will be R1C1. Is this a known bug or should I maybe reinstall office to see if it corrects the problem -- "T. Valko" wrote: In Excel 2007: Office buttonExcel OptionsFormulasWorking with formulasuncheck R1C1 reference styleOK out Other versions of Excel: ToolsOptionsGeneral tabSettingsuncheck R1C1 reference styleOK out -- Biff Microsoft Excel MVP "Geoff B" wrote in message ... This is a weird one. Some XL files are opening with column labels being numbered instead of lettered. But not all of them. (all files are pre 2007 version) Is there some way to change the column labels from numbers back to letters in these files? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| print worksheet without ABC and 123 labels showing? | New Users to Excel | |||
| Getting rid of labels showing zero values | Charts and Charting in Excel | |||
| Showing Data Labels with 0 as blank | Charts and Charting in Excel | |||
| Column Labels (A, B) are showing us as numbers (1,2). Please Help | Excel Worksheet Functions | |||
| Showing the Grand Total on Data Labels | Excel Discussion (Misc queries) | |||
Linear Mode
