[Expand]General Information
[Collapse]WinForms Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications, and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Property Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Collapse]Spreadsheet
   [Expand]Product Information
    Product Structure
    Getting Started
   [Collapse]Spreadsheet Document
     Workbook
     Worksheets
     Cells and Cell Ranges
     Rows and Columns
     Comments
     Measure Units
    Supported Formats
   [Expand]Cell Basics
   [Expand]Formulas
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
    Data Grouping
   [Expand]Pivot Tables
   [Expand]Charts and Graphics
    Printing
    Events
   [Expand]Mail Merge
    Protection
    Find and Replace
   [Expand]Visual Elements
    Services
   [Expand]Keyboard Shortcuts
   [Expand]Examples
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
  [Expand]Sunburst Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Rows and Columns

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. 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 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

Range.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

Row.Visible

Column.Visible

Control row or column visibility in a worksheet.

How to: Show or Hide a Row or Column

Worksheet.FreezeRows, Worksheet.FreezeColumns

Worksheet.FreezePanes, Worksheet.UnfreezePanes

Freeze and unfreeze rows and columns at the top and on the left side of the worksheet.

How to: Freeze and Unfreeze Rows and Columns

Row.Height, Range.RowHeight, Worksheet.DefaultRowHeight

Column.Width, Column.WidthInCharacters, Column.WidthInPixels

Range.ColumnWidth, Range.ColumnWidthInCharacters

Worksheet.DefaultColumnWidth, Worksheet.DefaultColumnWidthInCharacters, Worksheet.DefaultColumnWidthInPixels

Row.AutoFit, Column.AutoFit

Specify row height and column width in a worksheet.

How to: Specify Row Height or Column Width

Expanded See Also

Is this topic helpful?​​​​​​​