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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
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.
 
In xl2007, it's under the Office button|Excel Options|View (I think) section.

Office button|Excel Options
Advanced...... Display options for this worksheet
 
Oops, click Send to soon

On the Ribbon you find it in the Show/Hide group on theView tab
 
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 !
---------------------------------------------------------------------------
Bernard Liengme said:
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

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

RD

--------------------------------------------------------------------------
Click to expand...
-
Please keep all correspondence within the NewsGroup, so all may benefit
Click to expand...
!
--------------------------------------------------------------------------
Click to expand...
-
Click to expand...
 
aliceccentric said:
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?
Click to expand...
 
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
 
Back
Top