Spread Out Columns Notice For Free

AutoFit column width and row height using a keyboard shortcut To AutoFit column width: Alt + H, then O, and then I. To AutoFit row height: Alt + H, then O, and then A.

To make the column or row expand itself to whatever the biggest cell is, double click on the right of the column or row. To expand or shrink the row yourself, click on the line after the column or row that you want to resize and drag it up/down or left/right.

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.

The Worksheet is Protected To widen columns on a protected worksheet, you will need to unprotect the worksheet first. To do this, go to the "Review" tab and click "Unprotect Sheet." Once the worksheet is unprotected, you should be able to double-click to widen columns.

About This Article Click the Data tab. Click Group. Select Columns and click OK. Click ? to collapse. Click + to uncollapse.

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 .

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.