Question on aligning a cell itself, not the text
 

Someone said they have seen where the actual cells in a row have been aligned
diagonally, is this possible? if so how do we do that?

Thank you!

Susan

Question on aligning a cell itself, not the text
 

This is usually done for headers on narrow columns:

Enter the text then select Format Cells Alignment Orientation set to
say 60 degrees and Horizontal Text Alignment to Center. Finally put a
border around the cell. Until the border is placed around the cell it will
not be angled.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Susan" wrote in message
...
Someone said they have seen where the actual cells in a row have been
aligned
diagonally, is this possible? if so how do we do that?

Thank you!

Susan

Question on aligning a cell itself, not the text
 

Susan,

If you rotate the text and place borders around the cells, the cells look like they have been
rotated - but they haven't actually....

HTH,
Bernie
MS Excel MVP


"Susan" wrote in message
...
Someone said they have seen where the actual cells in a row have been aligned
diagonally, is this possible? if so how do we do that?

Thank you!

Susan

Question on aligning a cell itself, not the text
 

Thank you so much!!!

"Bernie Deitrick" wrote:

Susan,

If you rotate the text and place borders around the cells, the cells look like they have been
rotated - but they haven't actually....

HTH,
Bernie
MS Excel MVP


"Susan" wrote in message
...
Someone said they have seen where the actual cells in a row have been aligned
diagonally, is this possible? if so how do we do that?

Thank you!

Susan

Question on aligning a cell itself, not the text
 

I think you may be referring to this:

put some labels in B1:F1, eg Monday, Tuesday, Wednesday etc, then
highlight those cells and click on Format | Cells | Alignment tab,
then in the Orientation panel click on the red button to align the
text at 45 degrees. Then click on the Border tab and click on Outline
and Inside.

When you click OK the cells will look as if they are aligned
diagonally.

Hope this helps.

Pete

On Sep 24, 12:42*pm, Susan wrote:
Someone said they have seen where the actual cells in a row have been aligned
diagonally, is this possible? *if so how do we do that?

Thank you!

Susan