How to Unhide All Cells in Excel

What this does

Excel does not normally hide a single cell the way it hides a row or column. When people say hidden cells, the cause is usually a hidden row, a hidden column, a filter, grouped outline levels, white font, or a custom number format such as ;;; that makes values invisible. The right fix is to identify which of those mechanisms is active, then reverse it without changing the underlying values. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “unhide all cells in excel”. Start on a copy or a tiny sample, keep the affected cells visible, and compare the result with the tool above before you touch the real workbook. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. The point is a layout choice that keeps the sheet readable and sortable, but the practical win is that someone else can open the file and understand what happened without asking you.

A worked example

Cells B5:B8 look missing, but the row numbers jump from 4 to 9. Select rows 4 through 9, right-click the row headers and choose Unhide. If the row numbers are continuous but the values are still invisible, select the range, press Ctrl+1 and check Number ▸ Custom for ;;; or Font color that matches the fill. Unhiding cells safely matters when a workbook looks incomplete but still calculates with unseen values. The careful path restores visibility without overwriting data that was never actually gone. A practical tip: try it on a copy of the sheet or a handful of sample rows first and check the result before you apply it to the real data. That one habit catches almost every surprise while it is still cheap to reverse.

In Google Sheets

This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. If you take one thing from this page on “unhide all cells in excel”, make it the order of checks rather than the individual clicks: confirm what is selected, apply the step, and look at the result before moving on. That small routine is what keeps Excel work predictable when the same task comes back in a slightly different workbook.

Common mistakes

• Searching for an Unhide Cell command that Excel does not provide.
• Clearing contents when the data is only hidden by a filter or format.
• Unhiding rows while a filter is still active, so the records remain excluded.
• Missing a custom number format of ;;;, which hides displayed values while formulas still see them.

Frequently asked questions