The fastest way to change column width

Double-click the line between two column letters at the top of your spreadsheet. Excel automatically fits the column to the width of whatever text or numbers are inside it. This works for one column at a time and takes about two seconds.

If you want to set an exact width instead, right-click the column letter, select Column Width, and type a number. The default width is about 8.43 characters wide. Most people never need to know this number — the double-click method handles 90 percent of real work.

To change multiple columns at once, click the first column letter, hold Shift, and click the last column letter you want to change. Then double-click any line between the selected columns, and they all resize together.

Key Takeaways

  • Double-clicking the line between column letters automatically fits the column to its content and is the fastest method for most work.
  • You can manually set an exact width by right-clicking a column letter and typing a number, though this is rarely necessary.
  • Selecting multiple columns at once with Shift+click lets you resize them all together in a single action.
  • The resize handle appears as a small line between column letters at the top — position your cursor there until it changes to a resize arrow.
  • If a column is too narrow and shows ### symbols instead of numbers, double-clicking the column border fixes it when ready.

Dragging the column border manually

Position your cursor on the line between two column letters at the top of the spreadsheet. Your cursor should change to a resize arrow (a double-headed line). Click and drag left to make the column narrower or right to make it wider.

This method gives you direct control but requires a steady hand. If you drag too far and can't see your data anymore, just drag back. There is no undo needed — you are moving the border, not deleting anything.

Manual dragging is useful when you want a column slightly wider than the automatic fit, or when you are setting up a spreadsheet that will be printed and you want specific column widths for page layout.

When columns show ### instead of numbers

The ### symbols mean the column is too narrow to display the number or date inside. This happens most often with dates, which take up more space than they look like they should.

Double-click the line between that column and the next one, and the column expands to fit. If you want to keep the column narrow for layout reasons, you can also format the data differently — for example, showing a date as 1/15 instead of January 15, 2024 — but resizing is usually faster.

Setting all columns to the same width

Click the button in the top-left corner of the spreadsheet (where the row numbers and column letters meet) to select every cell. Then right-click any column letter and choose Column Width. Type the width you want, and every column in the sheet becomes that width.

This is useful when you are building a spreadsheet from scratch and want a uniform look. It is less useful once you have data in place, because different columns usually need different widths.

If you want to reset all columns back to the default width, select all cells the same way, right-click, and choose Standard Width.

Hiding and unhiding columns

If you want a column to disappear from view without deleting it, right-click the column letter and select Hide. The column is still there — it just is not visible. This is different from making it narrower; the column takes up no space on screen.

To bring a hidden column back, select the columns on either side of it, right-click, and choose Unhide. For example, if column C is hidden, click column B, hold Shift, and click column D, then right-click and unhide.

Hiding is useful when you have data you need to keep in the spreadsheet but do not want to see every day — for example, cost information that you do not want to show in a printed report.

Column width in different versions of Excel

The double-click method and the right-click menu work the same way in Excel for Windows, Excel for Mac, and Excel Online. The steps are identical.

If you are using Google Sheets instead of Excel, the process is similar: right-click a column letter and choose Resize column, or double-click the border between columns. The menu names are slightly different, but the result is the same.

Mobile versions of Excel (on phone or tablet) do not let you resize columns with the same precision. If you need to adjust column width, open the spreadsheet on a computer instead.

Frequently Asked Questions

Why does my column keep going back to the old width?

You probably double-clicked instead of dragging, which triggered the auto-fit. If you want to keep a specific width, drag the border to where you want it and release. If it keeps resetting, check whether the spreadsheet is set to auto-fit columns — some templates do this automatically.

Can I make one column much wider than the others?

Yes. Drag that column's border as far as you want, or right-click and set an exact width. There is no limit. This is common when one column contains long text (like notes or descriptions) and the others contain short data (like dates or numbers).

What is the best column width for printing?

That depends on your paper size and font. The easiest approach: set up your spreadsheet the way you want it to look, then print preview to see how it fits on the page. Adjust column widths based on what you see in the preview, not on a number.

If I resize a column, does it change the data inside?

No. Resizing only changes how the data looks on screen or on paper. The actual numbers and text stay exactly the same. You can make a column as narrow or wide as you want without affecting the data.

How do I make all columns fit their content automatically?

Select all cells by clicking the button in the top-left corner, then double-click any line between column letters. Every column resizes to fit what is inside it. This is the fastest way to clean up a messy spreadsheet.