How to: Hide a Row or a Column

Sep 19, 2023
2 minutes to read

This example demonstrates how to hide rows and columns in a worksheet using different properties and methods:

Use the Row.Visible and Column.Visible properties
Call the RowCollection.Hide or the ColumnCollection.Hide methods.
Set the row height (Row.Height) or column width (Column.Width, Column.WidthInCharacters or Column.WidthInPixels) to 0 (zero) (see also the How to: Specify Row Height or Column Width document).

RowAndColumnActions.cs
RowAndColumnActions.vb

csharp

Worksheet worksheet = workbook.Worksheets[0];

// Hide the 8th row of the worksheet.
worksheet.Rows[7].Visible = false;            
// Hide the 4th column of the worksheet.
worksheet.Columns[3].Visible = false;

// Hide columns from 5 to 7.
worksheet.Columns.Hide(5, 7);
// Hide rows from 6 to 8.
worksheet.Rows.Hide(5, 7);

// Hide the 10th row of the worksheet.
worksheet.Rows[9].Height = 0;
// Hide the 10th column of the worksheet.
worksheet.Columns[9].Width = 0;

Dim worksheet As Worksheet = workbook.Worksheets(0)

' Hide the 8th row of the worksheet.
worksheet.Rows(7).Visible = False
' Hide the 4th column of the worksheet.
worksheet.Columns(3).Visible = False

' Hide columns from 5 to 7.
worksheet.Columns.Hide(5, 7)
' Hide rows from 6 to 8.
worksheet.Rows.Hide(5, 7)

' Hide the 10th row of the worksheet.
worksheet.Rows(9).Height = 0
' Hide the 10th column of the worksheet.
worksheet.Columns(9).Width = 0