Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change Excel column cell identifiers back to letters?
While merging data from different worksheets and formatting cells, I suddenly
noticed the column identifiers at the top of my worksheet changed to numbers instead of letters. Any good ideas on how I should change them back to letters? I searched Help Online and came up empty thus far. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change Excel column cell identifiers back to letters?
Hello Cotmc, On the the menu go to ToolsOptionsGeneralSettings and click the box marked R1C1 style to clear it. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=503418 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change Excel column cell identifiers back to letters?
Try this:
ToolsOptionsGeneral tab UNcheck: R1C1 reference style Does that help? *********** Regards, Ron XL2002, WinXP-Pro "cotmc" wrote: While merging data from different worksheets and formatting cells, I suddenly noticed the column identifiers at the top of my worksheet changed to numbers instead of letters. Any good ideas on how I should change them back to letters? I searched Help Online and came up empty thus far. Thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change Excel column cell identifiers back to letters?
Yes! Thanks a million!
"Ron Coderre" wrote: Try this: ToolsOptionsGeneral tab UNcheck: R1C1 reference style Does that help? *********** Regards, Ron XL2002, WinXP-Pro "cotmc" wrote: While merging data from different worksheets and formatting cells, I suddenly noticed the column identifiers at the top of my worksheet changed to numbers instead of letters. Any good ideas on how I should change them back to letters? I searched Help Online and came up empty thus far. Thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change Excel column cell identifiers back to letters?
Thanks!!
"Leith Ross" wrote: Hello Cotmc, On the the menu go to ToolsOptionsGeneralSettings and click the box marked R1C1 style to clear it. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=503418 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
Possible Lookup Table | Excel Worksheet Functions | |||
How do i change column headings back to letters in excel? | Excel Discussion (Misc queries) | |||
In MS Excel, how do I fill in a column with the same cell from se. | Excel Worksheet Functions |