#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Column Headings

I have seen Column Headings that were diagonal and wondered how this is done.
Thank you.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 270
Default Column Headings

FormatCellsAlignment - Set orientation as required
Sandy

"J. Bell" <J. wrote in message
...
I have seen Column Headings that were diagonal and wondered how this is
done.
Thank you.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,420
Default Column Headings

Select the cell, goto FormatCellsAlignment and pick the Orientation, then
put a border around the cell.

--
__________________________________
HTH

Bob

"J. Bell" <J. wrote in message
...
I have seen Column Headings that were diagonal and wondered how this is
done.
Thank you.



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Column Headings

You cannot physically slant cells, but you can format them to look slanted.

First, place a border around the cell and color it a nice color.

Then FormatCellAlignment.

Use the protractor to orient the text at 30 or 40 degrees.

Experiment with row height and column width.until you get the effect you want.


Gord Dibben MS Excel MVP

On Fri, 11 Jul 2008 08:51:01 -0700, J. Bell <J.
wrote:

I have seen Column Headings that were diagonal and wondered how this is done.
Thank you.


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
Worksheet has numeric column headings. Change to alpha headings? Be Frank Excel Discussion (Misc queries) 1 June 18th 08 04:22 PM
Column headings to numbers and row headings to alphabets? Juliana Excel Discussion (Misc queries) 2 May 9th 08 05:58 PM
How do I take information in 1 column to make column headings? Northside Excel Discussion (Misc queries) 1 December 16th 05 09:47 PM
How do I create column headings in Excel in the A, B, C etc column eliannaj Excel Discussion (Misc queries) 2 November 23rd 05 06:48 PM
Can I invert a table so row headings are now column headings etc Sharon Excel Worksheet Functions 3 February 10th 05 07:28 PM


All times are GMT +1. The time now is 05:44 AM.

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

About Us

"It's about Microsoft Excel"