Rows and Columns

Aug 14, 2019
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.

At the left and at the top of a worksheet there are row and column headings (rows are numbered - “1”, “2”, “3”,…, “1048576”, and columns are lettered - “A”, “B”, “C”,…,”XFD”). An end-user can select an entire row or column by clicking the corresponding row or column heading.

All worksheet rows and columns are stored in the RowCollection and ColumnCollection objects, which you can access from 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.