Customize ROW/COLUMN header

In excel we have got default row headers as "1,2,3,4..." and column headers as "A,B,C,D..."

Can we change them into more meaningful words or customized code?

Many thanks,

P.

No, the best you can do is hide them (Tools>Options>View and uncheck Column
and Row Headers) and then use row 1 and Column A to enter more meaningful
names. You could also select B2 and Window>Freeze Panes to keep the always
visible.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"prague" <prague.21b31m_1136706901.748@excelforum-nospam.com> wrote in
message news:prague.21b31m_1136706901.748@excelforum-nospam.com...
>
> In excel we have got default row headers as "1,2,3,4..." and column
> headers as "A,B,C,D..."
>
> Can we change them into more meaningful words or customized code?
>
> Many thanks,
>
> P.
>
>
> --
> prague
> ------------------------------------------------------------------------
> prague's Profile:
http://www.excelforum.com/member.php...o&userid=30172
> View this thread: http://www.excelforum.com/showthread...hreadid=499138
>