since we have applied Wrap Text to column B.

From the Home tab, in the Alignment group, click on the Wrap Text command button.Ĭonsider the text wrapped! Once Wrap Text is applied, any text entered in the text-wrapped cells will automatically be wrapped.

Hence, instead of extending the column width, we will wrap the text like this: Being a receipt, we'd like to keep it this compact. That is one delicious receipt but the longer item names are hiding behind the next column. See if you can figure out the problem here:

Removing Wrap Text Using Keyboard Shortcut.

Removing Wrap Text Using Format Cells dialog box.

Apply Wrap Text Using Keyboard Shortcut.

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.

Fit text in excel cell