Slanting headers

[davegb]

I saw a spreadsheet where the column headers slanted up at a 45 degree
angle from the rest of the column. This made it much easier to have
long, descriptive headers without having to word-wrap or widen the
column (the column contents were mostly markers, like x's, so the
columns could be very narrow and get lots of them visible at the same
time). I looked at the column headers and couldn't figure out how the
borders were made at a 45 degree angle. The text is aligned at 45
degrees, but when I align text in a cell at 45 degrees, the cell
borders remain vertical and horizontal, not slanting.

I've looked to see if it was done with "Format, Cells, Borders" or
under any of the special formatting for those cells, but I can't find
it. Does anyone here know how to make this happen? Thanks in advance!

 

[Beege]

I saw a spreadsheet where the column headers slanted up at a 45 degree
angle from the rest of the column. This made it much easier to have
long, descriptive headers without having to word-wrap or widen the
column (the column contents were mostly markers, like x's, so the
columns could be very narrow and get lots of them visible at the same
time). I looked at the column headers and couldn't figure out how the
borders were made at a 45 degree angle. The text is aligned at 45
degrees, but when I align text in a cell at 45 degrees, the cell
borders remain vertical and horizontal, not slanting.

I've looked to see if it was done with "Format, Cells, Borders" or
under any of the special formatting for those cells, but I can't find
it. Does anyone here know how to make this happen? Thanks in advance!

Look at the cell alignment tab. alog with the borders tab. Play with
them 'til satisfied.3

Beege

 

[Bob Phillips]

You need to add your borders, not rely on the Excel cell gridlines.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Gord Dibben]

dave

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

 

[davegb]

dave

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




- Show quoted text -

Thanks to you all for your help. I've got what I wanted.