Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jan Jan is offline
external usenet poster
 
Posts: 159
Default angled text and gridlines

How do I created a spreadsheet or chart and use angled text and gridline
lines for the column headings?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default angled text and gridlines

Jan

Select the cells and FormatCellsAlignment.

Set the text angle to 45 degrees or whatever suits.

Place borders around each cell.

Colour the cells to make them stand out if needed.

Note: the cells are not angled, just the text in the cells.


Gord Dibben MS Excel MVP


On Sun, 23 Jul 2006 15:49:02 -0700, Jan wrote:

How do I created a spreadsheet or chart and use angled text and gridline
lines for the column headings?


  #3   Report Post  
Posted to microsoft.public.excel.misc
Jan Jan is offline
external usenet poster
 
Posts: 159
Default angled text and gridlines

Thanks a lot. I had been trying to "border cells after keying the data" and
was also trying to use the border tab. Works perfectly now. Thanks!

"Gord Dibben" wrote:

Jan

Select the cells and FormatCellsAlignment.

Set the text angle to 45 degrees or whatever suits.

Place borders around each cell.

Colour the cells to make them stand out if needed.

Note: the cells are not angled, just the text in the cells.


Gord Dibben MS Excel MVP


On Sun, 23 Jul 2006 15:49:02 -0700, Jan wrote:

How do I created a spreadsheet or chart and use angled text and gridline
lines for the column headings?



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default angled text and gridlines


Thanks for the feedback.


Gord

On Sun, 23 Jul 2006 16:07:02 -0700, Jan wrote:

Thanks a lot. I had been trying to "border cells after keying the data" and
was also trying to use the border tab. Works perfectly now. Thanks!

"Gord Dibben" wrote:

Jan

Select the cells and FormatCellsAlignment.

Set the text angle to 45 degrees or whatever suits.

Place borders around each cell.

Colour the cells to make them stand out if needed.

Note: the cells are not angled, just the text in the cells.


Gord Dibben MS Excel MVP


On Sun, 23 Jul 2006 15:49:02 -0700, Jan wrote:

How do I created a spreadsheet or chart and use angled text and gridline
lines for the column headings?




Gord Dibben MS Excel MVP
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
Copy text, not gridlines Excel Question Excel Discussion (Misc queries) 0 June 9th 06 11:17 PM
I just want to print an excel sheet showing gridlines with no text jiggityjohnson New Users to Excel 4 January 16th 06 05:39 PM
gridlines print over text martikaih Excel Discussion (Misc queries) 4 August 6th 05 03:57 AM
How do I set my color default for gridlines & text? Excel default grid colors Setting up and Configuration of Excel 1 April 11th 05 10:24 PM
excel gridlines print on top of text LaurieO Excel Discussion (Misc queries) 1 January 7th 05 01:05 AM


All times are GMT +1. The time now is 06:09 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"