Column Headings

[Kevin M]

you cannot do it in Excel. there may be some VB to do it,
but i'm not aware of it.
Sorry,
Kevin M
>-----Original Message-----
>How do I replace the A,B,C column heading with my own
text?
>.
>

[Ron de Bruin]

Hi Shekinah

You can't replace the headings
But you can use window-Freeze Panes in the menubar
To freeze the first column and Row select cell b2 and do windows -Freeze Panes

You can put your own headers in the first row and column now

Under Tools -options -View uncheck row & column headers so
the default row and column headers are gone

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl

"Shekinah" <anon...@discussions.microsoft.com> wrote in message news:38D51625-DA3B-4933...@microsoft.com...

[anon...@discussions.microsoft.com]

The other gentleman was correct that you can't change the
headings, but I have an idea that might give the illusion
that they are changed. Of course you won't have any of
the functionality of the A, B, C column headings, but your
spreadsheet will look better. Go to Tools Options and the
View Tab. Then you can turn off the Column and Row
headings. This will leave you with just the worksheet,
which you can add headings in the first row and across the
columns that you need. If you were feeling really frisky,
you could create buttons using the Control toolbox and
draw them to be the same size as your columns and then
label the buttons. This will look very similar to Column
headings, and it gives you the added flexibility that you
can program in some of the functionality of the column
heads. To do that you simply record a macro, then click
on the Triangle from the Control Tool box, followed by
double clicking on your button. In the blank spot that
comes up in the VBA you will put Call MacroName. Note:
MacroName is the actual name you chose for your macro, if
you chose Fred the code would be Call Fred.

This is just a thought I hope it helps.

>-----Original Message-----
>How do I replace the A,B,C column heading with my own
text?

>.
>