如何在 Excel 中取消隐藏所有行

2.1 Hiding Rows Using Ribbon Button

It is also possible to hide rows in Excel using the Ribbon button located at the top of the Excel sheet.

Step 1: Click the Format button in the Cells group under the Home tab.

Step 2: Choose Hide Rows from the Hide & Unhide menu under Visibility.

Excel Hide & Unhide

As another option, you can select Home > Format > Row Height and enter 0 in the field for Row Height. In either case, the selected rows will immediately be hidden from view.

2.2 Hiding Rows Using the Right-Click Menu

If you don't want to search for the Hide command on the ribbon, you can access it from the context menu by right-clicking on the column or row header and choosing the Hide option.

Hide in the context menu

2.3 Hiding Rows Using Keyboard Shortcut

A keyboard shortcut can also be used to hide rows in an Excel document by pressing Ctrl + 9 to hide all rows.

3.1 Unhiding Rows Using Ribbon Button

Unhide rows by using the Ribbon button available at the top of the Excel sheet.

Step 1: Click the Format button in the Cells group under the Home tab.

Step 2: Choose Unhide Rows from the Hide & Unhide menu under Visibility.

Unhiding rows using the ribbon

3.2 Unhiding Rows Using the Right-Click Menu

Unhide rows using an option from the context menu by right-clicking the chosen rows and choosing "Unhide".

Unhide rows

3.3 Unhiding Using a Keyboard Shortcut

Keyboard shortcuts can also be used to unhide all hidden rows in an Excel document by pressing Ctrl + Shift + 9, which helps to make hidden rows visible again in the spreadsheet.

4.1 IronXL Features

• It is possible to edit, read, and load data from XLS, XLSX, CSV, and TSV.
• Data export and storage in the formats CSV, TSV, JSON, XLS, and XLSX.
• Ranges are simple to use. Syntax for WorkSheet["A1:B10"]. Ranges can logically be combined.
• Columns, rows, and ranges can all be sorted.
• Cell styles, such as font, size, border, alignment, lock, freeze cells, hide/unhide rows, and number formats.

4.2 Hiding Rows in IronXL

IronXL can be used to hide row numbers in Excel with just a few lines of code. The below code is an example to hide a row in Excel.

using IronXL;

// Load an existing Excel workbook
WorkBook wb = WorkBook.LoadExcel("sample1.xlsx");

// Select the worksheet
WorkSheet ws = wb.GetWorkSheet("Sheet1");

// Hide the second row
ws.GetRow(1).Hidden = true;

// Save changes to the Excel file
wb.SaveAs("sample1.xlsx");

using IronXL;

// Load an existing Excel workbook
WorkBook wb = WorkBook.LoadExcel("sample1.xlsx");

// Select the worksheet
WorkSheet ws = wb.GetWorkSheet("Sheet1");

// Hide the second row
ws.GetRow(1).Hidden = true;

// Save changes to the Excel file
wb.SaveAs("sample1.xlsx");

Imports IronXL

' Load an existing Excel workbook
Private wb As WorkBook = WorkBook.LoadExcel("sample1.xlsx")

' Select the worksheet
Private ws As WorkSheet = wb.GetWorkSheet("Sheet1")

' Hide the second row
ws.GetRow(1).Hidden = True

' Save changes to the Excel file
wb.SaveAs("sample1.xlsx")

The example above loads an existing Excel document using the WorkBook.LoadExcel method by providing the path and file name. Once the Excel document is loaded in the WorkBook object, a specific Excel worksheet can be specified using the WorkBook method GetWorkSheet and pass the sheet name as a parameter. This creates a WorkSheet object, which provides functionality for the entire worksheet.

After getting the WorkSheet object, it is possible to select a row using the method GetRow by passing the row index as a parameter. This allows us to use the boolean value from the Hidden property and set it to true, which can hide and unhide rows in an Excel document. The above code is an example that hides the second row of the Excel document.

4.3 Unhiding Rows in IronXL

The following code can unhide multiple rows in Excel:

using IronXL;

// Load an existing Excel workbook
WorkBook wb = WorkBook.LoadExcel("sample1.xlsx");

// Select the worksheet
WorkSheet ws = wb.GetWorkSheet("Sheet1");

// Unhide the second row
ws.GetRow(1).Hidden = false;

// Save changes to the Excel file
wb.SaveAs("sample1.xlsx");

using IronXL;

// Load an existing Excel workbook
WorkBook wb = WorkBook.LoadExcel("sample1.xlsx");

// Select the worksheet
WorkSheet ws = wb.GetWorkSheet("Sheet1");

// Unhide the second row
ws.GetRow(1).Hidden = false;

// Save changes to the Excel file
wb.SaveAs("sample1.xlsx");

Imports IronXL

' Load an existing Excel workbook
Private wb As WorkBook = WorkBook.LoadExcel("sample1.xlsx")

' Select the worksheet
Private ws As WorkSheet = wb.GetWorkSheet("Sheet1")

' Unhide the second row
ws.GetRow(1).Hidden = False

' Save changes to the Excel file
wb.SaveAs("sample1.xlsx")

To unhide specific rows, follow the aforementioned steps and modify the instructions by selecting the row through the method GetRow, either by passing the row index as a parameter or by specifying the row. Then set the boolean value of Hidden to false.