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

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?

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

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"aliceccentric" wrote:
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?

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

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.



aliceccentric wrote:

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?

--

Dave Peterson

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

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

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in message ...
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.



aliceccentric wrote:

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?

--

Dave Peterson

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

Oops, click Send to soon

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Ron de Bruin" wrote in message ...
In xl2007, it's under the Office button|Excel Options|View (I think) section.

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in message ...
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.



aliceccentric wrote:

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?

--

Dave Peterson

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

Thanks, Ron.

Ron de Bruin wrote:

Oops, click Send to soon

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Ron de Bruin" wrote in message ...
In xl2007, it's under the Office button|Excel Options|View (I think) section.

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in message ...
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.



aliceccentric wrote:

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?

--

Dave Peterson

--

Dave Peterson

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

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 !
---------------------------------------------------------------------------
"Dave Peterson" wrote in message
...
Thanks, Ron.

Ron de Bruin wrote:

Oops, click Send to soon

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Ron de Bruin" wrote in message
...
In xl2007, it's under the Office button|Excel Options|View (I think)
section.

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in message
...
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.



aliceccentric wrote:

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?

--

Dave Peterson

--

Dave Peterson

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

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" wrote in message
...
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 !
---------------------------------------------------------------------------
"Dave Peterson" wrote in message
...
Thanks, Ron.

Ron de Bruin wrote:

Oops, click Send to soon

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Ron de Bruin" wrote in message
...
In xl2007, it's under the Office button|Excel Options|View (I think)
section.

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in message
...
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.



aliceccentric wrote:

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?

--

Dave Peterson

--

Dave Peterson

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

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" wrote in message
...
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" wrote in message
...
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
!

--------------------------------------------------------------------------
-
"Dave Peterson" wrote in message
...
Thanks, Ron.

Ron de Bruin wrote:

Oops, click Send to soon

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

"Ron de Bruin" wrote in message
...
In xl2007, it's under the Office button|Excel Options|View (I
think)
section.

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


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Dave Peterson" wrote in message
...
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.



aliceccentric wrote:

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?

--

Dave Peterson

--

Dave Peterson

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

"aliceccentric" wrote:

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?

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

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
"frankie" wrote in message
...


"aliceccentric" wrote:

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?