![excel 多行 取消隐藏](https://i-blog.csdnimg.cn/blog_migrate/e62607e3324dd313584113d0bd8e722c.png)
excel 多行 取消隐藏
![00_lead_image_hide_unhide 00_lead_image_hide_unhide](https://i-blog.csdnimg.cn/blog_migrate/48489c8fc421d391f435d947a601304e.png)
There may be times you want to remove a row or column from a spreadsheet, but you don’t want to permanently delete it from the worksheet file. Excel has a feature that allows you to temporarily hide a row or column from view.
有时您可能想从电子表格中删除行或列,但不想将其从工作表文件中永久删除。 Excel具有一项功能,可让您从视图中临时隐藏行或列。
NOTE: Cells in hidden rows and columns can still be included in calculations in other visible cells as well as perform calculations themselves.
注意:隐藏行和列中的单元格仍可以包含在其他可见单元格的计算中,也可以自己执行计算。
To hide one or more rows, select the row(s) to be hidden.
要隐藏一个或多个行,请选择要隐藏的行。
![01_selecting_rows_to_hide 01_selecting_rows_to_hide](https://i-blog.csdnimg.cn/blog_migrate/025cd023f44ac4eb764a19ac00c839c8.png)
Right-click on one of the row headers selected and select Hide from the popup menu.
右键单击所选的行标题之一,然后从弹出菜单中选择“隐藏”。
![02_selecting_hide_for_rows 02_selecting_hide_for_rows](https://i-blog.csdnimg.cn/blog_migrate/d21d11c0182249e826c6185ec42b5bb0.png)
The selected rows are hidden, including the row headings. Notice that rows three and four in the following image are hidden as well. A thick line also initially separates the rows where there are hidden rows. When you perform other actions on the spreadsheet, this thick line will disappear. However, you can tell where the rows are hidden by the missing row headers.
所选行被隐藏,包括行标题。 请注意,下图中的第三行和第四行也被隐藏。 最初,粗线还会将隐藏行所在的行分开。 当您在电子表格上执行其他操作时,该粗线将消失。 但是,您可以知道丢失的行标题在哪里隐藏了行。
![03_rows_hidden 03_rows_hidden](https://i-blog.csdnimg.cn/blog_migrate/ebf84b7802cb66fafb382b2ba9dc3ba9.png)
To unhide a row, you must first select the rows both above and below the hidden row(s). Then, right-click on the selected row headers and select Unhide from the popup menu.
要取消隐藏行,必须首先选择隐藏行上方和下方的行。 然后,右键单击选定的行标题,然后从弹出菜单中选择“取消隐藏”。
![04_selecting_unhide_for_rows 04_selecting_unhide_for_rows](https://i-blog.csdnimg.cn/blog_migrate/88b210a16a867efacf6e022ff61f06cf.png)
The hidden rows display again and are highlighted along with the surrounding rows.
隐藏的行再次显示,并与周围的行一起突出显示。
![05_rows_unhidden 05_rows_unhidden](https://i-blog.csdnimg.cn/blog_migrate/a68588a7c8da844a9373c92c683a6b57.png)
You can also easily hide one or more columns. Select the column(s) you want to hide, right-click on one of the column headers, and select Hide from the popup menu.
您还可以轻松隐藏一列或多列。 选择要隐藏的列,右键单击列标题之一,然后从弹出菜单中选择“隐藏”。
![06_selecting_hide_for_column 06_selecting_hide_for_column](https://i-blog.csdnimg.cn/blog_migrate/ff49e5137ad26d683f5559790dcef17f.png)
The selected columns are hidden along with the column headers and a thicker line displays where the columns were.
所选的列和列标题一起隐藏,并且较粗的行显示列所在的位置。
![07_column_hidden 07_column_hidden](https://i-blog.csdnimg.cn/blog_migrate/c65308e797e863f4559ab9aae0855ec6.png)
To unhide the hidden columns, just like with hidden rows, select the columns both to the right and left of the hidden columns, right-click on one of the column headers, and select Unhide from the popup menu.
要取消隐藏隐藏的列,就像隐藏行一样,请选择隐藏列左右两侧的列,右键单击列标题之一,然后从弹出菜单中选择“取消隐藏”。
![08_selecting_unhide_for_columns 08_selecting_unhide_for_columns](https://i-blog.csdnimg.cn/blog_migrate/e2017b4aabc04d58f014ad091f9b077b.png)
The hidden column(s) display again highlighted along with the columns on either side.
隐藏的列将再次显示,并且两侧的列也将突出显示。
![09_column_unhidden 09_column_unhidden](https://i-blog.csdnimg.cn/blog_migrate/923fb87ffab05e82c6b21adcd25909fa.png)
This feature is handy if you want to print out only relevant rows and columns of your spreadsheet, but don’t want to delete the temporarily unneeded information.
如果您只想打印电子表格的相关行和列,但又不想删除临时不需要的信息,则此功能非常方便。
翻译自: https://www.howtogeek.com/166652/how-to-hide-and-unhide-rows-and-columns-in-excel-2013/
excel 多行 取消隐藏