excel 多行 取消隐藏_如何在Excel 2013中隐藏和取消隐藏行和列

excel 多行 取消隐藏

excel 多行 取消隐藏

00_lead_image_hide_unhide

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

Right-click on one of the row headers selected and select Hide from the popup menu.

右键单击所选的行标题之一,然后从弹出菜单中选择“隐藏”。

02_selecting_hide_for_rows

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

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

The hidden rows display again and are highlighted along with the surrounding rows.

隐藏的行再次显示,并与周围的行一起突出显示。

05_rows_unhidden

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

The selected columns are hidden along with the column headers and a thicker line displays where the columns were.

所选的列和列标题一起隐藏,并且较粗的行显示列所在的位置。

07_column_hidden

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

The hidden column(s) display again highlighted along with the columns on either side.

隐藏的列将再次显示,并且两侧的列也将突出显示。

09_column_unhidden

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 多行 取消隐藏

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
©️2022 CSDN 皮肤主题:编程工作室 设计师:CSDN官方博客 返回首页
评论
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、C币套餐、付费专栏及课程。

余额充值