Excel Column Labels

[IceTech]

I'm using Excel 97 and I'm trying to make custom excel column labels instead of the A B C ..etc. I'm not talking about creating a header row, I already have one of those. I need to change the column labels to read something different. Anyone ever do this?

 

[SkipVought]

IceTech,

Nope.

What's the reason?

You could...
turn off the Row & column headers in Tools/Options
format row 1 and column 1 with your own values
protect row 1 and column 1 but allow selection
program the worksheet_selectionchange event to select the entire row/rolumn
don't know what I'd do about the row/column boundary/dimension change functionality

He##, it's not worth the effort! ;-)

Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[Marcs41]

You cannot change the Row & column headers A, B etc.

As Skip already wondered, what good would that do?

Marc
_{If 'something' 'somewhere' gives 'some' error, expect random guesses or no replies at all. Please specify details.
Free Tip: The F1 Key does NOT destroy your PC!}

 

[GlennUK]

IceTech,

what would you have there instead?

Why can't you have another header row, that has these column headings?

If it's because you want to be able to click on them to allow selection of entire columns then place buttons in a new header row that are exactly the same size as each cell in the new header row, and have VBA macro(s) to do the selecting.

I once saw Klingon characters in the column headers, which was done by installing the Klingon font, and doing menu command Tools/Options/General/Standard Font and selecting the required font. Restarting Excel afterwards makes the row and column headers appear in that font. ( It also makes it the default font for new sheets too as far as I remember ).

You can create your own font by using this website ( never tried it myself yet ) ...

http://www.fontifier.com/draw.html

and make A B C D E F .... Z into other symbols, but you are limited by character size. Then instal your own font, and do the steps mentioned above, and you'll have your own column header symbols.


I think I know too much trivial information.

Cheers, Glenn.

 

[xlbo]

Glenn - luvverly - compkletely useless but luvverly nonetheless

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244

 

[GlennUK]

Geoff,

it warms my heart that someone actually read all of that

Cheers, Glenn.