Cramped cells hide your data. When text overflows, numbers display as ####, or wrapped content gets clipped, the spreadsheet looks broken even when the formulas behind it are perfect. Making cells bigger in Excel isn't a single click — it depends on whether you want wider columns, taller rows, or both, and whether the change should apply to one cell, a selection, or the whole sheet.

The good news: every fix takes seconds once you know the shortcut. The bad news: Excel won't let you resize a single cell without affecting its row or column, and the menus hide some of the fastest moves behind keyboard combos you'd never discover on your own.

This guide walks through every method that actually works: dragging borders by hand, the AutoFit double-click shortcut, the precise Row Height and Column Width dialogs, and the trick for resizing every cell on a sheet at once. We'll also cover wrap text — the technique most users actually want when they ask how to make a cell bigger.

Why You Can't Resize a Single Cell in Excel

Before you start clicking, understand the rule that catches everyone: Excel sizes entire rows and columns, not individual cells. If you widen cell B5, every cell in column B gets wider with it. If you raise the height of cell B5, every cell in row 5 rises. There's no setting buried in the menu that changes this — it's how the grid is built.

The workaround for true single-cell resizing is merging cells or using text wrapping to expand vertical space within one cell's row. For most users, though, the answer is simpler: resize the column or row, and the rest of the sheet will look fine because empty cells take no visual space.

This matters because most users come to this problem thinking they need a special trick to make one cell bigger. There isn't one. Once you accept the row-and-column model, every sizing problem in Excel becomes a question of which row or column to resize, and whether to do it by drag, by AutoFit, by an exact number, or across the whole sheet.

Method 1: Drag the Column or Row Border

The quickest way to enlarge a cell is to drag its column or row border. Move your cursor to the line between two column letters (A | B) at the top of the sheet. The cursor changes to a double-headed arrow. Click and drag right to widen the column on the left. The same works on row numbers — hover between two numbers in the row header on the left edge, and drag down to make the row taller.

This is fine for one column or one row. It gets tedious when you need to resize many at once. To resize a group, select all the columns first (click the first column letter, then Shift+click the last), then drag any one border — every selected column resizes to the same width. The same trick works for rows.

Method 2: AutoFit by Double-Click

AutoFit is even faster when you want Excel to pick the size for you based on content. Double-click the right border of a column letter — the column snaps to fit the widest entry in that column. Double-click the bottom border of a row number and the row snaps to its tallest entry.

You can also reach AutoFit from the ribbon. Go to the Home tab, click Format in the Cells group, and pick AutoFit Column Width or AutoFit Row Height. Select the columns or rows you want fitted before clicking. If you want every column on the sheet auto-sized, press Ctrl + A to select all, then double-click any column divider.

AutoFit has one quirk worth knowing. If a cell uses wrap text, AutoFit on the row will expand the row vertically to show every wrapped line. The two features interact, and that's usually what users actually want when they say a cell is too small.

Method 4: Make Every Cell on the Sheet Bigger

To resize every cell on a worksheet to the same dimensions, click the small grey triangle in the corner where the row numbers meet the column letters. This selects the entire sheet. Now drag any column divider — every column on the sheet resizes to match. Drag any row divider — every row matches. For exact values, use Row Height and Column Width from the right-click menu while the whole sheet is selected.

This is the right approach when you're building a grid-style sheet (think a calendar, a checklist, or a seating chart) where every cell should be a square or rectangle of identical size. Set column width to 4 and row height to 30 and you'll get a tight grid of equal cells across the sheet. Adjust the numbers until the shape looks right.

The keyboard equivalent of clicking the corner triangle is Ctrl + A, which selects the data range, or Ctrl + A twice in a row, which selects the entire worksheet. From there, the right-click menu on any header offers the same Row Height and Column Width options. This is faster than reaching for the mouse when you're already typing.

The Wrap Text Plus Row AutoFit Combo

If you want one cell to look bigger because its text is getting clipped, the answer is often wrap text, not resizing the row. Select the cell, go to the Home tab, and click Wrap Text. The cell stays the same column width but the text inside breaks into multiple lines, and the row height grows automatically to show every line.

Wrap text plays nicely with AutoFit on rows. After wrapping, double-click the row border in the header — the row snaps to exactly the height needed for the wrapped content. Our word wrap in Excel guide covers every wrap scenario, including how to force a line break inside a cell with Alt+Enter and what to do when wrap text refuses to expand the row at all.

One trap to avoid: if wrap text appears active but the row stays short and shows clipped text, the row height is locked at a manual value. Right-click the row, choose Row Height, and clear the field — or set it back to 15 and let AutoFit take over. Manual row heights win over automatic sizing every time, so you have to remove the override before AutoFit will work.

For long paragraphs that need to fit inside one cell, the combination is: set column width manually (try 40 characters), turn on Wrap Text, then AutoFit row height. The result is a tall, readable cell that holds a full paragraph without changing the rest of the row layout dramatically. Pair this with vertical alignment set to Top (Home tab > Alignment group) so the text starts at the top of the cell rather than centered vertically.

