Cell alignment is a key feature when giving your table a more organized and consistent look. Data in a cell can be positioned left, right or center and even top, bottom or middle within the cell to enhance the visual presentation. Column headers can be rotated which optimizes the column width and accommodates more columns in the report. This section reviews the following:
Follow below steps to apply alignment:
Select the cell/row /column that you want to align.
In the Home tab, under Alignment select the alignment option you want to apply.
Choose from various alignment options
To align horizontally, users can choose from Align Left, Centre or Align Right.
Horizontal alignment option
Similarly, choose any of the three options below for vertical alignment (Enabled only when Row height is 20 or above).
Vertical alignment option
Follow the below steps to apply Header Orientation.
Select the cell containing the header using Alt+Click and select the drop-down available under Column header Orientation as below
Column Header Orientation
Click on the options from above to have Horizontal orientation, Clockwise orientation, Vertical orientation or Counterclockwise orientation respectively.
Column header set to Counterclockwise Orientation
Follow the below steps to apply Indentation
Select the Row(s) you need to apply indentation.
In the Home tab, under alignment click on Increase Indent to apply indentation space. It allows you to apply up to 5 indentation spaces.
Increase Indentation
Similarly to remove/reduce the applied indentation space, click on Decrease Indent.
Decrease Indentation
Follow below steps to apply row height
In the Home tab, under Alignment select the Row height.
Row height selection
Row height can be managed from this selection box.