In Excel, can I have the headings be vertical instead of horizont.

[Guest]

In Excel, can i make my headings vertical instead of horizontal?

 

[Guest]

JJ,

Highlight the headings, right click, hit copy, then go to the first cell of
the vertical position. Right click, press paste special, then click on the
"TRANSPOSE" check box, then press paste. This will change from horizontal to
vertical

Hope this helps

 

[Frank Kabel]

Hi
do you mean 'Format - Cells - alignment'

 

[Gord Dibben]

JJ

Not sure what you're asking for.

Do you want your data including headings Transposed so rows become columns and
vice-versa?

Try Copy>Paste Special>Transpose.

Do you want the text in your headings to be vertical?

Try Format>Cells>Alignment. Use the protractor to re-align the text to 90
degrees.

Post back if I've guessed wrong.

Gord Dibben Excel MVP