Slanting Cells in first Row

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)

"Gord Dibben" gorddibbATshawDOTca wrote in message
...
You cannot slant a cell, only the text within.

Gord Dibben Excel MVP

On Thu, 26 Feb 2004 11:59:13 -0800,
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
-----Original Message-----
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)

wrote in message
...
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


.

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

On Thu, 26 Feb 2004 23:17:28 -0000, "Bob Phillips"
wrote:

Gord, you can, read the thread.

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

On Thu, 26 Feb 2004 15:56:09 -0800, Rick Willingham
wrote:

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)

"Gord Dibben" gorddibbATshawDOTca wrote in message
...
You cannot slant a cell, only the text within.
Gord Dibben Excel MVP
On Thu, 26 Feb 2004 11:59:13 -0800, 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
-----Original Message-----
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)
wrote in message
.. .
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
.

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)

"Rick Willingham" wrote in message
...
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)
"Gord Dibben" gorddibbATshawDOTca wrote in message
...
You cannot slant a cell, only the text within.
Gord Dibben Excel MVP
On Thu, 26 Feb 2004 11:59:13 -0800,
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
-----Original Message-----
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)
wrote in message
. ..
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
.

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)

"Rick Willingham" wrote in message
...
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)

"Rick Willingham" wrote in
message
...
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)
"Gord Dibben" gorddibbATshawDOTca wrote in message
...
You cannot slant a cell, only the text within.
Gord Dibben Excel MVP
On Thu, 26 Feb 2004 11:59:13 -0800,
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
-----Original Message-----
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)
wrote in message
. ..
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
.