sloping top rows in Excel

[prints phil]

How do I get the top row of cells to slope 45 degrees?

 

[Stan Brown]

Sat, 8 Mar 2008 03:16:00 -0800 from <=?Utf-8?B?cHJpbnRzIHBoaWw=?=

How do I get the top row of cells to slope 45 degrees?

Format | Cells | Alignment

 

[Sandy Mann]

Just to add to Stans post, the gridlines will not slope when the text is set
to45 deg but Borders will.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Gord Dibben]

To add to Stan's and Sandy's posts.

Also helps visually if the cells are highlighted with a background color.


Gord Dibben MS Excel MVP

 

[Paula]

I have tried to add borders just to text in 2007, but cannot ssem to do it.
Can you please give more detail?

 

[Gord Dibben]

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 45 degrees or to your choice.

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


Gord Dibben MS Excel MVP