AjapaReporter

Home life · Updated

How to Shrink Multiple Columns in Excel

Time it takes5 min
Steps5in the list below
LevelEasyno special skills
Official sourceMicrosoft Supportcheck it for changes

Quick answer Select the columns you want to shrink, then drag the boundary of any selected column header to the desired width, or use the Format menu to set a specific width for all selected columns at once.

What You’ll Need

  • Microsoft Excel (desktop, web, or mobile) with the workbook open
  • The columns you want to shrink should be visible on the sheet

Step-by-Step

  1. Select the columns – Click the letter header of the first column, hold down the mouse button, and drag across the headers of all columns you want to shrink. To select non-adjacent columns, hold Ctrl (Windows) or Cmd (Mac) while clicking each column header.
  2. Drag the boundary to shrink – With the columns selected, move your cursor to the right edge of any selected column header (the line between two letters). The cursor will change to a double-headed arrow. Click and drag left to make the columns narrower. Release the mouse when the columns reach the desired width. All selected columns will shrink to the same width.
  3. Use the Format menu for exact width – If you need a specific width, keep the columns selected, go to the Home tab, click Format in the Cells group, and choose Column Width. Enter a number (e.g., 8) and click OK. This sets all selected columns to that exact width.
  4. Auto-fit to content (optional) – To shrink columns to fit their content automatically, select the columns, then double-click the right boundary of any selected column header. Excel will resize each column to the smallest width that shows all text in the cells (but note this may not make them narrower if content is long).
  5. Use the right-click shortcut – Alternatively, right-click any selected column header and choose Column Width from the context menu. Enter the desired width and click OK. This works the same as the Format menu option.

Common Mistakes

  • Selecting only one column – If you click a single column header and drag, only that column will shrink. Make sure you select all columns you want to affect before dragging or using the menu.
  • Dragging the wrong boundary – Dragging the left edge of a column header resizes the column to the left, not the one you clicked. Always drag the right edge of the column you want to shrink.
  • Not selecting entire columns – If you select cells instead of column headers, dragging the boundary will only resize the column of the selected cells, not all columns. Always click the letters at the top.
  • Overlapping content – Shrinking columns too much can hide text. If you see ### instead of numbers, the column is too narrow. Increase the width slightly.

Tips

  • Use a keyboard shortcut – After selecting columns, press Alt + H + O + W (Windows) to open the Column Width dialog quickly. On Mac, use Cmd + Option + O + W.
  • Set a default width – To change the default width for all columns on the sheet, go to Home > Format > Default Width. This affects new columns you add, but not existing ones unless you select them.
  • Undo if you make a mistake – Press Ctrl + Z (Windows) or Cmd + Z (Mac) immediately to revert the last change.
  • Apply to entire worksheet – To shrink all columns on the sheet, click the triangle at the top-left corner (where row and column headers meet) to select the whole sheet, then drag any column boundary.

Troubleshooting

  • Columns don’t shrink equally – If you drag a boundary and only one column changes, you probably didn’t select all columns. Re-select the headers and try again.
  • Text is cut off – After shrinking, if text is truncated, you can either increase the width or enable text wrapping (Home > Wrap Text) to show content on multiple lines without widening the column.
  • Numbers show as ### – This is Excel’s way of saying the column is too narrow to display the number. Widen the column slightly or change the number format to a shorter version (e.g., fewer decimals).
  • Can’t drag because of merged cells – If columns contain merged cells, dragging may not work as expected. Unmerge the cells (Home > Merge & Center) before resizing, or resize manually.
  • Web version limitations – In Excel for the web, the drag method works, but the keyboard shortcuts may differ. Use the Format menu instead for precise control.

Frequently Asked Questions

Can I shrink multiple columns to different widths at once?

No, the methods above set all selected columns to the same width. To have different widths, you need to adjust each column individually.

How do I shrink columns to fit text automatically?

Select the columns, then double-click the right boundary of any selected header. Excel will auto-fit each column to its content, but this may make columns wider if content is long.

What is the minimum column width in Excel?

The minimum column width is 0, which hides the column entirely. To unhide, select columns on both sides and drag the boundary or use Format > Column Width.

Does shrinking columns affect data?

No, it only changes the display width. The data remains intact and can be viewed by widening the column again or selecting the cell and reading the formula bar.

Can I shrink all columns on a sheet at once?

Yes, click the triangle at the top-left corner to select the entire sheet, then drag any column boundary or use the Format menu.

Why do my columns not shrink when I drag?

Make sure you are dragging the boundary between column letters, not the edge of the sheet. Also check that the sheet is not protected (Review > Unprotect Sheet) if dragging is disabled.

Sources: Microsoft Support. Menus and buttons can differ slightly by version. Spotted something out of date? Tell us.