ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Slanted cells with text (https://www.excelbanter.com/excel-discussion-misc-queries/155816-slanted-cells-text.html)

jisaac

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

Kevin

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?




Gord Dibben

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?




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com