how do I change the default name of a column from numbers to lett.

M

mac

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.
 
T

trip_to_tokyo

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!
 
P

Peo Sjoblom

In 97-2003 tools>options>general, then deselect R1C1 reference style

in 2007 office button, excel options>formulas under working with formula and
deselect the same check box


For future posts include Excel version

--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CountIf formula problem when referencing a column. 4
Column designations (A, B, C,..) are now numbers-how do I change 3
excel- change column name from "A, B, etc" to "First Name, etc" 1
Excel coolumn headings changed from A, B, C, etc. to 1, 2, 3 1
Column headings - urgent help needed please 3
Change column Name from 1 2 3 to A B C in excel 2007 1
Adjusting formula for month in vlookup? 3
Sum a range based on a column 2

Top