Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
|
|||
|
|||
Answer: How do you change Excel column names from ABC to 123?
To change the column names from numbers to letters, follow these steps:
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:
Once you've done this, your rows should be labeled with numbers again.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change column heading names from numbers to alpha characters | Excel Discussion (Misc queries) | |||
How do I switch the names in a column in Excel | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
How do I change the colour of the Column & Row Toolbars in Excel? | New Users to Excel |