D
David
Please advise on how I change colum heading from 1234 to ABCD in Office 2007
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JLatham
Tools | Options | [General] tab. Clear the "R1C1 Reference Style" checkbox.
J
Jon Peltier
David wants this for Excel 2007. After some hunting I discovered it.
Office button > Excel Options > Formulas > clear the "R1C1 Reference Style"
checkbox under "Working with Formulas".
I don't know why it's not on the View tab of the ribbon.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
Office button > Excel Options > Formulas > clear the "R1C1 Reference Style"
checkbox under "Working with Formulas".
I don't know why it's not on the View tab of the ribbon.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
JLatham said:Tools | Options | [General] tab. Clear the "R1C1 Reference Style"
checkbox.
David said:Please advise on how I change colum heading from 1234 to ABCD in Office
2007
D
dlw
the challenge and excitement of finding shuffled menu options, another reason
to upgrade to office 2007...
to upgrade to office 2007...
Jon Peltier said:David wants this for Excel 2007. After some hunting I discovered it.
Office button > Excel Options > Formulas > clear the "R1C1 Reference Style"
checkbox under "Working with Formulas".
I don't know why it's not on the View tab of the ribbon.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
JLatham said:Tools | Options | [General] tab. Clear the "R1C1 Reference Style"
checkbox.
David said:Please advise on how I change colum heading from 1234 to ABCD in Office
2007
J
JLatham
"David wants this for Excel 2007. After some hunting I discovered it."
Arrrrgggghhhhhhh!!!!
Not too far down the road when someone asks "how do I..." our first response
is going to be "Pre-2007 or 2007/later?...."
Arrrrgggghhhhhhh!!!!
Not too far down the road when someone asks "how do I..." our first response
is going to be "Pre-2007 or 2007/later?...."
Jon Peltier said:David wants this for Excel 2007. After some hunting I discovered it.
Office button > Excel Options > Formulas > clear the "R1C1 Reference Style"
checkbox under "Working with Formulas".
I don't know why it's not on the View tab of the ribbon.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
JLatham said:Tools | Options | [General] tab. Clear the "R1C1 Reference Style"
checkbox.
David said:Please advise on how I change colum heading from 1234 to ABCD in Office
2007
J
Jon Peltier
Yeah, and my memory's getting to the point where I can hide my own Easter
eggs...
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
eggs...
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
dlw said:the challenge and excitement of finding shuffled menu options, another
reason
to upgrade to office 2007...
Jon Peltier said:David wants this for Excel 2007. After some hunting I discovered it.
Office button > Excel Options > Formulas > clear the "R1C1 Reference
Style"
checkbox under "Working with Formulas".
I don't know why it's not on the View tab of the ribbon.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
JLatham said:Tools | Options | [General] tab. Clear the "R1C1 Reference Style"
checkbox.
:
Please advise on how I change colum heading from 1234 to ABCD in
Office
2007