| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 | |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I slant the column headers so they are more readable?
Thank you Hish! That was the solution!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make column values column headers | Excel Discussion (Misc queries) | |||
| How do I slant field cell in the first row of a spreadsheet? | Excel Worksheet Functions | |||
| Excel - returning column headers in a seperate column | Excel Discussion (Misc queries) | |||
| How to slant cells in Excel on top of chart at about 45 degrees | Excel Discussion (Misc queries) | |||
| How do I slant grid line at top of each column? | Excel Discussion (Misc queries) | |||
Linear Mode