Keyboard Shortcuts to Resize Cells

Power users skip the mouse. The shortcut to open Row Height is Alt + H, O, H on Windows — Alt activates the ribbon, H jumps to Home, O opens Format, H picks Height. Column Width is Alt + H, O, W. Type the value, press Enter, and you're done. On Mac, there's no direct equivalent, but right-click on the row or column header gives you Row Height and Column Width straight away.

For AutoFit by keyboard, Alt + H, O, I auto-fits the selected column width. Alt + H, O, A auto-fits the row height. Memorize these two and you can resize hundreds of columns in seconds. Combine with Ctrl + Space to select an entire column or Shift + Space to select an entire row before triggering the fit.

To select the entire sheet by keyboard, press Ctrl + A twice — once selects the data range, twice selects everything. Then the Alt + H, O, I combo AutoFits every column on the sheet. This is the fastest way to clean up a messy import where every column has random widths.

Common Problems and Fixes When Resizing

If AutoFit isn't working, the most likely cause is a merged cell in that column or row. Excel can't AutoFit columns that contain merged cells — unmerge them first, AutoFit, then re-merge if you need to. The second common issue is a hidden row or column that AutoFit refuses to expand. Use right-click > Unhide on the surrounding selection to make them visible again before resizing.

Cells showing #### mean the column is too narrow to display a number. AutoFit fixes this instantly — double-click the column border. Cells showing partial text are usually a wrap-text problem, not a width problem. Turn on wrap text, AutoFit the row, and you'll see the full entry.

Another frequent gotcha: row height stuck after editing a wrapped cell. Excel auto-expands the row the first time wrap text fits new content, but later edits often leave the row at the old height. Double-click the row border to re-fit, or clear the manual row height from the right-click dialog.

If you need to lock cells after sizing so users can't drag them back, do that last — once locked, resizing is blocked for protected cells. Unprotect the sheet, resize, then re-apply protection.

Designing a Grid Sheet with Equal Cells

If you're building a planner, a seating chart, or a checklist where every cell should be a perfect square, the recipe is short. Click the corner triangle to select the whole sheet. Right-click any column letter, choose Column Width, and enter a value — try 4 for tight squares or 8 for wider ones. Right-click any row number, choose Row Height, and enter a matching value.

Because column width is measured in characters and row height in points, the two numbers won't be identical to produce a visual square. For Calibri 11pt, a column width of 2.86 roughly matches a row height of 20 points. Experiment with one cell, then apply the values sheet-wide. Once the grid is square, use cell borders to make the layout pop — Home tab, borders dropdown, choose All Borders.

To restrict the grid to a smaller block rather than the whole sheet, select only the rows and columns you want to size, then apply Row Height and Column Width to that selection. The unselected portion of the sheet keeps its original dimensions. This is useful when you want a square grid block at the top of a sheet but normal data tables below it.

Resizing Cells Inside an Excel Table

When data is formatted as an Excel Table (Ctrl+T), the sizing rules don't change but a few behaviors do. AutoFit still works, and dragging column borders still resizes the column. The table doesn't lock its width. What does change is that adding a new row to the table inherits the row height of the row above it — if you've manually set a tall row, new entries match it automatically.

One trap: if you set a column width manually inside a table and then sort or filter, Excel sometimes resets the width to fit the visible content. To prevent this, right-click the column letter and use Column Width to lock in a specific number rather than relying on drag. The exact value persists through sort and filter operations.

Our how to create a table in Excel guide covers the rest of the table-specific behaviors, including how the header row interacts with row height and what happens when you convert a table back to a normal range.

Putting It All Together

Most sizing problems in Excel have a one-click answer: double-click the column or row divider to AutoFit. When AutoFit gives uneven results, set exact widths in characters and row heights in points using the right-click dialog. For grid-style sheets, select the whole worksheet using the corner triangle and resize once. For text that needs to expand vertically inside one cell, turn on wrap text and AutoFit the row.

The methods stack. You can AutoFit a column first, then drag it wider for breathing room. You can set a row to a fixed height for a header band, then let the rest of the rows auto-size based on content. You can wrap text inside a cell and then AutoFit the row to show every wrapped line.

If you're working with imported data — a CSV pasted into Excel, a query result from a database, or content pulled from a web page — start with select-all plus AutoFit Column Width to clean up the mess. It takes one second and makes every column readable. Follow up with wrap text on any column that holds long entries, then AutoFit Row Height to expand the rows. The result is a sheet that's instantly easier to read.

With these four moves — drag, AutoFit, exact size, and select-all — every cell-sizing problem in Excel has a fast answer. Practice the double-click AutoFit on a sheet today and you'll never go back to dragging borders one at a time. The same shortcuts work in every recent version of Excel — Excel 2016, 2019, 2021, and Microsoft 365 all support every method covered here, on both Windows and Mac platforms.