No, Excel can’t resize just one cell. Changing a cell’s width changes its whole column, and changing its height changes its whole row. To make a single cell look bigger, merge it with the cells next to it, turn on Wrap Text, or use Center Across Selection for a heading that spans several columns.
This guide covers Excel for Microsoft 365, Excel 2024 and 2021 on Windows, with notes for Mac. It explains why cells share a size, the four workarounds and when to use each, and how to size whole columns and rows exactly. Steps follow Microsoft Support, checked in October 2026.
Why You Can’t Resize a Single Cell
Every cell sits in Excel’s grid, so its width comes from its column and its height from its row. Microsoft’s column width and row height guide puts it plainly: individual rows and columns can have only one setting. A column can’t be 25 wide in one row and 10 wide in another.
That’s why dragging a cell’s border always moves the whole column or row. The workarounds below change how a cell looks, not the grid itself.
Option 1: Merge the Cell With Its Neighbors
Merging combines several cells into one larger cell. It’s the closest thing to resizing a single cell, and it’s best for titles and labels.
- Select the cell and the empty cells next to it that you want it to cover. Result: the block is highlighted.
- On the Home tab, select Merge & Center. To merge without centering, select the arrow next to it and choose Merge Cells. Result: the cells become one large cell.
Microsoft warns that only the upper-left cell’s contents are kept; anything in the other cells is deleted. Merge empty cells, or move their contents first. To undo it, select the arrow next to Merge & Center and choose Unmerge Cells. See Microsoft’s merge and unmerge guide.
Merged cells can get in the way of sorting, filtering, and copying and pasting ranges, so avoid them inside data tables.
Option 2: Center Across Selection
Center Across Selection makes a heading look like it fills several cells without merging them, so sorting and selecting still work normally.
- Type the text in the leftmost cell. Result: the text sits in one cell.
- Select that cell and the cells to its right that the heading should span. Result: the range is highlighted.
- Press Ctrl + 1 to open Format Cells, and select the Alignment tab. Result: the alignment options appear.
- In the Horizontal list, choose Center Across Selection and select OK. Result: the text is centered across the range, and the other cells stay separate and empty.
Option 3: Wrap Text
If the cell holds long text, wrapping shows it on several lines instead of cutting it off.
- Select the cell. Result: it’s highlighted.
- On the Home tab, select Wrap Text. Result: the text wraps to fit the column width, and the row usually grows to show it.
- If some text is still hidden, select Home > Format > AutoFit Row Height. Result: the row grows to show every line.
Microsoft notes that wrapped text can stay hidden when the row has been set to a specific height, which is what AutoFit fixes. To break a line exactly where you want it, double-click the cell and press Alt + Enter (Control + Option + Return on a Mac). The row still grows for every cell in it.
Option 4: Shrink to Fit
Shrink to fit makes the text smaller instead of the cell bigger, so it fits without changing the column.
- Right-click the cell and select Format Cells. Result: the Format Cells box opens.
- On the Alignment tab, check Shrink to fit, then select OK. Result: the font shrinks until the content fits the column width.
Microsoft’s guide to fixing cut-off data notes the font keeps shrinking as you add more text, so this works best for short entries.
Resize a Whole Column or Row Instead
If you can live with the whole column or row changing, these are Microsoft’s methods:
- Drag: drag the boundary to the right of a column letter, or below a row number.
- AutoFit: double-click that boundary to fit the longest entry, or use Home > Format > AutoFit Column Width or AutoFit Row Height. See how to AutoFit columns and rows in Excel for shortcuts.
- Exact size: select Home > Format > Column Width or Row Height and type a number.
- Match another column: copy a cell in the column with the width you want, right-click a cell in the target column, and choose Paste Special > Keep Source Columns Widths.
Column widths are measured in characters of the default font, up to 255, and row heights in points, up to 409. Defaults are 8.43 and 15. Setting either to 0 hides the column or row. In a browser, the right-click menu does the same job, as shown in how to hide columns in Excel Online.
If a row disappears after you resize it, its height was probably set to zero, and you can bring it back by following these steps to unhide rows in Excel.
Which Option Should You Use?
- A title across the top of a report: Center Across Selection, or Merge & Center if the cells won’t be sorted.
- A note or description in a table: Wrap Text.
- A number or label that’s slightly too long: Shrink to fit, or widen the column.
- A form-style layout with boxes of different sizes: merge cells, or consider a Word table, where cells can be sized individually.
Frequently Asked Questions
Can I split a merged cell?
Yes. Select it and choose Merge & Center > Unmerge Cells. Microsoft notes you can’t split a cell that was never merged; to divide its contents instead, see how to split a cell in Excel.
Why did my whole row get taller when I wrapped one cell?
Row height applies to every cell in the row, so the row grows to fit the tallest wrapped cell.
Does Excel for Mac work differently?
No. The same rule applies, and Wrap Text, Shrink to fit and Center Across Selection are on the Home tab and the Alignment tab of Format Cells.
Can I resize cells individually in a Word table?
Yes. Word tables don’t share Excel’s grid limits, so you can select a single cell and drag its border. You can also merge cells in a Word table.
To check exact column widths and row heights in Excel, turn on the ruler in Page Layout view.
Want a picture to stay inside a cell after resizing it? Here is how to insert a picture into a cell in Excel.
Matthew Burleigh is the founder, head writer, and editor of Solve Your Tech, which he launched in 2012. He has written technology tutorials since 2008 and worked in IT since 2003, including small-business support, IT management, and consulting. He holds Bachelor’s and Master’s degrees in Computer Science from Arizona State University.
Matthew writes practical guides for Windows, iPhone and iPad, Microsoft Office, Outlook, Google apps, and Android. Solve Your Tech’s guides are tested on current devices or checked against official product documentation, with clear steps, sources, and update dates.
Read more about Matthew and how Solve Your Tech writes and updates its guides, or report a correction.