LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 577
Default Column heading at 45 degrees

I need some help with a column heading question. I have about 1/2 of this
problem figured out but I still need some input.

What I'm trying to do:
In range B12:B21 ( and in all columns to the right in rows 12:21), I have a
column heading. I'd like to maintain a column width of 10 and show the column
title reading left to right going up at 45 degrees. Visually, it would appear
that the column heading is merging into columns C:D as the heading is angled
at 45 degrees.

What I've done:
I've used Format - Cells - Alignment - 45 degrees which shows the heading
text at an angle. The problem I'm having is that the heading is all within
column B and I have to widen the column to show the heading. How do I angle
the cell range B12:B21 to 45 degrees as opposed to just having the text at a
45 degree angle? I've seen this in another spreadsheet so I know it can be
done.

Thanks for your help,
Scott
 
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
how can i multiply two columns edgar Excel Worksheet Functions 7 March 2nd 06 03:29 PM
Formula to Return Column Heading den4673 Excel Discussion (Misc queries) 4 February 13th 06 09:55 PM
Need keystrokes equivalent to dragging one column heading onto ano [email protected] Excel Discussion (Misc queries) 2 February 7th 06 08:38 PM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
How to enter a two line column heading in excel Sharon New Users to Excel 9 April 6th 05 06:49 PM


All times are GMT +1. The time now is 04:43 PM.

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

About Us

"It's about Microsoft Excel"