Slanting headers

  • Thread starter Thread starter davegb
  • Start date Start date
D

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!
 
davegb said:
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!
Click to expand...

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

Beege
 
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)
 
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
 
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 -
Click to expand...

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