ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I slant the column headers so they are more readable? (https://www.excelbanter.com/excel-discussion-misc-queries/177945-how-do-i-slant-column-headers-so-they-more-readable.html)

Zeffy

How do I slant the column headers so they are more readable?
 
I've seen docs where the column headers are slanted, and the text is
vertical, but not completely vertical. I can't find how to create those, or
if it can even be done in Excel or Word.

Am I painting a clear enough picture of what I mean?

Maggie in VT

FSt1

How do I slant the column headers so they are more readable?
 
hi.
slanted header?
right click the cell or range you want slanted text.
click format cells
click the alignment tab.
adjust the orientation by clicking and holding the horizontal line or by
clilcking on the spin buttons at the bottom of the orientation box. adjust to
45 degrees.
click ok
done.

Regards
FSt1


"Zeffy" wrote:

I've seen docs where the column headers are slanted, and the text is
vertical, but not completely vertical. I can't find how to create those, or
if it can even be done in Excel or Word.

Am I painting a clear enough picture of what I mean?

Maggie in VT


Niek Otten

How do I slant the column headers so they are more readable?
 
Hi Maggie,

In Excel:

FormatCellsAlignment tab, drag the Orientation gauge

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Zeffy" wrote in message ...
| I've seen docs where the column headers are slanted, and the text is
| vertical, but not completely vertical. I can't find how to create those, or
| if it can even be done in Excel or Word.
|
| Am I painting a clear enough picture of what I mean?
|
| Maggie in VT



Gord Dibben

How do I slant the column headers so they are more readable?
 
Note: the suggestion in the other replies just slant the text in the cells, but
does not actually slant the cells if that's what you wanted to occur.

Good enough for appearance though.

Also helps to give those cells borders and a background color so they really
"look" slanted.


Gord Dibben MS Excel MVP


On Tue, 26 Feb 2008 11:55:02 -0800, Zeffy
wrote:

I've seen docs where the column headers are slanted, and the text is
vertical, but not completely vertical. I can't find how to create those, or
if it can even be done in Excel or Word.

Am I painting a clear enough picture of what I mean?

Maggie in VT



Niek Otten

How do I slant the column headers so they are more readable?
 
Thanks for a useful addition, Gord!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
| Note: the suggestion in the other replies just slant the text in the cells, but
| does not actually slant the cells if that's what you wanted to occur.
|
| Good enough for appearance though.
|
| Also helps to give those cells borders and a background color so they really
| "look" slanted.
|
|
| Gord Dibben MS Excel MVP
|
|
| On Tue, 26 Feb 2008 11:55:02 -0800, Zeffy
| wrote:
|
| I've seen docs where the column headers are slanted, and the text is
| vertical, but not completely vertical. I can't find how to create those, or
| if it can even be done in Excel or Word.
|
| Am I painting a clear enough picture of what I mean?
|
| Maggie in VT
|



[email protected]

How do I slant the column headers so they are more readable?
 
On Tuesday, February 26, 2008 at 3:06:00 PM UTC-5, FSt1 wrote:
hi.
slanted header?
right click the cell or range you want slanted text.
click format cells
click the alignment tab.
adjust the orientation by clicking and holding the horizontal line or by
clilcking on the spin buttons at the bottom of the orientation box. adjust to
45 degrees.
click ok
done.

Regards
FSt1


"Zeffy" wrote:

I've seen docs where the column headers are slanted, and the text is
vertical, but not completely vertical. I can't find how to create those, or
if it can even be done in Excel or Word.

Am I painting a clear enough picture of what I mean?

Maggie in VT





tried the instructions and could not get it to work in writer, what am I doing wrong?

Charlie

GS[_6_]

How do I slant the column headers so they are more readable?
 
On Tuesday, February 26, 2008 at 3:06:00 PM UTC-5, FSt1 wrote:
hi.
slanted header?
right click the cell or range you want slanted text.
click format cells
click the alignment tab.
adjust the orientation by clicking and holding the horizontal line
or by clilcking on the spin buttons at the bottom of the
orientation box. adjust to 45 degrees.
click ok
done.

Regards
FSt1


"Zeffy" wrote:

I've seen docs where the column headers are slanted, and the text
is vertical, but not completely vertical. I can't find how to
create those, or if it can even be done in Excel or Word.

Am I painting a clear enough picture of what I mean?

Maggie in VT





tried the instructions and could not get it to work in writer, what
am I doing wrong?

Charlie


The column headers themselves can't be modified this way, but you can
turn them off and use the top row set up for angled text, backcolor,
and borders to 'immitate' column headers.

--
Garry

Free usenet access at
http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

[email protected]

How do I slant the column headers so they are more readable?
 
Tilt up, then add boarders (all edges). Tada!

On Tuesday, February 26, 2008 at 12:06:00 PM UTC-8, FSt1 wrote:
hi.
slanted header?
right click the cell or range you want slanted text.
click format cells
click the alignment tab.
adjust the orientation by clicking and holding the horizontal line or by
clilcking on the spin buttons at the bottom of the orientation box. adjust to
45 degrees.
click ok
done.

Regards
FSt1


"Zeffy" wrote:

I've seen docs where the column headers are slanted, and the text is
vertical, but not completely vertical. I can't find how to create those, or
if it can even be done in Excel or Word.

Am I painting a clear enough picture of what I mean?

Maggie in VT



Erica Jones

How do I slant the column headers so they are more readable?
 
Thank you Hish! That was the solution!


All times are GMT +1. The time now is 09:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com