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
- Jun 22 Fri 2007 20:37
Merging Cells and autofit
close
全站熱搜
留言列表
發表留言