The three ways to resize cells in Excel
You can change how wide a column is or how tall a row is in three ways: by dragging the border between column or row headers with your mouse, by double-clicking that border to fit the content automatically, or by right-clicking and typing a specific measurement. The method you choose depends on whether you want to eyeball it, let Excel decide, or set an exact size.
Most people start with dragging because it is the fastest for one-off adjustments. Double-clicking works well when you have text that got cut off and you want it all visible at once. Right-clicking and entering a number is the move when you need consistency across multiple columns or rows, or when you are setting up a template that other people will use.
Key Takeaways
- Drag the border between column letters (or row numbers) to resize that column or row by eye.
- Double-click the border between column letters to automatically fit the width to whatever text is inside.
- Right-click a column or row header and select "Column Width" or "Row Height" to enter an exact measurement in inches or centimeters.
- You can select multiple columns or rows at once and resize them all together using any of these three methods.
Dragging a column border to change width
Position your cursor on the line between two column letters at the top of the spreadsheet — for example, between the B and C headers. Your cursor will change to a resize cursor (a double-headed arrow). Click and drag to the right to make the left column wider, or to the left to make it narrower. Release when the column is the width you want.
The same method works for rows: position your cursor on the line between two row numbers on the left side, and drag up or down. This is the fastest way to adjust a single column or row when you can see roughly how wide or tall you need it to be.
Double-clicking to auto-fit column width or row height
If you have text in a cell that is cut off or hidden, double-click the border between the column headers (or row numbers) and Excel will automatically expand that column or row to fit all the content inside. This saves you from having to guess the right width.
For columns, double-click the border to the right of the column header you want to resize. For rows, double-click the border below the row number. Excel measures the tallest or widest content in that column or row and adjusts the size to fit it. If you add more text later, you can double-click again to re-fit.
Right-clicking to set an exact column width or row height
Right-click on a column header (the letter at the top) and select "Column Width" from the menu. A small box will appear where you can type a number. The default unit is inches, but you can type a number followed by "cm" for centimeters if you prefer. Click OK and the column will be exactly that width.
For rows, right-click on a row number and select "Row Height". Type the height you want in inches or centimeters and click OK. This method is useful when you need all your columns to be the same width, or when you are building a form or template that needs to look consistent.
Resizing multiple columns or rows at once
Click on the first column header you want to resize, then hold Shift and click on the last column header in the range. All columns between them will be selected (they will appear highlighted). Now drag the border of any selected column header, and all selected columns will resize together. The same works for rows: select the first row, hold Shift, click the last row, then drag the border of any selected row number.
You can also select non-consecutive columns or rows by clicking the first one, then holding Ctrl (or Cmd on Mac) and clicking each additional column or row header you want to include. When you resize any of them, all selected columns or rows will change to the same size.
Why your text is cut off and how to fix it
When text in a cell looks like it ends with three dots or just disappears, it usually means the column is too narrow to show all the words. The text is still there — it is just hidden. Widen the column by dragging the border to the right, or double-click the border to auto-fit. If the text is in a cell to the right of an empty cell, it may appear to overflow into that empty space; widening the column to the left will show you where the text actually ends.
Row height rarely needs adjustment unless you are working with wrapped text (text that breaks into multiple lines within a single cell) or you want extra space between rows for readability. If you have wrapped text and the row is too short, the text will be cut off at the bottom. Double-click the row border or drag it down to see all the wrapped text.
Frequently Asked Questions
Can I set a minimum or maximum column width?
Excel does not have a built-in minimum or maximum width setting. You can set a specific width by right-clicking and typing a number, but there is no way to prevent someone from dragging it smaller or larger. If you need to protect a layout, you can lock the sheet and hide the resize handles, but that requires password protection.
What is the difference between column width and character width?
When you right-click and enter a column width, Excel measures it in inches by default. If you type a number without a unit, it assumes inches. You can also type "cm" after the number for centimeters. Character width is an older measurement that Excel used to use; you will not see it in modern versions unless you are working with very old files.
Why does my column width change when I paste data?
Excel does not automatically resize columns when you paste. If a column appears to have changed width, it is usually because the pasted text is longer than what was there before, and you are seeing the text overflow into adjacent cells. The column width itself has not changed. Drag the border or double-click to fit if you want to see all the text within the column boundaries.
Can I make all columns the same width at once?
Yes. Click the select-all button (the box in the top-left corner where the column headers and row numbers meet) to select the entire sheet. Then right-click any column header and choose "Column Width", type the width you want, and click OK. Every column will be set to that width. You can do the same for rows by selecting all and right-clicking a row number.