| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel coolumn headings changed from A, B, C, etc. to 1, 2, 3
I copied all my Excel files onto a CD and then transferred them to another
computer. All the Column headers have changed from consecutive letters i.e. A, B, C etc. to consectutive numbers 1, 2, 3 etc. I cannot now use the SUM function. How can I get the letters back? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel coolumn headings changed from A, B, C, etc. to 1, 2, 3
Excel 2003:-
ToolsOptionsGeneralUncheck the R1C1 Reference Style checkbox and give ok Excel 2007:- Click the Office Ribbon Button (colorful round circle at the top Left corner)Excel OptionsFormulasWorking With Formulas Uncheck the R1C1 Reference Style checkbox and give ok. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Gabbai" wrote: I copied all my Excel files onto a CD and then transferred them to another computer. All the Column headers have changed from consecutive letters i.e. A, B, C etc. to consectutive numbers 1, 2, 3 etc. I cannot now use the SUM function. How can I get the letters back? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why have my column headings changed to numbers | Excel Discussion (Misc queries) | |||
| Excel 2003 column headings changed to numbers? want letters back | Excel Discussion (Misc queries) | |||
| Columns headings changed to numbers in all of my worksheets | New Users to Excel | |||
| Column headings changed from ABC to 123 format | Setting up and Configuration of Excel | |||
| Copying changed pivot report headings | Excel Discussion (Misc queries) | |||
Linear Mode
