ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   enter 2 values in opposite corners of a cell (https://www.excelbanter.com/excel-discussion-misc-queries/46926-enter-2-values-opposite-corners-cell.html)

itsthebike

enter 2 values in opposite corners of a cell
 

Is this possible? I've seen it on Excel (hardcopy) documents before,
where the cell is split with a diagonal line, but am unsure how it's
done ... if at all possible. (I know how to put the diagonal line in
the cell.) Can it be done, or has the author done some other type of
tweaking to the worksheet which is outside of Excel's typical
functionality?


--
itsthebike
------------------------------------------------------------------------
itsthebike's Profile: http://www.excelforum.com/member.php...o&userid=27425
View this thread: http://www.excelforum.com/showthread...hreadid=470301


Michael

Hi. If you enter one value and then put in hard line returns (ctrl-enter)
and then some spaces and then the second value, you can foirce the two into
opposite corners.
--
Sincerely, Michael Colvin


"itsthebike" wrote:


Is this possible? I've seen it on Excel (hardcopy) documents before,
where the cell is split with a diagonal line, but am unsure how it's
done ... if at all possible. (I know how to put the diagonal line in
the cell.) Can it be done, or has the author done some other type of
tweaking to the worksheet which is outside of Excel's typical
functionality?


--
itsthebike
------------------------------------------------------------------------
itsthebike's Profile: http://www.excelforum.com/member.php...o&userid=27425
View this thread: http://www.excelforum.com/showthread...hreadid=470301




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

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