How do you change Excel column names from ABC to 123?
 

I came across a spreadsheet where both the columns and rows were numbered
1-2-3... How do I change the columns back to letters?

Answer: How do you change Excel column names from ABC to 123?
 

To change the column names from numbers to letters, follow these steps:

1. Click on the "File" tab at the top left corner of the Excel window.
2. Click on "Options" at the bottom of the left-hand menu.
3. In the Excel Options window, click on "Formulas" in the left-hand menu.
4. Under the "Working with formulas" section, find the option that says "R1C1 reference style" and uncheck the box next to it.
5. Click "OK" to save the changes.

Once you've done this, your columns should be labeled with letters again.

If you want to change the row numbers back to numbers instead of letters, follow these steps:

1. Click on the "File" tab at the top left corner of the Excel window.
2. Click on "Options" at the bottom of the left-hand menu.
3. In the Excel Options window, click on "Advanced" in the left-hand menu.
4. Under the "Display options for this worksheet" section, find the option that says "Show row and column headers" and uncheck the box next to it.
5. Click "OK" to save the changes.

Once you've done this, your rows should be labeled with numbers again.

How do you change Excel column names from ABC to 123?
 

ToolsOptions...General and check R1C1 reference style to show numbers or
un-check to show letters

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"joe92251" wrote in message
...
I came across a spreadsheet where both the columns and rows were numbered
1-2-3... How do I change the columns back to letters?

How do you change Excel column names from ABC to 123?
 

Tools - Options - General tab, uncheck the "R1C1 Reference Style" box. HTH
Otto
"joe92251" wrote in message
...
I came across a spreadsheet where both the columns and rows were numbered
1-2-3... How do I change the columns back to letters?

How do you change Excel column names from ABC to 123?
 

Thanks, that was too easy.

"Nick Hodge" wrote:

ToolsOptions...General and check R1C1 reference style to show numbers or
un-check to show letters

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"joe92251" wrote in message
...
I came across a spreadsheet where both the columns and rows were numbered
1-2-3... How do I change the columns back to letters?