Question on aligning a cell itself, not the text

[Susan]

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

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Bernie Deitrick]

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]

Thank you so much!!!

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

 

[Pete_UK]

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