Wrap Text automatically: Wrap Text is located in the Alignment group on the Home tab. The data in the cell wraps to fit the column width, thus if the column width changes, the data wrapping changes as well. Wrap Text manually: To open the Format Cells dialog, use Ctrl + 1. (or right-click the selected cells and then click Format Cells). Select the Wrap Text option on the Alignment tab and click OK.