Distribute Spreadsheet Text For Free

Below are the steps to do this: Select the column you need to autofit. Click the Home tab. In the Cells group, click on the 'Format' option. This will show additional options in the drop-down. Click on the 'Autofit Column Width' option.

Select the cell, range, or entire column that contains the text values that you want to split. On the Data tab, in the Data Tools group, click Text to Columns. Follow the instructions in the Convert Text to Columns Wizard to specify how you want to divide the text into separate columns.

Select the cell or range for which you want to adjust the row height. On the Home tab, in the Cells group, click Format. Under Cell Size, do one of the following: To automatically adjust the row height, click AutoFit Row Height.

Increase the spacing for text in a cell Right-click in the cell you want, and click Format cells. On the Alignment tab, change Vertical to Justify. Click OK. Your text is now distributed evenly inside the cell. If you change the height of the row, the text re-adjusts evenly to the new width.

Make multiple columns or rows the same size Select the columns or rows you want to make the same size. You can press CTRL while you select to choose several sections that are not next to each other. On the Layout tab, in the Cell Size group, click Distribute Columns. or Distribute Rows .

Hold down Shift , click the objects that you want to align, and then click the Shape Format tab. Click Arrange > Align, and select an alignment option. If you displayed the gridlines, you will see that the objects are aligned on the grid.

Here's how. Select one or more cells containing the text you want to wrap. Select a header to highlight an entire row or column.Go to the Format menu. Select the Text wrapping option to open a submenu containing three options:The cell enlarges to fit the text.