Rows and Columns

  • 2 minutes to read

Worksheet cells are organized into 1,048,576 rows and 16,384 columns. The number of rows and columns is permanently fixed.

Rows and columns have headings in a worksheet (rows are numbered - "1", "2", "3",..., "1048576", and columns are lettered - "A", "B", "C",...,"XFD"). You can hide or show these row and column headings via the WorksheetView.ShowHeadings property.

Row_Column_Indexes

All worksheet rows and columns are stored in the RowCollection and ColumnCollection objects that you can access via the Worksheet.Rows and Worksheet.Columns properties. The Row and Column objects specify an individual row or column, respectively. Use the properties and methods of these objects to manage worksheet rows and columns.

Property/Method

Description

Example

RowCollection.Item

ColumnCollection.Item

Provide access to an individual row or column by its heading (Row.Heading or Column.Heading) or index (Row.Index or Column.Index ).

How to: Access a Row or Column

RowCollection.Insert, Row.Insert

ColumnCollection.Insert, Column.Insert

Insert new rows and columns into a worksheet.

How to: Add a New Row or Column to a Worksheet

CellRange.CopyFrom

Copies a row or column.

How to: Copy a Row or Column

RowCollection.Remove, Row.Delete

ColumnCollection.Remove, Column.Delete

Remove specified rows and columns from a worksheet.

How to: Delete a Row or Column from a Worksheet

RowCollection.Group, RowCollection.UnGroup

ColumnCollection.Group, ColumnCollection.UnGroup

Row.GroupLevel, Column.GroupLevel

Group and ungroup rows and columns in a worksheet.

Grouping

Row.Visible

Column.Visible

Control row or column visibility in a worksheet.

How to: Hide a Row or a Column

Row.Height, CellRange.RowHeight, Worksheet.DefaultRowHeight

Column.Width, Column.WidthInCharacters, Column.WidthInPixels

CellRange.ColumnWidth, CellRange.ColumnWidthInCharacters

Worksheet.DefaultColumnWidth, Worksheet.DefaultColumnWidthInCharacters, Worksheet.DefaultColumnWidthInPixels

Specify row height and column width in a worksheet.

How to: Specify Row Height or Column Width

See Also