Merge and center:

Merge and center merges multiple cells into one and aligns data in center. It is useful to display titles and headings with appropriate alignment.

The following procedure is use to merge and center cell

• Type the data in different cells.
• Select the columns to apply merge and center.
• Click on Merge and center icon. The merge and center will apply on select columns.

Rotating Text:

This feature is use to change the direction of the text. the following procedure is use to rotate the text:

• Select the cell or range of cell to rotate.
• Select Format >cells.
• Click Alignment Tab. Under Orientation, Red Diamond will be at 0 degrees.
• Click and drag red Diamond to +45 degrees position and click OK.

Wrapping Text in a Cell:

The wrap Text option is use the text appears in single cell but the height of that cell is to be increase to accommodate all of words.

The following procedure is use to wrap text using menu.

• Select the cells to apply Wrap Text.
• Select Format >Cells…..The Format Cells dialog box appears.
• Select the Alignment Tab.
• Select Wrap text under Text Control and click OK.

Unwrapping Text using Menu;

The following procedure is use to unwrap text using menu.

• Select the cell with wrapped text.
• Select Format > Cells….. The Format Cells dialog box appears.
• Deselect Wrap text under text control.

Formatting with the format painter:

The format painter is used to apply the formatting of one text to another. Not only does this feature help speed up formatting operations. It ensures consistency among different areas in your sheet

Formatting single cell:

The following procedure is use to format single cell using format painter.

• Select the cell that contains the formatting to copy.
• Click Format painter on standard toolbar. The pointer changes shape to include a paintbrush next to it.
• Click the cell where the formatting is to be apply.

Formatting Multiple cells

The following procedure Is use to format multiple cells using format painter.

• Select the cell that contains the formatting to copy.
• Click Format Painter on Standard toolbar. The pointer changes shape to include a paintbrush next to it.
• Click the cell where the formatting is to be applied. Select a range of cells by clicking and dragging.
• Repeat step 3 for additional cells.
• Turn off Format painter by clicking it again.

Number Format:

The style in which numeric data is displayed in cells is called number formatting. A number format changes the appearance of a number but does not change the value. Suppose a cell contains 1.24535 and a format with two decimal place is applied. Excel will round the number and display it as 1.23 However, Excel uses the number 1.2352 in calculation.

The formatting toolbar’s’ contains three buttons for numeric formats.

• Currency
• percentage
• Comma

The formatting of a cell or selected range can be changed quickly by using following icons on formatting toolbar.

Formatting using Format cells Dialog Box:

The following procedure is use to display Format cells dialog box.

• Select Format >Cells…..The Format cells Dialog box is displayed.

Applying Currency Style:

Select the cells as follows:

Click on Currency Style from symbol list. The data in cells will appear as follows

Applying Percent Style:

The percent Style button adds a percent sign next to data.The following procedure is used to apply percent style.

Select the cells.

Click on percentage from category list. The data in cells will appear as follows:

Applying Comma Style

The following procedure is use to apply comma style

• Select the cells to apply comma style.
• Click on Comma Style button. The data in Cells will appear as follows

Increase Decimal:

The increase Decimal button increases the number of decimal places displayed with value. The following procedure is use to insert decimal:

• Select the cells for applying decimal format.
• Press CTRL +1.
• Click on Number from category list.
• Select number decimal points required in Decimal places box. The cells will appear as follows: