Slanting Cells in first Row

[Guest]

I have a question for the Excel Savy crowd! I am looking
to change the first row in Excel by changing the cell
orientation. Actually slanting the cells! I know how to
slant text within a cell and I have performed this.
However, I would like to slant the cell so I can have the
text slanted and also change the color of the cell. Nice
little slanted cells at the top. It is not a chart, but
a normal workbook.

I am pretty sure it can be done, but I figured I would
ask the folks who are smarter than I.

Thanks in advance for your reply.

Bob

 

[Chip Pearson]

Bob,

I don't think this is possible.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Bob Phillips]

Bob,

Slant the text as you know how to do, and put a box border on the cell.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

Bob,

I have tried that suggestion. But It doesnt slant the
cell. I tired horizontal lines and the border, but then
it if I color hightlight the cell it looks very strange.
My desired outcome is to have slanted text, slanted cell
and color background.

I appreciate your response.!!!!

Bob

 

[Bob Phillips]

Bob,

Either we are talking at cross-purposes, or you are wrong<vbg>

Can I send you a workbook with an example of what I am saying?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Dave R.]

It's kind of sloppy, but you can always fill the whole area with white, and
use the drawing tools, then if you need to, merge whatever cells are in your
range. Again, very sloppy..

 

[Guest]

Hi Bob,
This works fine in Excel 97. Under Format>Cell>Alignment I formatted the text to 45 degrees. Any border or pattern that I set up will slant with the text.

Regards,
Mark Graesser
(e-mail address removed)
Boston MA

----- (e-mail address removed) wrote: -----

Bob,

I have tried that suggestion. But It doesnt slant the
cell. I tired horizontal lines and the border, but then
it if I color hightlight the cell it looks very strange.
My desired outcome is to have slanted text, slanted cell
and color background.

I appreciate your response.!!!!

Bob

 

[Guest]

Bob,

Sure, send me an email. I would love to look at it. I
have been wrong many times in my career, so no worries
about hurting my non-existent ego (vbg)

bob

(e-mail address removed)

 

[Guest]

Hi again Bob
Bob P was correct. You need to apply a border to the cells. If you don't have a border then the pattern doesn't slant. Most unusual

Regards
Mark Graesse
(e-mail address removed)
Boston M

----- Mark Graesser wrote: ----

Hi Bob
This works fine in Excel 97. Under Format>Cell>Alignment I formatted the text to 45 degrees. Any border or pattern that I set up will slant with the text

Regards
Mark Graesse
(e-mail address removed)
Boston M

----- (e-mail address removed) wrote: ----

Bob

I have tried that suggestion. But It doesnt slant the
cell. I tired horizontal lines and the border, but then
it if I color hightlight the cell it looks very strange.
My desired outcome is to have slanted text, slanted cell
and color background.

I appreciate your response.!!!

Bo

 

[Bob Phillips]

You sound surprised<vbg>!

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi again Bob,
Bob P was correct. You need to apply a border to the cells. If you don't

have a border then the pattern doesn't slant. Most unusual.

Regards,
Mark Graesser
(e-mail address removed)
Boston MA

----- Mark Graesser wrote: -----

Hi Bob,
This works fine in Excel 97. Under Format>Cell>Alignment I formatted

the text to 45 degrees. Any border or pattern that I set up will slant with
the text.

 

[Guest]

Bob P was right on! Thanks for the example. I was
thinking you had to move the cells in order to color the
background of the cell correctly. But once I was shown a
good example I get what Bob P was talking about.

Thanks for everyones response, and thanks Bob P for
helping me out!!

Regards,
Bob
(e-mail address removed)

-----Original Message-----
You sound surprised<vbg>!

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

cells. If you don't
have a border then the pattern doesn't slant. Most unusual.

Format>Cell>Alignment I formatted

 

[Gord Dibben]

You cannot slant a cell, only the text within.

Gord Dibben Excel MVP

 

[Bob Phillips]

Gord, you can, read the thread.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

Bob

I followed the instructions and I believe that Gord is right - the CELLS do not slant. However, the BORDERS do slant with the text. Go figure..

Rick..

----- Bob Phillips wrote: ----

Gord, you can, read the thread

--

HT

Bob Phillip
... looking out across Poole Harbour to the Purbeck
(remove nothere from the email address if mailing direct

 

[Bob Phillips]

Colour the cells and see.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Bob,

I followed the instructions and I believe that Gord is right - the CELLS

do not slant. However, the BORDERS do slant with the text. Go figure...

Rick...

----- Bob Phillips wrote: -----

Gord, you can, read the thread.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

You cannot slant a cell, only the text within.

Gord Dibben Excel MVP

 

[Gord Dibben]

Semantics!<g>

It just overlays on top of the adjacent cell. Don't put anything readable in
that adjacent cell.

But, for the OP's purposes it sounds like just what he needs. A whole row of
"slanted" cells.

Learn new tricks every day.

Thanks, Gord

 

[Gord Dibben]

Rick

Bob knows the "cells" do not slant. He's just playing with words.

You're correct, just the borders take on the direction of the text alignment.
The underlying cell remains rectangular.

Gord

 

[Guest]

Hi Bob

Here's the procedures I followed

Type text into three cells side-by-side, format the three cells to 45-degree angle, look at the grid - whoah! the cells are not slanted

Fill the cells with color and still, the cells are not slanted

Make the middle cell un-filled, and add a border to the last cell. Still the cells do not slant. Only the text, the border and the border fill slant. From this I conclude that the cells do not slant. However, for the sheet to give the APPEARANCE that the cells slant, then you must add the border. And for bmillington at ucsd - just fill the cells with color and you get what you asked for

And if no one else explained it (all of the posts are not showing for some reason - I guess the server is having problems) in order to "slant" the cells, click Format/Cells/Alignment...

Rick..

----- Bob Phillips wrote: ----

Colour the cells and see

--

HT

Bob Phillip
... looking out across Poole Harbour to the Purbeck
(remove nothere from the email address if mailing direct

 

[Bob Phillips]

Rick,

This is getting silly and probably isn't worth continuing, but hey what the
heck.

I only suggested colouring so that you could see in the first instance the
there would be a non-coloured triangular section on the left. It could be
argued that this is part of the cell, but I could just as easily argue that
this is just a 'space' behind the cells. It is ridiculous to suggest that
the cells have any intrinsic qualities, they are a virtual concept that MS
has implemented within a product, and are drawn/painted on a screen to give
a visual representation. This solution changes that visual representation,
and so, I would say, change the cells.

You tell me what attributes a cell that is slanting would have that my
solution doesn't have.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi Bob,

Here's the procedures I followed:

Type text into three cells side-by-side, format the three cells to

45-degree angle, look at the grid - whoah! the cells are not slanted!

Fill the cells with color and still, the cells are not slanted!

Make the middle cell un-filled, and add a border to the last cell. Still

the cells do not slant. Only the text, the border and the border fill
slant. From this I conclude that the cells do not slant. However, for the
sheet to give the APPEARANCE that the cells slant, then you must add the
border. And for bmillington at ucsd - just fill the cells with color and
you get what you asked for.

And if no one else explained it (all of the posts are not showing for some

reason - I guess the server is having problems) in order to "slant" the
cells, click Format/Cells/Alignment....

Rick...

----- Bob Phillips wrote: -----

Colour the cells and see.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

CELLS
do not slant. However, the BORDERS do slant with the text. Go figure...

Rick...
----- Bob Phillips wrote: -----
Gord, you can, read the thread.

... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

Bob

You're right, it is getting silly. But to answer your question. When you select the cell, the cursor (probably the wrong terminology) takes on the shape of the cell. It conforms to row height and column width, but not to the slant. If the cell is not selected, then I agree that the visual representation is that the cell is slanting

Rick...