In Excel, how do I change the titles of the cells from A,B,C etc?

[Guest]

In Excel, how do I change the titles of the cells from A, B, C etc and 1, 2,
3 etc? I want to change them to the titles of my rows/columns, which are
words. Can I do this? If so, how?

 

[Guest]

You can't. But you could use, for example: row 1 for your column
titles/labels, and/or column A to house your row labels

 

[Dave Peterson]

And then select A1 (to make sure it's visible)
Then select B2
Window|Freeze Panes.

Then your headers will always be visible.

I think most excel users like to see the row and column headings, but you can
turn them off.

In xl2003, it's:
tools|options|view tab|Uncheck Row & Column Headers

In xl2007, it's under the Office button|Excel Options|View (I think) section.

 

[Ron de Bruin]

In xl2007, it's under the Office button|Excel Options|View (I think) section.

Office button|Excel Options
Advanced...... Display options for this worksheet

 

[Ron de Bruin]

Oops, click Send to soon

On the Ribbon you find it in the Show/Hide group on theView tab

 

[Dave Peterson]

Thanks, Ron.

Oops, click Send to soon

On the Ribbon you find it in the Show/Hide group on theView tab

 

[Ragdyer]

I fret the day when I'll eventually be forced to get XL07!<g>

 

[Bernard Liengme]

I felt the same way the week I switched from standard shift to automatic.
But you will not get be to go back now!
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

I fret the day when I'll eventually be forced to get XL07!<g>

 

[Ragdyer]

I do believe that's a bad comparison Bernard!<bg>

The first time I drove an automatic, I reveled in the fact that a single
motion took the place of 8.

From what I hear about XL07, it's the direct opposite!<g>
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

I felt the same way the week I switched from standard shift to automatic.
But you will not get be to go back now!
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

I fret the day when I'll eventually be forced to get XL07!<g>
--
Regards,

RD

--------------------------------------------------------------------------

-

Please keep all correspondence within the NewsGroup, so all may benefit

!

--------------------------------------------------------------------------

-

 

[frankie]

In Excel, how do I change the titles of the cells from A, B, C etc and 1, 2,
3 etc? I want to change them to the titles of my rows/columns, which are
words. Can I do this? If so, how?

 

[Otto Moehrbach]

You can't. What you can do is remove the column letters/numbers and the row
numbers (Tools - Options - View tab) and insert your column headers in row
1. Does that help? Otto