![]() I tried 6 of the 7 answers that were here (excepted the text boxing) and with a bit of fiddling the ideas all worked but, on some rows only. A terrible and labor intensive solution, but it does work. I then make sure the column is a little wider than my chosen text width, and I won't get any extra blank lines. In this case, the only solution that I have found is to manually wrap the text to my chosen width by inserting extra carriage returns in the middle of the text at the position that I'd like the text to wrap using alt+enter. ![]() ![]() Changing the width will clean up some cells, and add unnecessary blanks to others. Of course, if your worksheet has hundreds of rows, then each cell in that column has a certain chance of hitting the magic spot, and adding the extra line. Once the column is wider, auto size the row by double-clicking the divider between the row headers on the left side of the worksheet. You can widen the column by clicking and dragging the divider between the two column headers at the top of the worksheet. Try different widths until auto-sizing the height gets rid of the blank line. Apparently word wrap messes up with particular cell values and particular widths. I found that if you change the width of the column that contains the cell with the extra blank line, then auto sizing the height of the row will usually get rid of the extra blank line. I am using Office/Excel 2007 for Windows. But, I need to enter in comments on this sheet and use the Text Wrap feature. Is there some other setting I can use to get rid of this extra blank line? I realize that Excel isn't really made for word processing. Nothing there gets rid of this extra blank line. I have searched the Format Cells window.I am using the default font when I am entering the text. I am not using Bold, Italic or any other font setting.I tried copying/pasting the text into Notepad and then back into Excel to try to get rid of any formatting.Adjusting the width of the cell doesn't help.The Auto Format Height option does not get rid of the extra blank line.My text is formatted to be aligned to the Top and Left. I have put the cursor at the end of the text and used the Delete key. When I type a long sentence (or more than one sentence) into more than one cell in a row and apply the Text Wrap option to these cells, the cells have an extra blank line on the bottom of them.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |