Apply Wrap Text from the Format Cells Dialog Box.See how the text looks before and after wrapping: What happens when the text is wrapped? The text compacts into the cell it was originally written in with no impact on the column width but increased row height. The options are simple, one of which requires a single click. When we say "we wrap the text", we don't really do anything strenuous Excel is more than willing to do it for us. If you don't mind expanding the column width to accommodate all the text, adjust the column width or double click the column width in the column header and Bob's your uncle.īut if we don't want Bob as our uncle and want to compact the text to be displayed completely in one cell without compromising on column width, we wrap the text. If the cells on the right are preoccupied, the text will seem to hide behind the preoccupied cells. You will notice the text sprawled all the way to the cells on the right. For fitting more than one word in, there is no need to resort to a different column or row or keep adjusting with Alt + Enter. With an acceptable font size, fitting 7-8 characters in a cell is no problem. A quick look at an Excel sheet can tell you that the regular size of a cell is a decent fit for numbers but for this tutorial, we are more concerned about a cell's fit for text.
0 Comments
Leave a Reply. |