[Expand]General Information
[Expand]WinForms Controls
[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
[Collapse]Office File API
  Demo Application
  Redistribution and Deployment
 [Collapse]Spreadsheet Document API
   Product Structure
   Getting Started
  [Expand]Spreadsheet Document
   Supported Formats
  [Expand]Cell Basics
  [Expand]Formulas
   Defined Names
   Data Binding
  [Expand]Pivot Tables
  [Expand]Charts and Graphics
  [Expand]Mail Merge
  [Collapse]Examples
   [Expand]Files
   [Expand]Workbooks
   [Expand]Worksheets
   [Collapse]Rows and Columns
     How to: Access a Row or Column
     How to: Add a New Row or Column to a Worksheet
     How to: Delete a Row or Column from a Worksheet
     How to: Copy a Row or Column
     How to: Hide a Row or a Column
     How to: Specify Row Height or Column Width
   [Expand]Cells
   [Expand]Formulas
   [Expand]Import and Export Data
   [Expand]Data Binding
    Sorting
   [Expand]Mail Merge
    Search
   [Expand]Shapes
   [Expand]Charts
   [Expand]Sparklines
   [Expand]Formatting Cells
   [Expand]Conditional Formatting
   [Expand]Group Data
   [Expand]Filter Data
   [Expand]Tables
   [Expand]Pivot Tables
   [Expand]Printing
   [Expand]Pictures
   [Expand]Protection
 [Expand]Word Processing Document API
 [Expand]PDF Document API
 [Expand]Excel Export Library
 [Expand]Snap Report API
 [Expand]Zip Compression and Archive API
 [Expand]Barcode Generation API
 [Expand]Unit Conversion API
 [Expand]API Reference
[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)

How to: Specify Row Height or Column Width

Expanded Row

This example demonstrates how to control the row height on a worksheet.

  • Set Height for Individual Rows

    Use the row's Row.Height property or the Range.RowHeight property of the cell or cell range object to set the row height in the units of measure specified by Workbook.Unit.

    Note

    If the row height is set to 0, the row is hidden. You can also use the Row.Visible property to hide a row or display the hidden row again (see How to: Hide a Row or a Column).

  • AutoFit Row Height

    To automatically change the row height to fit the contents, use the row's Row.AutoFit method. To quickly autofit several rows on a worksheet, use the RowCollection.AutoFit method.

  • Match the Height of Two Rows

    To match one row height to another, make their Row.Height property values equal.

  • Set the Default Row Height

    To set the default height for worksheet rows, use the Worksheet.DefaultRowHeight property. This property does not affect rows with an explicitly specified height.

  • Set the Height for All Rows on a Worksheet

    To change the height of all rows on a worksheet, use the Range.RowHeight property of the Column object corresponding to any column on a worksheet. This sets the height of all rows to the same value, overriding all previously applied row height settings.

Expanded Column

This example demonstrates how to control the column width on a worksheet.

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