![]() |
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) |
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) |
<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) |
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) |
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) |
All times are GMT +1. The time now is 10:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com