Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default sloping top rows in Excel

How do I get the top row of cells to slope 45 degrees?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 524
Default sloping top rows in Excel

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...
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,345
Default sloping top rows in Excel

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



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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.


  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 138
Default 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...






  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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...





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Delete empty rows in excel in b/w rows with values Dennis Excel Worksheet Functions 3 August 28th 07 04:15 PM
How do I view the maximum rows in Excel 2007 (Million Rows)? shanth Excel Discussion (Misc queries) 2 January 15th 07 05:45 PM
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th Excellent1975 Excel Discussion (Misc queries) 0 June 21st 06 08:01 PM
Can Excel "slide up" rows with content thru empty rows to condense portly44 Excel Worksheet Functions 2 April 1st 05 12:47 AM
angled or sloping column headings in Excel PhilipRichards Excel Discussion (Misc queries) 4 March 5th 05 06:19 PM


All times are GMT +1. The time now is 05:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"