Home |
Search |
Today's Posts |
#1
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
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
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
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
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I change default row numbers in Excel ? | Excel Worksheet Functions | |||
Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
Can I change a column of calculated numbers to absolute numbers? | Excel Discussion (Misc queries) | |||
How can I change column numbers back to column letters? | Excel Worksheet Functions | |||
excel change default column sort to current selection | Excel Worksheet Functions |