- GcExcel .NET Overview
- Key Features
- Getting Started
-
Features
-
Worksheet
- Work with Worksheets
-
Range Operations
- Access a Range
- Get Intersection, Union and Offset Range
- Access Areas in a Range
- Get Special Cell Ranges
- Access Cells, Rows and Columns in a Range
- Get Address of Cell Range
- Cut or Copy Cell Ranges
- Cut or Copy Shape, Slicer, Chart and Picture
- Paste or Ignore Data in Hidden Range
- Find and Replace Data
- Get Row and Column Count
-
Hide Rows and Columns
- Insert And Delete Cell Ranges
- Insert and Delete Rows and Columns
- Merge Cells
- Set Values to a Range
- Set Custom Objects to a Range
- Set Row Height and Column Width
- Auto Fit Row Height and Column Width
- Work with Used Range
- Measure Digital Width
- Set Default Values for Cell Range
- Ignore ErrorsIn Cell Range
- Set Cell Background Image for Cell Range
- Freeze Panes in a Worksheet
- Freeze Trailing Panes in a Worksheet
- Customize Worksheets
- Worksheet Views
- Cell Types
- Quote Prefix
- Tags
- Rich Text
- Workbook
- Comments
- Hyperlinks
- Sort
- Filter
- Group
- Conditional Formatting
- Data Validations
- Data Binding
- Digital Signatures
- Formulas
- Custom Functions
- Shapes and Pictures
- Document Properties
- Styles
- Form Controls
- Barcodes
- Theme
- Chart
- Table
- Pivot Table
- Pivot Chart
- Sparkline
- Slicer
- Logging
- Defined Names
-
Worksheet
- Templates
- File Operations
- Release Notes
Hide Rows and Columns
You can choose whether to hide or show rows and columns in a worksheet by using the Hidden property of the IRange interface.
Refer to the following example code in order to hide specific rows and columns in a worksheet.
worksheet.Range["E1"].Value = 1;
//Hide row 2:6 using the Hidden property
worksheet.Range["2:6"].Hidden = true;
//Hide column A:D using the Hidden property
worksheet.Range["A:D"].Hidden = true;Note: The range must either be entire rows or entire columns. The Hidden property doesn't work on a range of cells.