Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Renaming Column Headings
One of my users have managed to change the column headings from A B C D etc
to 1 2 3 4. Now they can not remember what they did to change them. I've looked through teh help and on Google, but found very little. Any ideas? If you want to email a reply, could you send it to , remembering, of course to remove TROUSERS first! Thanks for you help in advance! PJ. 80) |
#2
|
|||
|
|||
Hi
tools / options / general - untick R1C1 reference style Regards JulieD "PJ" wrote in message ... One of my users have managed to change the column headings from A B C D etc to 1 2 3 4. Now they can not remember what they did to change them. I've looked through teh help and on Google, but found very little. Any ideas? If you want to email a reply, could you send it to , remembering, of course to remove TROUSERS first! Thanks for you help in advance! PJ. 80) |
#3
|
|||
|
|||
<Tools <Options <General tab,
And *Uncheck* "R1C1 reference style" -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "PJ" wrote in message ... One of my users have managed to change the column headings from A B C D etc to 1 2 3 4. Now they can not remember what they did to change them. I've looked through teh help and on Google, but found very little. Any ideas? If you want to email a reply, could you send it to , remembering, of course to remove TROUSERS first! Thanks for you help in advance! PJ. 80) |
#4
|
|||
|
|||
Thanks for your help! I now have a happy user!
PJ. 80) "JulieD" wrote in message ... Hi tools / options / general - untick R1C1 reference style Regards JulieD "PJ" wrote in message ... One of my users have managed to change the column headings from A B C D etc to 1 2 3 4. Now they can not remember what they did to change them. I've looked through teh help and on Google, but found very little. Any ideas? If you want to email a reply, could you send it to , remembering, of course to remove TROUSERS first! Thanks for you help in advance! PJ. 80) |
#5
|
|||
|
|||
you're welcome and thanks for the feedback - oh, just a note - in my
experience, most of them don't stay happy for long! :) "PJ" wrote in message ... Thanks for your help! I now have a happy user! PJ. 80) "JulieD" wrote in message ... Hi tools / options / general - untick R1C1 reference style Regards JulieD "PJ" wrote in message ... One of my users have managed to change the column headings from A B C D etc to 1 2 3 4. Now they can not remember what they did to change them. I've looked through teh help and on Google, but found very little. Any ideas? If you want to email a reply, could you send it to , remembering, of course to remove TROUSERS first! Thanks for you help in advance! PJ. 80) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy excel worksheet into msword with row, column headings and gr. | Excel Discussion (Misc queries) | |||
how do you change column headings in excel? | Excel Discussion (Misc queries) | |||
Column headings | Excel Worksheet Functions | |||
pivot table row vs column headings | Excel Worksheet Functions | |||
How can I see column headings of hidden columns in Excel before u. | Excel Discussion (Misc queries) |