There may be times when you want to hide information in certain cells or hide entire rows or columns in an Excel worksheet. Maybe you have some extra data you reference in other cells that does not need to be visible.

有時您可能想在某些單元格中隱藏信息或在Excel工作表中隱藏整行或整列。 也許您在其他單元格中引用了一些多余的數據，這些數據不需要是可見的。

We will show you how to hide cells and rows and columns in your worksheets and then show them again.

我們將向您展示如何隱藏工作表中的單元格以及行和列，然后再次顯示它們。

隱藏細胞 (Hide Cells)

You can’t hide a cell in the sense that it completely disappears until you unhide it. With what would that cell be replaced? Excel can only blank out a cell so that nothing displays in the cell. Select individual cells or multiple cells using the “Shift” and “Ctrl” keys, just like you would when selecting multiple files in Windows Explorer. Right-click on any of the selected cells and select “Format Cells” from the popup menu.

在取消隱藏之前，您無法隱藏完全消失的意義的單元。 該單元將被替換為什么？ Excel只能清空一個單元格，以便該單元格中不顯示任何內容。 就像在Windows資源管理器中選擇多個文件一樣，使用“ Shift”和“ Ctrl”鍵選擇單個單元格或多個單元格。 右鍵單擊任何選定的單元格，然后從彈出菜單中選擇“格式化單元格”。

The “Format Cells” dialog box displays. Make sure the “Number” tab is active and select “Custom” in the “Category” list. In the “Type” edit box, enter three semicolons (;) without the parentheses and click “OK”.

顯示“格式化單元格”對話框。 確保“數字”選項卡處于活動狀態，然后在“類別”列表中選擇“自定義”。 在“類型”編輯框中，輸入不帶括號的三個分號(;)，然后單擊“確定”。

NOTE: You might want to note what the “Type” was for each of the selected cells is before you change it so you can change the type of the cells back to what it was to show the content again.

注意：您可能要在更改之前注意每個選定單元格的“類型”是什么，以便可以將單元格的類型更改回原來的狀態以再次顯示內容。

The data in the selected cells is now hidden, but the value or the formula is still in the cell and displays in the “Formula Bar”.

現在已隱藏選定單元格中的數據，但是值或公式仍在單元格中并顯示在“公式欄”中。

To unhide the content in the cells, follow the same steps listed above, but choose the original number category and type for the cells rather than “Custom” and the three semicolons.

要取消隱藏單元格中的內容，請按照上面列出的相同步驟進行操作，但要為單元格選擇原始數字類別和類型，而不要選擇“自定義”和三個分號。

NOTE: If you type anything into cells in which you hid the content, it will automatically be hidden after you press “Enter”. Also, the original value in the hidden cell will be replaced with the new value or formula that you type into the cell.

注意：如果您在隱藏內容的單元格中鍵入任何內容，則在按“ Enter”后它將自動隱藏。 此外，隱藏單元格中的原始值將替換為您在單元格中鍵入的新值或公式。

隱藏行和列 (Hide Rows and Columns)

If you have a large worksheet, you might want to hide some rows and columns for data you don’t currently need to view. To hide an entire row, right-click on the row number and select “Hide”.

如果您的工作表很大，則可能需要隱藏一些行和列以存儲當前不需要查看的數據。 要隱藏整個行，請右鍵單擊行號，然后選擇“隱藏”。

NOTE: To hide multiple rows, select the rows first by clicking and dragging over the range of rows you want to hide, and then right-click on the selected rows and select “Hide”. You can select non-sequential rows by pressing “Ctrl” as you click on the row numbers for the rows you want to select.

注意：要隱藏多行，請首先通過單擊并在要隱藏的行的范圍內拖動來選擇行，然后右鍵單擊選定的行并選擇“隱藏”。 您可以通過在要選擇的行的行號上單擊時按“ Ctrl”來選擇非連續行。

The hidden row numbers are skipped in the row number column and a double line displays in place of the hidden rows.

在行號列中將跳過隱藏的行號，并在隱藏行的位置顯示雙線。

Hiding columns is a very similar process to hiding rows. Right-click on the column you want to hide, or select multiple column letters first and then right-click on the selected columns. Select “Hide” from the popup menu.

隱藏列與隱藏行非常相似。 右鍵單擊要隱藏的列，或者先選擇多個列字母，然后右鍵單擊所選的列。 從彈出菜單中選擇“隱藏”。

The hidden column letters are skipped in the row number column and a double line displays in place of the hidden rows.

在行號列中將跳過隱藏的列字母，并在隱藏行的位置顯示雙線。

To unhide a row or multiple rows, select the row before the hidden row(s) and the row after the hidden row(s) and right-click on the selection and select “Unhide” from the popup menu.

要取消隱藏一行或多行，請選擇隱藏行之前的行和隱藏行之后的行，然后右鍵單擊所選內容，然后從彈出菜單中選擇“取消隱藏”。

To unhide a column or multiple columns, select the two columns surrounding the hidden column(s), right-click on the selection, and select “Unhide” from the popup menu.

要取消隱藏一列或多列，請選擇隱藏列周圍的兩列，右鍵單擊所選內容，然后從彈出菜單中選擇“取消隱藏”。

If you have a large spreadsheet and you don’t want to hide any cells, rows, or columns, you can freeze rows and columns so any headings you set up don’t scroll when you scroll through your data.

如果您有一個很大的電子表格，并且不想隱藏任何單元格，行或列，則可以凍結行和列，以便在滾動瀏覽數據時不會滾動設置的任何標題。

翻譯自: https://www.howtogeek.com/218582/how-to-hide-cells-rows-and-columns-in-excel/