To center data in a cell, click the center button on the ribbon.
Data in a cell can be aligned either horizontally or vertically .
For the horizontal alignments, we have
- against the left border,
- against the right border, and
- in the centre.
For the vertical alignments, we have
- against the top border
- , against the bottom border,
- and in the middle.
To center data, the following steps should be followed.
1.Click the cell where you want to center the data.
2. Click "Home," then the small arrow in the bottom corner of the "Alignment" area of the ribbon.
3.Click the drop-down box next to "Horizontal" and choose "Center." Do also for the "Vertical.