Formatting Worksheet:
Excel is a rich spreadsheet program, therefore it has a great potential of enhancing its worksheet. Appearance.
# Numeric Formatting: You can change the appearance of your numeric entries by using the numeric format functionality offered by excel. Excel offers you various formatting styles but you can also specify your own formatting styles if you want.
Using Shortcut Key:
1. Select the cells containing the data.
2. Click on the right mouse button.
3. Select the format cells option from the shortcut menu.
4. Select the type of number format you want to apply from the category list.
5. If you select date, time, fraction, special or custom category, then a sample format is shown to you in the sample area.
6. If you select number, currency, Accounting, percentage or scientific categories, then an option for setting the decimal places is available to you.
7. General and text entries do not offer any option.
8. Select the number format you want. When you make a choice , then a sample of the choice that you have made is shown in the sample area.
9. Select the OK option to allow excel to apply the numeric format.

Custom Format
There are times when you require special kind of formatting that excel is incapable of providing from its built-in number formatting styles, for example, having an international currency symbol or displaying the numbers in thousand without changing the actual cell values. For such special tasks, a custom number format is required.
How to create:
1. Select the cell option from the format menu.
2. Select the number tab from the format cells dialog box as shown below:


Format cells dialog box with the number tab activity

3. Select custom in the category list box.
4. Select the predefined format in the type list box.

How to delete this format:
1. Select the cell option from the format menu.
2. Select the custom category.
3. Select the custom format. You want to delete
4. Click on the delete button.

Date and Time Formats
Excel understands most dates and times entered in a worksheet
Cell and then it displays them in their respective format. You can change the date and time formats to specify your own. To apply a new format, follow the step:
1. Select the cell or cell range containing the data you want to format.
2. Select the cells option from the format menu.
3. Select date from the category list to display the list of date formats.
4. Select the format you want to use from the type list box.
5. Select the OK button.

Changing Column width and Row width
Changing Column width
Using Menu Bar:
1. Click on the heading of the column that has the width you want to change.
2. Select the column option from the format menu.
3. Select the width option from the column sub menu. A dialog box will appear on the screen.
4. Enter the column width in the column width text box.
5. Select the OK button.
Changing Row Height
Using the mouse:
1. Position the mouse pointer on the heading of the row (where the row numbers are specified) having the height you want to change.
2. Press the mouse button. (a double header arrow is displayed)
3. Drag the arrow down or up to increase or decrease the row height.
4. Release the mouse button when the appropriate height is selected.

Auto format
Excel offers you various predesigned formatting templates called auto formats
Steps are given below:
1. Select the cells range,
2. Select the auto format option from the format menu. A dialog box will appears on the screen as follows:


Auto format dialog box

3. Select an auto format style from the table format list.
4. Select OK option.

Aligning Data
1. Select the cells option from the format menu.
2. Select the alignment tab to display the format cells dialog box (the text alignment area shows horizontal and vertical list boxes, it will allow you to control the alignment vertical or horizontal)