Home |
Search |
Today's Posts |
#1
|
|||
|
|||
columns are numerical insted of alphabetical
I have managed to change the alphabet columns to numerical. How can I change
this back. Rows are still numerical so both rows and coumns ar now 1....10,etc |
#2
|
|||
|
|||
Chris, tools, options, general, uncheck R1C1 ref. style
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Chris" wrote in message ... I have managed to change the alphabet columns to numerical. How can I change this back. Rows are still numerical so both rows and coumns ar now 1....10,etc |
#3
|
|||
|
|||
Hi Chris-
ToolsOptions--General, remove the R1C1 check. Regards |:) "Chris" wrote: I have managed to change the alphabet columns to numerical. How can I change this back. Rows are still numerical so both rows and coumns ar now 1....10,etc |
#4
|
|||
|
|||
Worked a treat Paul. Thanks for your help. Fat fingers wreak havoc again.
"Paul B" wrote: Chris, tools, options, general, uncheck R1C1 ref. style -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Chris" wrote in message ... I have managed to change the alphabet columns to numerical. How can I change this back. Rows are still numerical so both rows and coumns ar now 1....10,etc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Columns | Excel Discussion (Misc queries) | |||
Why are my column headings numerical instead of alphabetical? | Excel Discussion (Misc queries) | |||
How do I format 1 column of alphabetical listings into 3 columns? | Excel Worksheet Functions | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Hidden Columns in Shared Workbooks | Excel Discussion (Misc queries) |