I have created a cell and added a diagonal line across the cell, from bottom
left to top right corner. How can I enter data into the two divided areas?
Example:
I have column that has Set/Reps as the column heading, and want to enter 2
in one top left corner and 10 in the bottom right hand corner of a cell.
I am using Excel 2003
Thanks
JohnYou could fiddle using alt-enters and spacebars. But remember that this will
make using the contents of each part of that cell a lot more difficult. If I
were you, I wouldn't do it. Just use a couple of cells.
John wrote:
gt;
gt; I have created a cell and added a diagonal line across the cell, from bottom
gt; left to top right corner. How can I enter data into the two divided areas?
gt; Example:
gt; I have column that has Set/Reps as the column heading, and want to enter 2
gt; in one top left corner and 10 in the bottom right hand corner of a cell.
gt; I am using Excel 2003
gt; Thanks
gt; John
--
Dave Peterson
Alternatively, if these are just labels you could format cells as Text
and enter the Set/Reps info this way:
4 / 10Thanks for the replys. Seem silly that the option of putting the line in and
then not having a way to input the data into the cell. But thanks for the
help. John
quot;Johnquot; wrote:
gt; I have created a cell and added a diagonal line across the cell, from bottom
gt; left to top right corner. How can I enter data into the two divided areas?
gt; Example:
gt; I have column that has Set/Reps as the column heading, and want to enter 2
gt; in one top left corner and 10 in the bottom right hand corner of a cell.
gt; I am using Excel 2003
gt; Thanks
gt; John
gt;
- Nov 21 Wed 2007 20:40
diagonal line and data input
close
全站熱搜
留言列表
發表留言