| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format Column with horizontal alphabet label
I using Microsoft Excel 2003 SP2, I have this problem when I opened new
spreadsheet, the horizontal column appear as number e.g 1,2,3 ---- Default should be a alphabet label. Existing spreadsheet is OK, horizontal column appear as alphabet label and vertical row appear as number label. Is there any special setting to be done on MS Excel? Regards! Raymond Chang |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format Column with horizontal alphabet label
Raymond
ToolsOptionsView tab and uncheck "R1C1 reference style" should put you back on track. Mike Rogers "Raymond Chang" wrote: I using Microsoft Excel 2003 SP2, I have this problem when I opened new spreadsheet, the horizontal column appear as number e.g 1,2,3 ---- Default should be a alphabet label. Existing spreadsheet is OK, horizontal column appear as alphabet label and vertical row appear as number label. Is there any special setting to be done on MS Excel? Regards! Raymond Chang |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format Column with horizontal alphabet label
Hi Raymond
goto Tools -- Options -- General and uncheck "R1C1 Reference Style" that should do the trick. hth Carlo On Dec 18, 2:06 pm, Raymond Chang wrote: I using Microsoft Excel 2003 SP2, I have this problem when I opened new spreadsheet, the horizontal column appear as number e.g 1,2,3 ---- Default should be a alphabet label. Existing spreadsheet is OK, horizontal column appear as alphabet label and vertical row appear as number label. Is there any special setting to be done on MS Excel? Regards! Raymond Chang |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format Column with horizontal alphabet label
Hi Raymond,
Try this when you open a new excel workbook or you find such a setting in the existing workbook you can simply go to. Menubar/Tools/Options/General Tab/Uncheck R1C1 Reference style. This will enable the columns to have alphabets instead of 1,2,3... Thanks -- Suleman Peerzade "Raymond Chang" wrote: I using Microsoft Excel 2003 SP2, I have this problem when I opened new spreadsheet, the horizontal column appear as number e.g 1,2,3 ---- Default should be a alphabet label. Existing spreadsheet is OK, horizontal column appear as alphabet label and vertical row appear as number label. Is there any special setting to be done on MS Excel? Regards! Raymond Chang |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto format cell to enter data alphabet in column | Excel Worksheet Functions | |||
| Label Format to Column Format | Excel Discussion (Misc queries) | |||
| autofill alphabet in column | New Users to Excel | |||
| How can I fill in a column with the alphabet | Excel Discussion (Misc queries) | |||
| Alphabet sequencing in a conditional format | Excel Discussion (Misc queries) | |||
Linear Mode
