Wrapping text in Microsoft Excel 2019

Data can appear on multiple lines within a single cell. Text wrappingis set using more than one method. Use the Wrap Text icon on the Home tab, the Format Cells dialog box, or by inserting aline break manually.

Using a line break to wrap text manually gives the user morecontrol over where the text should wrap:

  1. Click on an empty cell on the worksheet, and then type thetext Safest Solutions into the cell.
  2. Directly after the typed words, press Alt + Enter on thekeyboard, which will insert the line break and move the cursor down tothe next line in the cell.
  3. Type the word Group.
  4. Press Enter on your keyboard to accept the text or click onanother cell to exit. The result can be seen in the followingscreenshot:
ms office 238
  1. To use the ribbon to wrap text, click on the Home tab, and then locate the Alignment group.
  2. Click on the Wrap Text icon, andthe text is wrapped.
Indenting text:
Indentation means to move data toward the left or right within the cell.You can indent your data by going to the Home Alignment group and selecting eitherthe Increase Indent iconor the Decrease Indenticon.

Leave a Comment