Spread Out Columns Record For Free

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 .

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."

Resize columns Select a column or a range of columns. On the Home tab, select Format > Column Width (or Column Height). Type the column width and select OK.

Here's how: Select the range of data you want to rearrange, including any row or column labels, and either select Copy. ... Select the first cell where you want to paste the data, and on the Home tab, click the arrow next to Paste, and then click Transpose.

Select a column or a range of columns. On the Home tab, select Format > Column Width (or Column Height). Type the column width and select OK.

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.

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.