How to Hide 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. Before you run it on a workbook other people depend on, try it on a copy or a few rows first. Undo only reaches back through the current session, so a quick trial run is the cheapest way to see exactly what will change before the file is saved and shared. For “hide cells in excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected cells change, and only then apply the same setup to the full sheet. 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. That is what makes a layout choice that keeps the sheet readable and sortable useful in real work: repeatable, auditable, and not dependent on memory or luck.

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. When the result is not what you expected, undo straight away rather than repairing it by hand — undo restores the sheet exactly, while manual fixes tend to leave small inconsistencies behind that surface later.

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. Keep this page bookmarked for the next time the same question comes up. Better still, repeat the steps once in your own workbook — doing it yourself is what turns a copied answer into something you remember. The short version of “hide cells in excel”: the answer is at the top of this page, and the sections above explain why each step matters, so a variation of the problem does not stump you. Try it once on a copy of a real file and the steps stick far better than re-reading them.

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