View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
DaveL DaveL is offline
external usenet poster
 
Posts: 22
Default Aligning Gridlines at 45 degrees (Orientation)

Thanks Gord - I appreciate it. Sounds like I am out of luck on this.

"Gord Dibben" wrote:

The text in the cells must be aligned to 45 degress in order to get slanted
borders.

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

In short............you cannot have row 1 slanted with horizontal text
alignment.


Gord Dibben MS Excel MVP

On Fri, 18 Apr 2008 11:15:00 -0700, DaveL
wrote:

I have a spreadsheet where the second row is a listing of attributes. I have
set the orientation (Format-Cells-Alignment) of each column in this row to 45
degrees. The first row is a higher level group of attributes in which each
one contains a group of the attributes in the second row. I have merged the
appropriate number of cells in this first row to reflect that aggregate
grouping of the second row. I want the first line to be horizontal (ie.,
orientation is zero degrees). My problem is getting the grid lines (or is it
the border?) of the columns in the first to be oriented at 45 degree lines so
that the outer boundaries of the cells in the first row align with the 45
degree angle of the gridlines of the second row. Hope I have decribed this
sufficiently.

Any help with this would be appreciated.

Thanks - Dave