Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I change column numbers to letters
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I change column numbers to letters
Marie, tools, options, general, uncheck R1C1 reference style, OK
-- 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 "Marie" wrote in message ... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I change column numbers to letters
Tools|Options|General Tab|Uncheck R1C1 Reference Style.
Marie wrote: -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I change column numbers to letters
Goto ToolsOptionsGeneral and uncheck R1C1 Reference Style checkbox
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Marie" wrote in message ... |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I change column numbers to letters
it says name cannot resemble a reference.......any ideas??
"Paul B" wrote: Marie, tools, options, general, uncheck R1C1 reference style, OK -- 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 "Marie" wrote in message ... |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I change column numbers to letters
Thanks
it says name does not resemble a reference?? "Bob Phillips" wrote: Goto ToolsOptionsGeneral and uncheck R1C1 Reference Style checkbox -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Marie" wrote in message ... |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I change column numbers to letters
That means that you (or another person) defined a name (insert|Name|define) and
used a name that looked like an address. Change the name to something else when you get prompted (start it with an underscore???). Marie wrote: Thanks it says name does not resemble a reference?? "Bob Phillips" wrote: Goto ToolsOptionsGeneral and uncheck R1C1 Reference Style checkbox -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Marie" wrote in message ... -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I change column numbers to letters
yipee the underscore worked thank you very much, everything is normal
again!!!!! "Dave Peterson" wrote: That means that you (or another person) defined a name (insert|Name|define) and used a name that looked like an address. Change the name to something else when you get prompted (start it with an underscore???). Marie wrote: Thanks it says name does not resemble a reference?? "Bob Phillips" wrote: Goto ToolsOptionsGeneral and uncheck R1C1 Reference Style checkbox -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Marie" wrote in message ... -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
no row numbers or column letters DISPLAYED | Excel Discussion (Misc queries) | |||
macro | Excel Discussion (Misc queries) | |||
how do i change the column headings from numbers to letters in ex | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
How to change column letters to correct ones in many formulas automatically? | Excel Worksheet Functions |