Slanting Cells in first Row

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

Bob,

I don't think this is possible.


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


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

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

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


.

Bob,

Either we are talking at cross-purposes, or you are wrongvbg

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)

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


.

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






-----Original Message-----
Bob,

Either we are talking at cross-purposes, or you are
wrongvbg

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)

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

Boston MA

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

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

Regards,
Mark Graesser

Boston MA

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

You sound surprisedvbg!

--

HTH

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

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

Boston MA

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

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

Regards,
Mark Graesser

Boston MA

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

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

-----Original Message-----
You sound surprisedvbg!

--

HTH

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

"Mark Graesser"
wrote in message
news:1F5E68D0-CFE1-474C-816C-
...
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

Boston MA

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

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

Regards,
Mark Graesser

Boston MA

-----
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
news:292201c3fc9d$aa6b9c70
...
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
.



.

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


.