ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   split cells (https://www.excelbanter.com/excel-discussion-misc-queries/38737-split-cells.html)

mwuttke

split cells
 
How do I split a cell diagonally and put data on both sides?

Dave Peterson

You may be able to get that look by typing a value and hitting alt-enter (to
force a new line within the cell) (and then add some spaces to the top or bottom
depending on the direction of the diagonal).

Format|Cells|border tab is where you could draw the diagonal.

But once you do this, it may look nice(?), but it'll become really awful to
extract stuff you need for other formulas. (I wouldn't do it.)

mwuttke wrote:

How do I split a cell diagonally and put data on both sides?


--

Dave Peterson


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

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