Changing A, B, C to 1, 2, 3

crtas17

New Member
Joined
Aug 13, 2007
Messages
3
Hey guys got a ? 4 you. Not sure what these are called so will do my best to explain what I am looking for.

In Excel 2007 I need to change the labels at the top (the column headers maybe) from A, B, C and ect to 1, 2, 3 and then change the (possibly called row headers) from 1,2,3 to A,B,C

Example: right now it would be A1 but when changed like I would like it to be it will be 1A

Sorry if clear as mud not sure on the terminology on this one

Thanks 4 your help :)
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

cornflakegirl

Well-known Member
Joined
Nov 4, 2004
Messages
2,023
I don't think this is possible. Why do you want to do it? There might be another way to achieve whatever you want.
 

#BoB#

Active Member
Joined
May 20, 2008
Messages
303
Hi,

I am not sure if this can be achieved. However, you can change the column names to 1,2,3, etc in place of A,B,C.

If you wish to do this....

Go to... Tools > Options > General
Then check the "R1C1 Reference Style" box.

This will change all the column Alphabets into numbers. This convention (R1C1 style) is often used in VBA.

However, I am not sure if the Row names can be changed to alphabets or not.


~ChillaX!!!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,216
Messages
5,594,886
Members
413,947
Latest member
gizmolucy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top