Page 275 - open office
P. 275
Sneak Peek
To Format Font in Microsoft Excel:
1. Click on the Home tab. Observe the Font group.
2. Select a font from the Font drop-down list.
3. Select a size for the text from the Font Size drop-down list.
4. Click on the Increase Font Size command to increase the size of the font by 1 point at
a time.
5. Click on the Decrease Font Size command to decrease the size of the font by 1 point at
a time.
6. Click on the Bold command to give a bold effect to the text.
7. Click on the Italic command to give italics effect to the text.
8. Click on the Underline command to mark single or double underline to the text.
9. Click on the Font Color drop-down list to select a colour for the text.
ALIGNMENT
The data in a cell gets aligned by default based on the type of data entered. (If the data is of text type, it will be
aligned towards left. If the data is of numeric type, it will be aligned towards right). To align the data of a cell:
Step 1: Select a cell or range of cells to be aligned and then click on the ‘Cells’ option from the ‘Format’
menu. The ‘Format Cells’ dialog box appears as:
Step 2: Click on the ‘Alignment’ Tab.
2
Vertical Text
Horizontal Alignment
Text
Alignment drop-down button.
drop-down
button.
Step 3: Click on the ‘Horizontal’ drop-down list. It provides various horizontal alignment options like:
Formatting Cells in Spreadsheet 275

