How to: Show or Hide a Row or Column

This example demonstrates how to control the visibility of rows and columns in a worksheet using the Row.Visible and Column.Visible properties.

Note

You can also hide a row or column in a worksheet by setting the row height (Row.Height) or column width (Column.Width, Column.WidthInCharacters or Column.WidthInPixels) to 0, respectively (see the How to: Specify Row Height or Column Width document).

View Example

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;

The image below shows how to hide and unhide worksheet rows and columns via the SpreadsheetControl user interface.

SpreadsheetControl_RowsColumns_HideUnhide

See Also