Row and column headings

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joris 3 Pinter - 25 Jul 2007 19:47 GMT

Is it possible to change the lettertype of the rowheadings (1, 2, ...) and
the columnheadings (A, B, ...)?
And to change their alignment, for example left alligned for the
columnheading?

If a row is for example 3 times as high as the normal lettertype, then Excel
allignes the rownumbers at the bottom of the row. I would like to position
it at the top of the row.

Joris.
(Netherlands)

Reply to this Message

Gord Dibben - 25 Jul 2007 20:22 GMT

Other than changing the Font there is nothing you can do with the row and column
headings except hide them and use column A and row 1 for your own titles.

To change Font go to Format>Style and work from there.

Will not affect existing workbooks. They have to be done individually.

Gord Dibben MS Excel MVP

>Is it possible to change the lettertype of the rowheadings (1, 2, ...) and
>the columnheadings (A, B, ...)?
[quoted text clipped - 7 lines]
>Joris.
>(Netherlands)

Reply to this Message

Pete_UK - 25 Jul 2007 20:33 GMT

I don't think you can change the format of the column or row
identifiers. However, you can turn them off (with Tools | Options |
View (tab) and uncheck Row/Column headings) and then use Row 1 and
Column A to contain your own formatted versions - it makes formula and
cell references a bit difficult to follow, though.

You can change the vertical alignment within a cell or range by Format

| Cells | Alignment (tab), and then use the pull-down for Vertical

Alignment.

Hope this helps.

Pete

On Jul 25, 7:47 pm, "Joris 3 Pinter" <xkxaxtx...@planet.nlverwijderx>
wrote:

> Is it possible to change the lettertype of the rowheadings (1, 2, ...) and
> the columnheadings (A, B, ...)?
[quoted text clipped - 7 lines]
> Joris.
> (Netherlands)

Reply to this Message

Rate this thread: