How To Expand All Cells In Excel | One-Click Fit & Unhide

“Expand all cells” in Excel usually means making every column and row fit their contents, or unhiding hidden data — the fastest method is selecting the whole sheet and using the AutoFit commands in the Home tab.

One wrong tap can leave your spreadsheet looking like a grid of ##### errors or missing rows. The remedy isn’t adjusting cells one by one — it’s a few keystrokes or menu clicks that expand everything at once. Here’s the step-by-step for each version of “expand,” from resizing columns to revealing hidden content.

What “Expand All Cells” Actually Means

Excel doesn’t let you stretch a single cell the way you would a text box. Instead, you adjust the grid itself — column widths and row heights. When someone says “expand all cells,” they usually want one of four things: AutoFit every column, AutoFit every row, unhide hidden rows or columns, or expand grouped outline sections. Each has its own quick method.

AutoFit All Columns and Rows in One Go

The fastest way to resize every column and row to match their content is to select the entire worksheet first, then apply AutoFit. This eliminates the ##### errors that appear when a numeric value or date is wider than its column.

Select the whole sheet by clicking the triangle at the intersection of the row numbers and column letters (or press Ctrl + A on Windows or Cmd + A on Mac). Then go to Home > Cells > Format > AutoFit Column Width. The same menu has AutoFit Row Height for rows.

For keyboard users, select all cells, then press Alt + H + O + I for columns and Alt + H + O + A for rows. After you see all content fit, the success cue is that no truncated text or ##### markers remain in the visible area.

How To Expand Hidden Rows and Columns

AutoFit won’t unhide anything. If a column or row is hidden — whether by manual hiding, a filter, or an outline group — you need a dedicated command.

Select the entire sheet as above, then right-click any column header (the letter label at the top) and choose Unhide. Do the same for row headers. To clear an outline group, go to Data > Ungroup > Clear Outline. Watch for this limitation: clearing an outline removes the grouping structure permanently; you cannot undo that removal. If a filter is hiding rows, go to Data > Clear to show everything again.

The success cue for unhiding: the column letters or row numbers become continuous with no gaps, and the missing data appears.

How To Expand All Collapsed Outline Sections

If your spreadsheet uses Excel’s Group and Outline feature (often created by Data > Subtotal or manually), clicking the plus signs (+) at the top or left edge expands a single group. To expand everything at once, go to Data > Ungroup > Clear Outline. After that, every previously collapsed row or column returns to view, though the grouping buttons disappear.

If you need the groups to remain functional, manually click each plus sign or use the numbered outline buttons (1, 2, 3) in the top-left corner of the sheet — clicking the highest number shows all levels.

One common gate: if rows seem missing after you’ve AutoFit everything, check whether a filter is active. Filter arrows on column headers mean some data is suppressed. The success cue for clearing an outline or filter: the row numbers are contiguous, all data is visible, and the outline buttons vanish (if you chose Clear Outline).

Expand Cells Without Affecting the Rest of the Sheet

Sometimes you only need to widen a single column to match its longest entry. A double-click on the right boundary of that column heading instantly AutoFits just that column. Similarly, double-click the bottom boundary of a row number to AutoFit one row. This is the quickest way to fix a specific ##### cell without changing the whole sheet.

When a cell’s content is longer than the screen width can comfortably display, you can merge adjacent empty cells using Home > Merge & Center. Note that AutoFit won’t create extra space for a single merged cell; it only adjusts the grid’s rows and columns around it. If merging isn’t suitable, try wrapping text (Home > Wrap Text) to keep the value readable within the existing width.

Expand All Cells Checklist

Use this order when your spreadsheet looks incomplete, truncated, or cramped:

1. Select the whole sheet (Ctrl + A or Cmd + A).
2. Check for filter arrows on column headers; if present, go to Data > Clear.
3. Check for missing row numbers or column letters; right-click any header and choose Unhide.
4. Check for plus signs above columns or beside rows; use Data > Ungroup > Clear Outline to show everything.
5. Apply Home > Cells > Format > AutoFit Column Width and then AutoFit Row Height.
6. Verify that no ##### values remain and all text is fully readable.

This sequence handles the four meanings of “expand all cells” in one pass, and it works the same way on Windows and Mac versions of Excel. If a single cell still looks cramped after fitting the whole sheet, consider wrapping its text or merging it with an adjacent empty cell.