ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Excel XP - Diagonal line in a cell (https://www.excelbanter.com/new-users-excel/187713-excel-xp-diagonal-line-cell.html)

Sulasno[_2_]

Excel XP - Diagonal line in a cell
 
How do I create a diagonal line separating "Day" and "Time" in a cell?



Roger Govier[_3_]

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?


Sulasno[_2_]

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?





All times are GMT +1. The time now is 02:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com