The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.

How to: Hide a Row or a Column

  • 2 min to read

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

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;
See Also