Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007... fix column headings from numbers back to letters
My column headings have mysteriously changed from alpha (letters) to numbers.
How do I change the column headings back to letters? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007... fix column headings from numbers back to letters
Change this setting:
Office buttonExcel OptionsFormulasWorking with formulasuncheck R1C1 reference styleOK -- Biff Microsoft Excel MVP "Kathleen Kent" <Kathleen wrote in message ... My column headings have mysteriously changed from alpha (letters) to numbers. How do I change the column headings back to letters? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007... fix column headings from numbers back to letters
1. Click the Office button and then click on Excel Options. Excel displays
the Excel Options dialog box. 2. At the left side of the dialog box, click Formulas. 3. If you want to use R1C1 format, select the R1C1 Reference Style check box; if you want to use A1 format (the default for Excel), clear the check box. 4. Click on OK. "Kathleen Kent" wrote: My column headings have mysteriously changed from alpha (letters) to numbers. How do I change the column headings back to letters? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 column headings changed to numbers? want letters back | Excel Discussion (Misc queries) | |||
How do I get Excel column headings to be letters not numbers? | Excel Discussion (Misc queries) | |||
nedd to change column headings from numbers back to letters | New Users to Excel | |||
How do i change column headings back to letters in excel? | Excel Discussion (Misc queries) | |||
Excel column headings from numbers to letters | Excel Discussion (Misc queries) |