How do I change column headings (A,B,C) to text words across the top of the
worksheet?
Thanks.
How do I change column headings (A,B,C) to text words across the top of the
worksheet?
Thanks.
The A, B, C headers are internal to Excel, and are used to specify cell
locations. They can't be changed to text.
However, if you need headers for a report or something, you can type
them in and make them bold, underline them, etc. If the lettering
system REALLY bothers you, you can turn it off (that is to say, remove
it from view on screen- they'll still be there) by clicking >Tools
>Options, selecting the View tab, and de-selecting the "Row and column headers" box.
And select A2 and do a Window>Freeze Panes so they are always visible, and
go to File>Pagesetup?Sheet and Set the rows to repeat for printing.
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
"Dave O" <CycleZen@yahoo.com> wrote in message
news:1138209588.852686.22110@g49g2000cwa.googlegroups.com...
> The A, B, C headers are internal to Excel, and are used to specify cell
> locations. They can't be changed to text.
>
> However, if you need headers for a report or something, you can type
> them in and make them bold, underline them, etc. If the lettering
> system REALLY bothers you, you can turn it off (that is to say, remove
> it from view on screen- they'll still be there) by clicking >Tools
> >Options, selecting the View tab, and de-selecting the "Row and column
headers" box.
>
Could I keep the row headings and remove the column headings?
Welcome to the forum.
Please take a few minutes to read the forum rules, and then start your own thread.
Thanks.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks