Asked By
Marlo Brown
10 points
N/A
Posted on - 07/17/2011
Only the second line of multiple line texts inserted in cell is seen
I have inserted multiple lines of texts in a Microsoft Excel cell which height was fixed to 25 pixels with a cell format enabled “Wrap Text”. I can’t see the first line of the text instead the second line was seen. I want to see the first line of the texts but I don’t know how to do it. I am using Microsoft Office Excel 2007. Please help.
Only the second line of multiple line texts seen in cell
Only the second line of multiple line texts inserted in cell is seen
At a default, Microsoft Excel 2007 cells are not formatted or Wrap Text enabled. If you have inserted multiple texts in a cell, the cell will automatically set to enable Wrap Text. The cell also expands its height automatically with the height that fits the inserted multiple line of texts.
If you have formatted the height of the rows before you have inserted a multiple line of text, it will happen. But if you paste the multiple line of text before the row height was changed, the issueddoesn’t occur.
By the way, it is a simple way to solve this issue. Either of two – set the height of the row first or even pasting the multiple lines of text first. Just move your cell pointer at the cell where you want to see the first line of the multiple lines of texts you have inserted.
Then click the Home tab if it is not the active tab, then on the Alignment tools, click the Top align. This will align your multiple line texts on the top of the cell, you will then see the first line of the multiple line texts.
Only the second line of multiple line texts seen in cell
To see all the lines of text entered in a single cell you can try one of these methods:
Increase the height of the cell by moving the cursor to the lower part of the row name and dragging it downwards. By right clicking on the row name you can get a popup menu and select the Row Height option there. Then you can give a higher row height to view all the text lines.
Or you can click on Format tool in Cells group in Home tab. Select Auto Fit Row Height option to set the height automatically.
