#Fit text into cell excel how to

Select the cell or range of cells ➪ Right Click ➪ Click Format Cells from the list which will open the Format cells dialog box. (01) Open Format Cells Using the Right-click: ■ Note: Alternative way to open the Format Cells dialog box: Select the cell or range of cells ➪ Press Ctrl+1 which will open the Format cells dialog box ➪ Choose the Alignment tab ➪ Select the Wrap text checkbox in the Text control section ➪ Press Enter or click OK. ➢ METHOD 3: WRAP TEXT IN EXCEL USING FORMAT CELLS DIALOG BOX Similarly, we can increase or decrease the row height by dragging the separator in between row number 1 and row number 2. ■ Note: If required, we can increase the column width by dragging the separator in between column A and column B.

Select the cell or range of cells ➪ Go to the Home tab ➪ Click Wrap Text button in the Alignment group. ■ Note: We had detail discussed on ALT shortcuts in a separate tutorial, suggested you read this tutorial: 80+ Excel Shortcuts with ALT Key || Best Hotkey of Keyboard ShortcutsĪdditionally, suggest you read Ctrl Shortcuts: 90+ Best Excel CTRL Shortcuts | Useful Keyboard Shortcuts | ➢ METHOD 2: WRAP TEXT IN EXCEL USING ‘WRAP TEXT’ BUTTON IN THE RIBBON Select the cell or range of cells ➪ Press Alt+H+W (sequentially press Alt, H, W) which will apply the wrap text in Excel. We should apply either of the following 04 methods: ➢ METHOD 1: USING EXCEL WRAP TEXT SHORTCUT ALT+H+W Apparently, it covers cell B1 and C1.Ĭlick the cell or select the range of cells that contain long text strings that need to be wrapped. In the given example, cell A1 contains a long text string and B1 is empty. If we change the column width, the text wrapping and row height adjust automatically. The cell width remains unchanged but increases row height automatically. The Wrap Text in Excel instructs Excel to break up a long text value into several lines within the cell without truncating the text.

#Fit text into cell excel how to

But the question arises in mind what is the wrap text and how to wrap text in Excel?īy default, long lines of text we enter into a cell remain on one line. During data entry and data presentation, every Excel user must use the Wrap Text.