The three ways to resize a column

You can change column width in Excel by dragging the border between column headers, by double-clicking to auto-fit the content, or by typing a specific width in the Format menu. The drag method is fastest for one or two columns. Auto-fit works when you want the column to match whatever text or numbers are inside it. The Format menu gives you exact control if you need columns to be precisely the same width across a spreadsheet.

All three methods work the same way in Excel on Windows, Mac, and in the web version. The steps are nearly identical in Google Sheets and LibreOffice Calc, though the menu names differ slightly.

Key Takeaways

  • Drag the border between two column headers left or right to resize the column on the left side of that border.
  • Double-click the border between column headers to auto-fit the column width to whatever content is inside it.
  • Right-click a column header and select Format Cells to set an exact width in inches or centimeters.
  • Select multiple columns first if you want to resize several columns to the same width at once.

Dragging the column border to resize

Position your cursor on the line between two column headers — for example, between the A and B at the top of the spreadsheet. The cursor will change to a resize arrow (a double-headed arrow pointing left and right). Click and drag left to make the column narrower, or right to make it wider. Release the mouse when the column reaches the width you want.

This method is the fastest for adjusting one or two columns by eye. It does not require opening any menus. The downside is that you are estimating the width rather than setting it to an exact measurement, so if you need multiple columns to be precisely the same width, the Format menu method is more reliable.

Auto-fitting a column to its content

Double-click the border between two column headers. Excel will automatically resize the column on the left side of that border to fit the longest piece of text or the widest number currently in that column. If you add longer text to that column later, the width will not adjust — you would need to double-click again.

Auto-fit is useful when you have imported data and want to see all of it without scrolling horizontally. It is also the fastest way to clean up a spreadsheet where columns are too narrow to read. Select all columns first (click the box in the top-left corner where the row numbers and column letters meet) and then double-click any column border to auto-fit every column at once.

Setting an exact column width through the Format menu

Right-click on the column header you want to resize. A menu will appear. Click "Format Cells" (or "Column Width" if that option appears directly). A dialog box will open. Type the width you want in the text field. Excel measures column width in character units by default — a width of 20 means the column is wide enough to display about 20 characters. You can also change the unit to inches or centimeters if your spreadsheet needs to match a printed page size.

Click OK to explore the width. If you selected multiple columns before right-clicking, the same width will explore to all of them. This method is the most precise and is the only way to may support that columns in different parts of your spreadsheet are exactly the same width.

Resizing multiple columns at once

Click on the first column header you want to resize, then hold Ctrl (or Cmd on Mac) and click on each additional column header. All selected columns will highlight. Now you can drag the border of any selected column to resize all of them together, or right-click and use Format Cells to set them all to the same exact width.

This is faster than resizing columns one at a time, especially in a spreadsheet with many columns. If you want to resize every column in the sheet, click the select-all box (the corner where row numbers and column letters meet) before dragging or using Format Cells.

Column width in Google Sheets and LibreOffice Calc

Google Sheets uses the same drag-and-double-click methods as Excel. To set an exact width, right-click the column header and select "Resize column". A dialog box will appear where you can type the width in pixels. LibreOffice Calc also supports dragging and double-clicking, but the Format menu option is called "Optimal Width" instead of auto-fit, and it appears directly in the right-click menu rather than inside a Format Cells dialog.

If you switch between Excel and Google Sheets, the drag method will feel identical. The keyboard shortcuts and menu names differ, but the core behavior is the same. Column width in the web version of Excel works exactly like the desktop version.

Frequently Asked Questions

Why does my column width keep changing when I type?

You may have auto-fit enabled, or you may be in a view where columns adjust to fit the window width. Check the Format menu to see if there is an auto-fit option turned on. You can also manually set a fixed width through Format Cells to prevent the column from changing.

Can I set a minimum or maximum column width?

Excel does not have built-in minimum or maximum width settings. You can set a specific width through Format Cells, but the column will not automatically stay within a range. If you need columns to stay within certain bounds, you would need to manually check and adjust them.

What is the difference between column width and column size?

Column width and column size mean the same thing in Excel. Width is the more common term. Both refer to how much horizontal space the column takes up on the screen or on a printed page.

Does changing column width affect the data inside?

No. Changing column width only changes how the data is displayed, not the data itself. If a number or text is too wide to fit in the column, it will be hidden or overflow into the next column, but the actual content remains unchanged.