×
英语
很抱歉。本文没有你的语言版本。

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.

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×