|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 19th, 2009, 09:09 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
how do I change the default name of a column from numbers to lett.
my default used to be column a, column b etc, somehow it has been changed to
column 1, column 2 etc. how do I change it back? Because of the default change it changes my formulas to sum(R[1] - C[2] etc. 
|
|
#2
November 19th, 2009, 09:27 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I change the default name of a column from numbers to lett.
In EXCEL 2007 try the following:-
Office Button / Excel Options (lower right hand side) / Formulas (2nd option down on left hand side) / Working with formulas (2nd option down on right hand side) / make sure that R1C1 reference style is not selected (that is, it does not have a green tick in it) If my comments have helped please hit Yes. Thanks! "mac" wrote: my default used to be column a, column b etc, somehow it has been changed to column 1, column 2 etc. how do I change it back? Because of the default change it changes my formulas to sum(R[1] - C[2] etc.
|
|
#3
November 19th, 2009, 09:27 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I change the default name of a column from numbers to lett.
ToolsOptionsGeneral tab, uncheck R1C1 Reference style
-- Kind regards, Niek Otten Microsoft MVP - Excel "mac" mac @discussions.microsoft.com wrote in message ... my default used to be column a, column b etc, somehow it has been changed to column 1, column 2 etc. how do I change it back? Because of the default change it changes my formulas to sum(R[1] - C[2] etc.
|
|
#4
November 19th, 2009, 09:28 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I change the default name of a column from numbers to lett.
toolsoptionsgeneralr1c1
-- Don Guillett Microsoft MVP Excel SalesAid Software "mac" mac @discussions.microsoft.com wrote in message ... my default used to be column a, column b etc, somehow it has been changed to column 1, column 2 etc. how do I change it back? Because of the default change it changes my formulas to sum(R[1] - C[2] etc.
|
|
#5
November 19th, 2009, 09:31 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I change the default name of a column from numbers to lett.
In 97-2003 toolsoptionsgeneral, then deselect R1C1 reference style
in 2007 office button, excel optionsformulas under working with formula and deselect the same check box For future posts include Excel version -- Regards, Peo Sjoblom "mac" mac @discussions.microsoft.com wrote in message ... my default used to be column a, column b etc, somehow it has been changed to column 1, column 2 etc. how do I change it back? Because of the default change it changes my formulas to sum(R[1] - C[2] etc.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
