Page 245 - IT_Play_V1.0 Class9
P. 245
Step 2: Click on the Format menu from the Menu bar.
Step 3: Select the Cells option from the drop-down menu.
The Format Cells dialog box appears on the screen.
Step 4: Click on the Alignment Tab.
2
4
5
1 3
6
Step 5: Click on the Horizontal drop-down list. It provides various horizontal alignment options like:
Option Action Implemented (if selected)
The contents will be aligned according to the default settings of the type of data being
Default
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 not get
Filled
accommodated in the cell width will be hidden in the cell.
The contents will be displayed completely within the column width by increasing the
Justified
column width.
Distributed The alignment spaces text evenly, across the cell's width.
Choose any of the above options as per the requirement.
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.
Distributed The alignment spaces text evenly, across the cell's height.
Format Data in the Spreadsheet 243

