Find hidden cells on a worksheet

When you want to unhide cells in hidden rows or columns in a worksheet, it can be hard to locate them. By finding and selecting all visible cells in the worksheet, you can more easily detect the hidden rows and columns.

  1. Click the worksheet that contains the hidden rows and columns that you want to locate.

  2. On the Home tab, in the Editing group, click Find & Select.

    Excel  Ribbon Image

  3. Click Go To Special.

  4. Under Select, click Visible cells only, and then click OK.

    All visible cells are selected and the borders of rows and columns that are adjacent to hidden rows and columns are marked with a white border.

Note: Clicking anywhere on the worksheet cancels the selection of the visible cells. If the hidden cells that you want to unhide are outside the visible worksheet area, use the scroll bars to move through the document until the hidden rows and columns that contain those cells are visible.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.