excel 多行 取消隐藏
 

  
 
 
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.
 
 
 要隐藏一个或多个行，请选择要隐藏的行。
 
 

  
 
 
Right-click on one of the row headers selected and select Hide from the popup menu.
 
 
 右键单击所选的行标题之一，然后从弹出菜单中选择“隐藏”。
 
 

  
 
 
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.
 
 
 所选行被隐藏，包括行标题。 请注意，下图中的第三行和第四行也被隐藏。 最初，粗线还会将隐藏行所在的行分开。 当您在电子表格上执行其他操作时，该粗线将消失。 但是，您可以知道丢失的行标题在哪里隐藏了行。
 
 

  
 
 
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.
 
 
 要取消隐藏行，必须首先选择隐藏行上方和下方的行。 然后，右键单击选定的行标题，然后从弹出菜单中选择“取消隐藏”。
 
 

  
 
 
The hidden rows display again and are highlighted along with the surrounding rows.
 
 
 隐藏的行再次显示，并与周围的行一起突出显示。
 
 

  
 
 
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.
 
 
 您还可以轻松隐藏一列或多列。 选择要隐藏的列，右键单击列标题之一，然后从弹出菜单中选择“隐藏”。
 
 

  
 
 
The selected columns are hidden along with the column headers and a thicker line displays where the columns were.
 
 
 所选的列和列标题一起隐藏，并且较粗的行显示列所在的位置。
 
 

  
 
 
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.
 
 
 要取消隐藏隐藏的列，就像隐藏行一样，请选择隐藏列左右两侧的列，右键单击列标题之一，然后从弹出菜单中选择“取消隐藏”。
 
 

  
 
 
The hidden column(s) display again highlighted along with the columns on either side.
 
 
 隐藏的列将再次显示，并且两侧的列也将突出显示。
 
 

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

1.选中需要隐藏的行列，右键点击隐藏
 
2.选中隐藏列（行）左右两列（上下两行）右键单击取消隐藏

要隐藏tableWidget指定行和列，代码如下
 
// 隐藏列
ui->tableWidget->setColumnHidden(0, true); // 隐藏第一列
ui->tableWidget->setColumnHidden(2, true); // 隐藏第三列
// 隐藏行
ui->tableWidget->setRowHidden(0, true); // 隐藏第一行
ui->tableWidget->setRowHidden(2, true); // 隐藏第三行

// 显示列
ui->tableWidget->setColumnHidden(0, false); // 显示第一列
ui->tableWidget->setColumnHidden(2, false); // 显示第三列
// 显示行
ui->tableWidget->setRowHidden(0, false); // 显示第一行
ui->tableWidget->setRowHidden(2, false); // 显示第三行

Sub VBA小程序_遍历所有工作表_取消隐藏所有行_列()
    Dim shp As Shape, sht As Worksheet
    Rem On Error Resume Next '忽略报错，防止有#N/A
    
    Rem 遍历所有工作表，取消隐藏行 + 列
    For Each sht In Worksheets
        sht.Activate
        sht.Cells.EntireColumn.Hidden = False   '取消隐藏所有行
        sht.Cells.EntireRow.Hidden = False   '取消隐藏所有列
    Next
    
    Rem On Error GoTo 0 '恢复报错
End Sub