Only the second line of multiple line texts seen in cell

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.

• Status: Open
• Question Views: 1099
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Lucky Mass

Go To Solution

Best Answer

Best Answer

Answered By Lucky Mass 0 points N/A #81500

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.

About Lucky Mass

Questions
0

Answers
10

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 07/17/2011
• Question Category: MS Excel

Answered By nancymartin 0 points N/A #81501

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.

About nancymartin

Questions
0

Answers
4

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 07/28/2011
• Question Category: MS Excel