ExcelBanter - Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel (https://www.excelbanter.com/excel-discussion-misc-queries/239598-excel.html)

kathycanoe

Excel

Hi - Does anyone know how to turn cells on a diagonal - like at the top of a
spreadsheet?

Jacob Skaria

Excel

Format the cells with borders on all 4 sides and then when you have the text
orientation to certain angle the sides of these cells will show up tilted.

If this post helps click Yes
---------------
Jacob Skaria

"kathycanoe" wrote:

Hi - Does anyone know how to turn cells on a diagonal - like at the top of a
spreadsheet?

Gord Dibben

Excel

You cannot change the orientation of the cell..........only the text within.

FormatCellsAlignmentOrientation.........pick an angle.

Place a nice bold border around the cell to get the "look" of an angled
cell.

Gord Dibben MS Excel MVP

On Wed, 12 Aug 2009 17:56:01 -0700, kathycanoe
wrote:

Hi - Does anyone know how to turn cells on a diagonal - like at the top of a
spreadsheet?

All times are GMT +1. The time now is 08:41 PM.