close

I am trying to do a document in Excel, however some cells have multiple
data....

What I am trying to do is put data underneath, such as name and then under
name put position. However, this is in the same cell, so I type in the name
and then press alt enter to put data underneath....that works perfectly, but
then does not appear in my cell, only the top line does.

How can I quot;autofitquot; so that when data is entered, the cell will
automatically resize to show all data? The data is merged over 4 cells in
the same row, but only uses one row.

It's driving me nuts....I am trying to do a flow chart in EXCEL!!!! Which I
have already done in powerpoint, but have been told it has to be done in
excel for some odd reason!!!

Thanks

Just to add that I have formatted the cell and I have selected quot;wrap textquot; so
that is not what the problem is

quot;Shazquot; wrote:

gt; I am trying to do a document in Excel, however some cells have multiple
gt; data....
gt;
gt; What I am trying to do is put data underneath, such as name and then under
gt; name put position. However, this is in the same cell, so I type in the name
gt; and then press alt enter to put data underneath....that works perfectly, but
gt; then does not appear in my cell, only the top line does.
gt;
gt; How can I quot;autofitquot; so that when data is entered, the cell will
gt; automatically resize to show all data? The data is merged over 4 cells in
gt; the same row, but only uses one row.
gt;
gt; It's driving me nuts....I am trying to do a flow chart in EXCEL!!!! Which I
gt; have already done in powerpoint, but have been told it has to be done in
gt; excel for some odd reason!!!
gt;
gt; Thanks

Goto Format gt; Cells gt; Alignment

Turn on wrap text

GeorgeShaz wrote:
gt; I am trying to do a document in Excel, however some cells have multiple
gt; data....
gt;
gt; What I am trying to do is put data underneath, such as name and then under
gt; name put position. However, this is in the same cell, so I type in the name
gt; and then press alt enter to put data underneath....that works perfectly, but
gt; then does not appear in my cell, only the top line does.
gt;
gt; How can I quot;autofitquot; so that when data is entered, the cell will
gt; automatically resize to show all data? The data is merged over 4 cells in
gt; the same row, but only uses one row.
gt;
gt; It's driving me nuts....I am trying to do a flow chart in EXCEL!!!! Which I
gt; have already done in powerpoint, but have been told it has to be done in
gt; excel for some odd reason!!!
gt;
gt; Thanks

Sorry i missed the part about the merged cells
Try using center across selection in the horizontal
And remove the merged cells check box
See if that helps?

I personally try to avoid merged cells because of these little quirks

George

Shaz wrote:
gt; Just to add that I have formatted the cell and I have selected quot;wrap textquot; so
gt; that is not what the problem is
gt;
gt; quot;Shazquot; wrote:
gt;
gt;
gt;gt;I am trying to do a document in Excel, however some cells have multiple
gt;gt;data....
gt;gt;
gt;gt;What I am trying to do is put data underneath, such as name and then under
gt;gt;name put position. However, this is in the same cell, so I type in the name
gt;gt;and then press alt enter to put data underneath....that works perfectly, but
gt;gt;then does not appear in my cell, only the top line does.
gt;gt;
gt;gt;How can I quot;autofitquot; so that when data is entered, the cell will
gt;gt;automatically resize to show all data? The data is merged over 4 cells in
gt;gt;the same row, but only uses one row.
gt;gt;
gt;gt;It's driving me nuts....I am trying to do a flow chart in EXCEL!!!! Which I
gt;gt;have already done in powerpoint, but have been told it has to be done in
gt;gt;excel for some odd reason!!!
gt;gt;
gt;gt;Thanks

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()