Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 26th 08, 08:55 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2008
Posts: 1
Default 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   Report Post  
Old February 26th 08, 09:06 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,942
Default 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   Report Post  
Old February 26th 08, 09:09 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,440
Default 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   Report Post  
Old February 27th 08, 12:46 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22,907
Default 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   Report Post  
Old February 27th 08, 09:28 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,440
Default 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   Report Post  
Old March 18th 16, 11:47 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2016
Posts: 1
Default 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   Report Post  
Old March 18th 16, 05:49 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2015
Posts: 1,182
Default 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   Report Post  
Old December 15th 17, 08:11 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2017
Posts: 1
Default 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   Report Post  
Old July 15th 20, 12:25 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2020
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
make column values column headers dunskii Excel Discussion (Misc queries) 5 September 19th 06 12:00 PM
How do I slant field cell in the first row of a spreadsheet? Ed Excel Worksheet Functions 2 August 11th 06 06:44 PM
Excel - returning column headers in a seperate column ExcelConfused Excel Discussion (Misc queries) 1 March 28th 06 02:49 PM
How to slant cells in Excel on top of chart at about 45 degrees ckricci Excel Discussion (Misc queries) 2 August 30th 05 06:36 PM
How do I slant grid line at top of each column? dick41ross Excel Discussion (Misc queries) 4 August 24th 05 11:51 PM


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

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017