View Single Post
  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default

Lisa,

You don't have to make the border slant, just put the normal box border
around the text. If you slant the text, Excel will automatically slant the
border for you.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lisa H" wrote in message
...
Bob,

It's the "add a border to each cell" part that I'm having trouble with.

How
exactly do I add the borders so that they slant properly? When I put in a
diagonal border, its angle doesn't match the angle of the text. When I put

in
a vertical border, it's just vertical.

Thanks,
Lisa H


"Bob Phillips" wrote:

Lisa,

If you angle the text (FormatCellAlignmnet and then use the dial to

get
your angle)

and then add a border to each cell

you should find that it all works, clean, separated, and regardless of
column width.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lisa H" wrote in message
...
I'm trying to use angled column headings and borders so I can fit many
columns across the page. I've tried following an article called "Using

angled
text and borders in Excel", but my results aren't very good--I'm

having
trouble placing the angled borders and angled text properly. My

borders
don't
bend at the same angle, I guess because the columns are different

widths.
Also, the angled border sometimes runs through the angled column head.

Can
anybody help?

Thanks!
Lisa H