Slanting cells across top of Word table or Excel spreadsheet?

[Capital Park FHC - Donna]

I want to make a single-page form that has long descriptions down the left,
and names of people across the top -- but the names need to be slanted upward
because there are too many, and the matrix boxes will have only a + or - in
them so they can be quite small. An example would be the mileage charts on a
road map, with city names at left and top but only a few numbers in the
matrix boxes. Is it possible to do this?

 

[Gord Dibben]

Donna

You cannot physically slant cells, but you can format them to look slanted.

First, place a border around the cell and color it a nice color.

Then Format>Cell>Alignment.

Use the protractor to orient the text at 30 or 40 degrees.

Experiment with row height and column width.until you get the effect you want.


Gord Dibben MS Excel MVP