Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 13
Default Excel XP - Diagonal line in a cell

How do I create a diagonal line separating "Day" and "Time" in a cell?


  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,480
Default Excel XP - Diagonal line in a cell

Hi

FormatCellBorderchoose diagonal
FormatCellsAlignmentWrap TextVerticalCenter

Type several spaces them TimeAlt+Enter to force a line feedDay

You will need to play about with cell width and height to suit, and adjust
the number of spaces before Time

--
Regards
Roger Govier

"Sulasno" wrote in message
...
How do I create a diagonal line separating "Day" and "Time" in a cell?

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 13
Default Excel XP - Diagonal line in a cell

thanks for your prompt response

works as advertised

thanks a lot


"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi

FormatCellBorderchoose diagonal
FormatCellsAlignmentWrap TextVerticalCenter

Type several spaces them TimeAlt+Enter to force a line feedDay

You will need to play about with cell width and height to suit, and adjust
the number of spaces before Time

--
Regards
Roger Govier

"Sulasno" wrote in message
...
How do I create a diagonal line separating "Day" and "Time" in a cell?



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
Can two formats be applied to a cell with a diagonal border Deb-Ellen Excel Discussion (Misc queries) 1 May 7th 08 10:28 AM
How do I make zeros show up with a diagonal line across them? jhe2006 Excel Discussion (Misc queries) 2 August 17th 06 05:34 PM
diagonal line and data input John Excel Discussion (Misc queries) 3 January 25th 06 12:29 AM
How do I place diagonal lines in a cell in Excel. ezas1040 Excel Discussion (Misc queries) 3 February 25th 05 05:59 AM
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? g wills New Users to Excel 3 February 17th 05 10:23 PM


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