MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Column headings


Posted by Richard on October 18, 2000 12:27 PM

How can I change the Column headings from A B C D E …. to column headings of my choice?
I know I could switch off display of the headings, use row 1 for new headings and use the splitter bar to stop it scrolling, but that limits subsequent use of the splitter.
Any ideas?


Posted by Loren on October 19, 2000 4:35 AM


You can hide any columns you don't want.

Posted by Richard on October 19, 2000 11:23 AM

My choice doesn't include any of the current column headings! I want to change columns headings to, say, 50Hz 80Hz 100Hz 125Hz.

Posted by Celia on October 19, 2000 1:42 PM

Richard
Why would using row 1 restrict subsequent use of the "splitter"?
Celia

Posted by Celia on October 19, 2000 1:46 PM

OK. I just tried it and see what you mean.
Celia