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 :)
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

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!!!
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,160
Messages
5,835,725
Members
430,383
Latest member
Kastore

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