ExcelBanter - sloping top rows in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - sloping top rows in Excel (https://www.excelbanter.com/excel-worksheet-functions/179260-sloping-top-rows-excel.html)

sloping top rows in Excel

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

sloping top rows in Excel

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

On Sat, 8 Mar 2008 12:41:12 -0000, "Sandy Mann"
wrote:

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

sloping top rows in Excel

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

"Sandy Mann" wrote:

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

Replace @mailinator.com with @tiscali.co.uk

"Stan Brown" wrote in message
t...
Sat, 8 Mar 2008 03:16:00 -0800 from <?B?cHJpbnRzIHBoaWw=?=
<prints :
How do I get the top row of cells to slope 45 degrees?

Format | Cells | Alignment

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...

sloping top rows in Excel

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 FormatCellAlignment.

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

On Sat, 6 Sep 2008 09:41:16 -0700, Paula
wrote:

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

"Sandy Mann" wrote:

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

Replace @mailinator.com with @tiscali.co.uk

"Stan Brown" wrote in message
t...
Sat, 8 Mar 2008 03:16:00 -0800 from <?B?cHJpbnRzIHBoaWw=?=
<prints :
How do I get the top row of cells to slope 45 degrees?

Format | Cells | Alignment

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...