Format Menu
To format numbers.
Þ Select the required cells.
Þ Click on Format menu.
Þ Click on Cells command.
Þ Then a dialog box will appear.
Þ Click on Number tab.
Þ Choose Number category.
Þ Choose the required decimal places.
Þ If needed choose the Use thousand separators option. Click on Ok.
To change the number in currency format.
Þ Select the required cells.
Þ Click on Format menu.
Þ Click on Cells command.
Þ Then a dialog box will appear.
Þ Click on Number tab.
Þ Choose Currency tab.
Þ Choose the required decimal places.
Þ Choose any currency symbol.
Þ Click on OK.
To change the number in Percentage format.
Þ Select the required cells.
Þ Click on Format menu.
Þ Click on Cells command.
Þ Then a dialog box will appear.
Þ Click on Number tab.
Þ Click on Percentage tab.
Þ Choose the required decimal places.
Þ Click on OK.
To merge and center data
Þ First type the long text in a single cell.
Þ Select the required cell range.
Þ Click on Format menu.
Þ Click on Cells command.
Þ Then a dialog box will appear.
Þ Click on Alignment tab.
Þ Choose center from Horizontal and Vertical alignment.
Þ Click the three option of text control criteria. (Wrap text, shrink to fit, merge cells)
Þ Click on Ok.
[Put the Cursor at the required text and op pressing spacebar unit the text comes to the next line.]
To change the data orientation.
Þ Select the required cells.
Þ Click on Format menu.
Þ Click on Cells command.
Þ Then click on Alignment tab.
Þ Choose the required degrees.
Þ Click on Ok.
To format font.
Þ Select the required cells.
Þ Click on Format menu.
Þ Click on Cells command.
Þ Then click on Font command.
Þ Choose the required font, font style size, font color, underline style, effects.
Þ Click on Ok.
To apply borders & patterns.
Select the required cells.
Click on Format menu.
Click on Cells command.
Then click on Borders tab.
Choose any boarder style and Color.
Click on Outline and inside option.
Then click on Patterns tab.
Choose any color.
Click on OK
To format row
Select the required row.
Click on Format menu.
Click on Row command.
Then choose the required options, (Height, Auto fit, hide, unhide)
To format column.
Select the required columns.
Click on Format menu.
Click on column command.
Then choose the required option. (Width Auto fit selection, hide, un hided)
To Rename Sheet.
Select the required sheet name which you want to rename.
Click on Format menu.
Click on Sheet command.
Click on rename command.
Type the name for sheet.
Press Enter key.
To Hide/Unhide sheet.
Select the required sheet name.
Click on format menu.
Click on Sheet command.
Click on Hide/Unhide.
To change the background of sheet.
Click on format menu.
Click on Sheet command.
Then click on Background.
Now a dialog box will appear.
Choose any background file.
Click on Insert button
To delete background.
Click on Format menu.
Click on Sheet command.
Click on Delete background.
To Auto format cells.
Select the required cells.
Click on Format menu.
Click on Auto format command.
Then a dialog box will appear.
Choose any format style.
Click on Ok.
Using Conditional formatting command
Select the required cells.
Click on format menu.
Click on Conditional formatting command.
Then a dialog box will appear.
Choose any condition. (Cell value is less than, greater than, equals to etc.)
Type the value.
Click on Format menu.
Choose any Formatting.
Click on Ok.
If you want to add other conditions also click on add button and set the other condition.
Click on Ok.