angled text and gridlines
 

How do I created a spreadsheet or chart and use angled text and gridline
lines for the column headings?

angled text and gridlines
 

Jan

Select the cells and FormatCellsAlignment.

Set the text angle to 45 degrees or whatever suits.

Place borders around each cell.

Colour the cells to make them stand out if needed.

Note: the cells are not angled, just the text in the cells.


Gord Dibben MS Excel MVP


On Sun, 23 Jul 2006 15:49:02 -0700, Jan wrote:

How do I created a spreadsheet or chart and use angled text and gridline
lines for the column headings?

angled text and gridlines
 

Thanks a lot. I had been trying to "border cells after keying the data" and
was also trying to use the border tab. Works perfectly now. Thanks!

"Gord Dibben" wrote:

Jan

Select the cells and FormatCellsAlignment.

Set the text angle to 45 degrees or whatever suits.

Place borders around each cell.

Colour the cells to make them stand out if needed.

Note: the cells are not angled, just the text in the cells.


Gord Dibben MS Excel MVP


On Sun, 23 Jul 2006 15:49:02 -0700, Jan wrote:

How do I created a spreadsheet or chart and use angled text and gridline
lines for the column headings?

angled text and gridlines
 

Thanks for the feedback.


Gord

On Sun, 23 Jul 2006 16:07:02 -0700, Jan wrote:

Thanks a lot. I had been trying to "border cells after keying the data" and
was also trying to use the border tab. Works perfectly now. Thanks!

"Gord Dibben" wrote:

Jan

Select the cells and FormatCellsAlignment.

Set the text angle to 45 degrees or whatever suits.

Place borders around each cell.

Colour the cells to make them stand out if needed.

Note: the cells are not angled, just the text in the cells.


Gord Dibben MS Excel MVP


On Sun, 23 Jul 2006 15:49:02 -0700, Jan wrote:

How do I created a spreadsheet or chart and use angled text and gridline
lines for the column headings?



Gord Dibben MS Excel MVP