Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 25th 07, 09:32 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2007
Posts: 1
Default Slanted cells with text

How do I make several slanted cells with centered text at the top of a table
in Excel 2003?

  #2   Report Post  
Old August 25th 07, 10:12 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 26
Default Slanted cells with text

jisaac,
In Excel 2000, you would select the cells in question, then choose Format
Cells...
In the resulting Format Cells form, choose the Alignment tab. Choose Center
for
both Horizontal AND Vertical Text aligment and set the Orientation to
whatever angle
you want your text to be. 45 degress works well.
-Kevin

"jisaac" wrote in message
...
How do I make several slanted cells with centered text at the top of a
table
in Excel 2003?



  #3   Report Post  
Old August 25th 07, 10:22 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,909
Default Slanted cells with text

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 30 or 40 degrees.

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


Gord Dibben MS Excel MVP

On Sat, 25 Aug 2007 13:32:01 -0700, jisaac
wrote:

How do I make several slanted cells with centered text at the top of a table
in Excel 2003?




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
Count single Text in cells with multiple text entries WSC Excel Discussion (Misc queries) 6 January 9th 07 04:17 PM
How can I create slanted headers? photo_angel2004 New Users to Excel 15 August 8th 06 06:49 AM
slanted cell shading duvanderz New Users to Excel 8 August 4th 06 08:42 AM
merged cells into one text cell, size varies dependant on text dat Jazzylady825 Excel Discussion (Misc queries) 0 December 9th 05 08:26 PM
Slanted Text in header cells Christine Excel Discussion (Misc queries) 4 February 16th 05 06:09 AM


All times are GMT +1. The time now is 08:10 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017