| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Column headers numbers instead of letters
someone sent me an excel file with the columns labeled as numbers instead of
letters, so cell A1 shows up as R1C1. Now every file I open has this format. Can someone please help me change it back to normal? -- Hursh |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column headers numbers instead of letters
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 "Hursh" wrote in message ... someone sent me an excel file with the columns labeled as numbers instead of letters, so cell A1 shows up as R1C1. Now every file I open has this format. Can someone please help me change it back to normal? -- Hursh |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Column headers numbers instead of letters
Hi,
Excel remembers the first file you open in a session and keeps that reference method. Tools|options - general tab and un-check R1C1 Mike "Hursh" wrote: someone sent me an excel file with the columns labeled as numbers instead of letters, so cell A1 shows up as R1C1. Now every file I open has this format. Can someone please help me change it back to normal? -- Hursh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| column headers appear as numbers not letters | Excel Discussion (Misc queries) | |||
| Why did my Excel column headers change from letters to numbers? | Excel Discussion (Misc queries) | |||
| column headers changed from letters to numbers, how do I change ba | Excel Discussion (Misc queries) | |||
| Change Excel column headers from numbers to letters | Excel Discussion (Misc queries) | |||
| How to switch column headers from numbers back to letters? | Excel Worksheet Functions | |||
Hybrid Mode
