Page 276 - open office
P. 276
Option Action Implemented (if selected)
The contents will be aligned according to the default settings of the type of data
Default
being entered.
Left The contents will be aligned towards the left side of the cell.
Right The contents will be aligned towards the right side of the cell.
Center The contents will be aligned towards the center of the cell.
The contents will be displayed within the column width only. The data that does
Filled
not get accommodated in the cell width will be hidden in the cell.
The contents will be displayed completely within the column width by increasing
ustified
the column width.
Choose any of the above options as per the requirement.
Sneak Peek
The Alignment of cells in Microsoft Excel:
1. Click on the Home tab. Observe the Alignment group.
2. Click on the Top Align command to align the text to the top edge of the cell.
3. Click on the Middle Align command to align the text to the vertical center of the cell.
4. Click on the Bottom Align command to align the text to the bottom edge of the cell.
5. Click on the Align Text Left command to align the text to the left edge of the cell.
6. Click on the Center command to align the text to the horizontal center of the cell.
7. Click on the Align Text Right command to align the text to the right edge of the cell.
8. Click on Decrease Indent command to decrease the gap between the text and the
left edge of the cell.
9. Click on the Increase Indent command to increase the gap between the text and the left
edge of the cell.
Similarly, click on the ‘Vertical’ drop-down list. It opens with various vertical alignment options:
Option Action Implemented (if selected)
Bottom The contents will be aligned towards the bottom side of the row.
Top The contents will be aligned towards the upper side of the row.
Middle The contents of the cell will be aligned in vertically centered position.
The contents will be aligned according to the default settings of the type of data
Default
being entered.
276 Touchpad Information Technology-IX

