Page 189 - CA 165 ver 1.0 Class 9
P. 189
To align the data of cell:
Step 1: Select a cell or range of cells to be aligned and click on the ‘Cells’ option from the ‘Format’
menu. ‘Format Cells’ dialog box appears as:
2
Step 2: Click on the ‘Alignment’ Tab.
Step 3: Click on the ‘Horizontal’ drop down list. Different type of horizontal alignments are given
below in table.
Option Action Implemented (if selected)
The contents will be aligned according to the default settings of the type
Default
of data 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
Filled which does not get accommodated in the cell width will be hidden in the
sheet.
The contents will be displayed completely within the column width by
Justified
increasing the column width.
Choose any of the above options, as per the requirement.
Working with Spreadsheet 187

