The fastest way to resize a column

Double-click the line between two column headers at the top of your spreadsheet. Excel automatically adjusts the column on the left to fit whatever text or numbers are inside it. This is called auto-fit, and it works whether your column contains one cell or a thousand.

If you want to set an exact width instead, right-click the column header, select Column Width, type a number (measured in character units), and press Enter. A width of 20 means the column is wide enough to display about 20 characters.

You can also drag the column border manually. Position your cursor on the line between two column headers until it turns into a resize cursor (a double-headed arrow), then click and drag left or right to make the column narrower or wider.

Key Takeaways

  • Double-clicking the border between column headers auto-fits the column to its content, the fastest method for most situations.
  • Right-clicking a column header and selecting Column Width lets you set an exact width in character units.
  • Dragging the column border manually gives you visual control and works on multiple columns at once if you select them first.
  • Selecting multiple columns and using auto-fit or Column Width applies the change to all of them together.

Resizing multiple columns at the same time

Click the first column header you want to resize, then hold Shift and click the last column in the range. All columns between them are now selected. Double-click any border between the selected column headers to auto-fit all of them, or right-click and choose Column Width to set them all to the same size.

If you want each column to fit its own content independently, select all the columns, then double-click any border between them. Excel adjusts each one separately.

Setting a minimum or maximum width

Excel does not have a built-in minimum or maximum width setting, but you can achieve the same effect by using the Column Width dialog. Right-click the column header, select Column Width, and enter the number you want. If you want to prevent accidental resizing, you can protect the sheet (go to the Review tab and select Protect Sheet), which locks all column widths unless you unprotect it later.

For a softer approach, you can also set column width and then hide the resize handles by selecting the columns and using Format > Column > Optimal Width, which prevents manual dragging but still allows right-click adjustments.

Understanding column width units

Column width in Excel is measured in character units, not pixels or inches. One unit roughly equals the width of one character in the default font (usually Calibri 11-point). A width of 10 means the column can display about 10 characters side by side. A width of 30 means about 30 characters.

The exact width depends on which font and font size your spreadsheet uses. If you change the font, the same width number may display differently. If you need precise measurements in inches or centimeters, you can convert: one character unit is approximately 0.89 inches or 2.26 centimeters, but this varies slightly by font.

Resizing columns to fit printed pages

If you are preparing a spreadsheet to print, you may need to shrink columns so everything fits on one page. Go to Page Layout (or Layout in newer Excel versions), then select Print Area and define the range you want to print. Then use Scale to Fit to automatically shrink or enlarge columns and rows so the content fits your page size.

Alternatively, manually resize columns before printing by selecting all columns (click the box in the top-left corner where row and column headers meet), then double-click any column border to auto-fit everything at once. This usually produces a cleaner printed result than letting Excel scale automatically.

Hiding columns instead of resizing them

If a column is too narrow to be useful or you want to temporarily remove it from view, you can hide it instead of deleting it. Right-click the column header and select Hide. The column is still there — it just does not display. To unhide it later, select the columns on either side of the hidden one, right-click, and choose Unhide.

Hiding is useful when you have sensitive data you do not want to print or share, or when you want to focus on specific columns without losing the data underneath.

Frequently Asked Questions

Why does my column width number not match the actual width I see?

Column width is measured in character units, not pixels, so the visual width depends on your font and font size. If you change fonts, the same width number looks different. Use auto-fit (double-click the border) if you want the column to match its content visually, rather than trying to match a specific number.

Can I set different widths for the same column on different sheets?

Yes. Each sheet in a workbook has its own column widths. Resizing a column on one sheet does not affect the same column on another sheet. If you want all sheets to match, resize the column on one sheet, copy it, then select all other sheets and paste the formatting.

What is the difference between Column Width and Optimal Width?

Column Width lets you enter an exact number. Optimal Width (under Format > Column) automatically adjusts the column to fit its content, similar to double-clicking the border. Use Optimal Width when you want Excel to decide; use Column Width when you want to set a specific size.

How do I make all columns the same width?

Select all columns by clicking the box in the top-left corner (where row and column headers meet), then right-click any column header and select Column Width. Enter the width you want, and all columns change to that size at once.