| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
alter column ref
my column references are displayed in numeric rather than alphabetic. eg. the
first column is 1, instead of A. Can anyway help me? thanks Kaz |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
alter column ref
Excel 2003:-
ToolsOptionsGeneralSettingsUncheck the R1C1 reference style and give ok. Excel 2007:- Press Alt+T+OFormulasWorking with formulas Uncheck the R1C1 reference style and give ok. Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Kaz" wrote: my column references are displayed in numeric rather than alphabetic. eg. the first column is 1, instead of A. Can anyway help me? thanks Kaz |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
alter column ref
Go into Excel Options and uncheck R1C1 Reference Style.
-- Regards Dave Hawley www.ozgrid.com "Kaz" wrote in message ... my column references are displayed in numeric rather than alphabetic. eg. the first column is 1, instead of A. Can anyway help me? thanks Kaz |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
alter column ref
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 "Kaz" wrote in message ... my column references are displayed in numeric rather than alphabetic. eg. the first column is 1, instead of A. Can anyway help me? thanks Kaz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alter pivot with code | Excel Discussion (Misc queries) | |||
| Alter mulitple Vlookups at once | Excel Discussion (Misc queries) | |||
| How to alter width of columns in Column Charts? | Charts and Charting in Excel | |||
| How can I alter the rounding rules? | Excel Worksheet Functions | |||
| Randomly alter a column of names | New Users to Excel | |||
Hybrid Mode
