The fastest way to change cell size
You can change a cell's width or height in Excel by dragging the border between column or row headers, or by right-clicking and entering exact measurements. The quickest method depends on whether you want one cell wider, an entire column resized, or all cells adjusted to fit their content automatically.
Excel gives you three main routes: drag the border (fastest for one adjustment), use the Format menu (best for precise numbers), or use auto-fit (best when you have text that's cut off). Each takes under a minute once you know where to look.
Key Takeaways
- Drag the border between column letters or row numbers to resize that column or row when ready without opening any menu.
- Right-click a column or row header and select "Column Width" or "Row Height" to enter an exact measurement in inches or centimeters.
- Double-click the border between column letters to auto-fit the width to whatever text is in that column.
- Select multiple columns or rows by clicking and dragging across their headers, then resize them all at once.
- The Format menu (under Home in the ribbon) holds options to auto-fit all columns or rows in your sheet at one time.
Dragging the border to resize a single column
Position your cursor on the border between two column letters at the top of the sheet — for example, between the A and B headers. Your cursor will change to a resize arrow (a double-headed line). Click and drag to the right to make column A wider, or to the left to make it narrower. Release the mouse when the column is the width you want.
This method works the same way for rows: position your cursor on the border between two row numbers on the left side, and drag up or down. You can resize as many columns or rows as you need this way, one at a time. There's no undo needed if you drag too far — just drag back.
Using exact measurements with the Format menu
If you need a column to be exactly 2 inches wide or a row to be exactly 0.5 inches tall, right-click the column or row header and select Column Width or Row Height. A small dialog box will open where you can type the exact number you want.
Excel measures column width in character units by default (roughly the width of one letter in the font you're using), but you can also work in inches or centimeters depending on your regional settings. If you're not sure what width you need, start with a guess, click OK, and adjust from there — you can right-click again and change it as many times as you want.
Auto-fit: letting Excel size cells to their content
Double-click the border between two column letters and Excel will automatically widen that column just enough to show all the text inside it without cutting anything off. This is the fastest way to fix a column where text is hidden because the column is too narrow.
For rows, double-click the border between two row numbers and the row will auto-fit to the height of the tallest content in that row. If you have a column with very long text and you want to auto-fit multiple columns at once, click the button in the top-left corner (where the row numbers and column letters meet) to select the entire sheet, then go to the Home tab in the ribbon, click Format, and select AutoFit Column Width.
Resizing multiple columns or rows at the same time
Click on a column letter, then hold Shift and click on another column letter to select a range of columns. All the columns between them will be highlighted. Now drag the border of any selected column header to resize all of them to the same width at once.
The same method works for rows: click a row number, hold Shift, click another row number, then drag the border between any two selected row numbers. You can also select non-adjacent columns or rows by clicking one, holding Ctrl, and clicking others — then resize them all together.
Setting a standard width for all columns
If you want every column in your sheet to be the same width, select all cells by clicking the button in the top-left corner (where the row and column headers meet), then right-click any column header and select Column Width. Enter the width you want, and every column will change to that size.
This is useful when you're starting a new sheet and want consistent spacing before you add data. You can always adjust individual columns later by dragging or using the Format menu — changing one column's width doesn't affect the others once you've set them.
Hiding and unhiding columns or rows
If you want a column or row out of sight temporarily without deleting it, right-click the header and select Hide. The column or row will disappear, but the data stays in your file. To bring it back, select the columns or rows on either side of the hidden one, right-click, and select Unhide.
Hiding is different from resizing — it removes the column or row from view entirely rather than making it narrower. Use hiding when you want to focus on other data or when you're preparing a sheet to share and want to keep some information out of sight without deleting it.
Frequently Asked Questions
Why does my text still look cut off after I auto-fit the column?
Auto-fit sizes the column to fit the text, but if the text is still cut off, the column may not have actually resized. Make sure you double-clicked the border between the column letters (not just clicked once), and that your cursor showed the resize arrow before you clicked.
Can I set a minimum or maximum width for a column?
Excel doesn't have a built-in minimum or maximum width setting. You can manually set a width using the Format menu, but if someone resizes the column later, it will change. If you need to protect column widths, you can lock the sheet format, though this requires password protection.
What's the difference between column width and row height?
Column width controls how far left-to-right a cell extends; row height controls how far up-and-down it extends. Both are measured differently — column width uses character units by default, while row height uses points (a printing measurement). You resize them the same way, but they affect different directions.
Does changing cell size affect the data inside?
No. Resizing a cell only changes how much space it takes up on the screen or page. The data inside stays exactly the same — you're just showing more or less of it at once. If text is hidden because a column is too narrow, it's still there; widening the column just makes it visible.
How do I resize cells in Excel on a phone or tablet?
On mobile versions of Excel, tap and hold the border between column letters or row numbers, then drag to resize. The process is the same as on a computer, but you use touch instead of a mouse. Some advanced options like exact measurements may not be available in the mobile app.