It's easy to hide rows and columns in an Excel worksheet, and you or your boss or co-worker might do that when setting up an Excel file. Occasionally though, you might have trouble unhiding Excel row and columns.

隐藏Excel工作表中的行和列很容易，并且您或您的老板或同事在设置Excel文件时可能会这样做。 但是，有时您可能无法隐藏Excel行和列。

隐藏行和列 (Hiding Rows and Columns)

Usually it's easy to unhide rows or columns that have been temporarily hidden.

通常，取消隐藏已临时隐藏的行或列很容易。

Just select the columns (or rows) on either side of the hidden ones, then right-click, and click Unhide.

只需选择隐藏列两侧的列(或行)，然后单击鼠标右键，然后单击“取消隐藏”。

疑难解答 (Trouble Unhiding)

However, if you hide Row 1, or Column A, in an Excel worksheet, you might have trouble unhiding them.

但是，如果在Excel工作表中隐藏第1行或第A列，则可能无法隐藏它们。

Here are the steps to see the hidden rows or columns again:

以下是再次查看隐藏的行或列的步骤：

• For rows, press on the first visible row button, then drag up, onto the Select All button. The little popup shows the number of rows you've selected.
  对于行，请按第一个可见的行按钮，然后向上拖动到“全选”按钮上。 小弹出窗口会显示您选择的行数。
• Then, right-click the first visible row button, and click Unhide.
  然后，右键单击第一个可见行按钮，然后单击“取消隐藏”。

NOTE: For hidden columns, select the first visible column, and drag to the left.

注意 ：对于隐藏的列，请选择第一个可见的列，然后向左拖动。

查看取消隐藏行的步骤 (See the Steps to Unhide Rows)

This animated gif shows the steps for selecting the hidden rows, and unhiding them

这个动画的gif显示了选择隐藏的行并将其取消隐藏的步骤

另一种解决方案 (Another Solution)

If that selection trick didn't work, the rows might be hidden because some of the worksheet has been locked, with the Freeze Panes command.

如果该选择技巧无效，则可能会隐藏行，因为某些工作表已使用“冻结窗格”命令锁定。

To see if freezing is the problem of hidden rows or columns, follow these steps:

要查看冻结是否是隐藏的行或列的问题，请按照下列步骤操作：

• Select any cell on the the worksheet
  选择工作表上的任何单元格
• On the Excel Ribbon, click the View tab
  在Excel功能区上，单击“视图”选项卡
• If there is an Unfreeze Pane command in the drop down list, click that, to unfreeze the locked sections
  如果下拉列表中有“解冻窗格”命令，请单击该命令以解冻锁定的部分

The "hidden" rows or columns might reappear after that, when you scroll to the top or left of the worksheet.

之后，当您滚动到工作表的顶部或左侧时，“隐藏的”行或列可能会重新出现。

视频：无法隐藏Excel行 (Video: Trouble Unhiding Excel Rows)

This short video shows you a quick way to see those hidden rows and columns again, in your Excel worksheet.

这段简短的视频向您展示了一种快速的方法，可以在Excel工作表中再次查看这些隐藏的行和列。

演示地址