angled text and gridlines

[Jan]

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

[Gord Dibben]

Jan

Select the cells and Format>Cells>Alignment.

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 <[email protected]> wrote:

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

[Jan]

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 Format>Cells>Alignment.
>
> 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 <[email protected]> wrote:
>
> >How do I created a spreadsheet or chart and use angled text and gridline
> >lines for the column headings?
>
>

[Gord Dibben]

Thanks for the feedback.


Gord

On Sun, 23 Jul 2006 16:07:02 -0700, Jan <[email protected]> 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 Format>Cells>Alignment.
>>
>> 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 <[email protected]> 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