How to: Align Cell Content
- 2 minutes to read
To align data contained within a cell, use the properties of the Alignment object.
To change the alignment attributes for a range of cells, call the CellRange.BeginUpdateFormatting method for this range, use the Alignment property of the returned Formatting object to access and modify the Alignment object, and call the CellRange.EndUpdateFormatting method to finalize the modification.
The Alignment object provides the following properties to change cell alignment settings:
- Alignment.Horizontal, Alignment.Vertical - set the horizontal and vertical position of cell content.
- Alignment.Indent - sets the indentation of cell content.
- Alignment.WrapText - sets whether or not text should wrap in a cell.
- Alignment.RotationAngle - sets the rotation angle of cell content.
To share alignment settings with multiple cells in a single step, create or modify the style with the Formatting.Alignment property specified as required, and assign this style to CellRange.Style for the desired cells.
Cell cellA1 = worksheet.Cells["A1"]; cellA1.Value = "Right and top"; cellA1.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Right; cellA1.Alignment.Vertical = SpreadsheetVerticalAlignment.Top; Cell cellA2 = worksheet.Cells["A2"]; cellA2.Value = "Center"; cellA2.Alignment.Horizontal = SpreadsheetHorizontalAlignment.Center; cellA2.Alignment.Vertical = SpreadsheetVerticalAlignment.Center; Cell cellA3 = worksheet.Cells["A3"]; cellA3.Value = "Left and bottom, indent"; cellA3.Alignment.Indent = 2; Cell cellA4 = worksheet.Cells["A4"]; cellA4.Value = "The Alignment.WrapText property is applied to wrap the text within a cell"; cellA4.Alignment.WrapText = true; Cell cellA5 = worksheet.Cells["A5"]; cellA5.Value = "Rotation by 45 degrees"; cellA5.Alignment.RotationAngle = 45;
The image below shows how text can be aligned within worksheet cells.