Spread Out Columns Text For Free

Make multiple rows or columns the same size Select the columns or rows that you want to make the same size, and then click the Table Layout tab. Under Cells, click Distribute Rows or Distribute Columns.

Select the column or columns that you want to change. Go to Home > Cells > Format. Under Cell Size, select AutoFit Column Width. Note: To quickly autofit all columns on the worksheet, select Select All, and then double-click any boundary between two column headings.

Distribute the contents of a cell into adjacent columns 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.

Select the column or columns that you want to change. Go to Home > Cells > Format. Under Cell Size, select AutoFit Column Width. Note: To quickly autofit all columns on the worksheet, select Select All, and then double-click any boundary between two column headings.

On the Layout tab, in the Cell Size group, click in the Table Column Width box, and then specify the options you want. To make the columns in a table automatically fit the contents, click on your table. On the Layout tab, in the Cell Size group, click AutoFit, and then click AutoFit Contents.

Try it! Select the cell or column that contains the text you want to split. Select Data > Text to Columns. In the Convert Text to Columns Wizard, select Delimited > Next. Select the Delimiters for your data. ... Select Next. Select the Destination in your worksheet which is where you want the split data to appear.

Here's how: Select the rows and columns you want to resize by clicking and dragging your cursor across the desired cells. Right-click on one of the selected rows or columns and choose "Row Height" or "Column Width." In the appropriate window, enter the desired height or width. Click "OK."