Skip to main content

How to: Specify Row Height or Column Width

  • 5 minutes to read

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

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

    Use the SpreadsheetCellOptions.AutoFitMergedCellRowHeight property to enable the AutoFit functionality for rows that have cells merged across and containing wrapped text.

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

View Example

// Set the height of the 3rd row to 50 points
workbook.Unit = DevExpress.Office.DocumentUnit.Point;
worksheet.Rows[2].Height = 50;

// Set the height of the row that contains the "C5" cell to 2 inches.
workbook.Unit = DevExpress.Office.DocumentUnit.Inch;
worksheet.Cells["C5"].RowHeight = 2;

// Set the height of the 7th row to the height of the 3rd row.
worksheet.Rows["7"].Height = worksheet.Rows["3"].Height;

// Set the default row height to 30 points.
workbook.Unit = DevExpress.Office.DocumentUnit.Point;
worksheet.DefaultRowHeight = 30;

Column

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

View Example

// Set the "B" column width to 30 characters of the default font that is specified by the Normal style.
worksheet.Columns["B"].WidthInCharacters = 30;

// Set the "C" column width to 15 millimeters.
workbook.Unit = DevExpress.Office.DocumentUnit.Millimeter;
worksheet.Columns["C"].Width = 15;

// Set the width of the column that contains the "E15" cell to 100 points.
workbook.Unit = DevExpress.Office.DocumentUnit.Point;
worksheet.Cells["E15"].ColumnWidth = 100;

// Set the width of all columns that contain the "F4:H7" cell range (the "F", "G" and "H" columns) to 70 points.
worksheet.Range["F4:H7"].ColumnWidth = 70;

// Set the "J" column width to the "B" column width value.
worksheet.Columns["J"].Width = worksheet.Columns["B"].Width;

// Copy the "C" column width value and assign it to the "K" column width.
worksheet.Columns["K"].CopyFrom(worksheet.Columns["C"], PasteSpecial.ColumnWidths);

// Set the default column width to 40 pixels.
worksheet.DefaultColumnWidthInPixels = 40;