ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Renaming Column Headings (https://www.excelbanter.com/excel-discussion-misc-queries/10772-renaming-column-headings.html)

PJ

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)



JulieD

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)





RagDyeR

<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)




PJ

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)







JulieD

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