Row and column headings

  • Thread starter Thread starter Joris 3 Pinter
  • Start date Start date
J

Joris 3 Pinter

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)
 
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
 
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
 
Back
Top