Write A Short Note On Format Cell

Microsoft Office Excel 2007 lets you change many of the ways that it displays data in a cell. For example, you can specify the number of digits to the right of a decimal point. You can also add a pattern and a border to the cell. You can access and modify most of these settings in the Format Cells dialog box. To access the Format Cells dialog box, click the Format CellsDialog Box Launcher in the Font group on the Home tab.

For a complete list of formatting options, right-click on the highlighted cells and choose Format Cells from the shortcut menu or select Format > Cells from the menu bar.

Number tab

The data type can be selected from the options on this tab. Select

the range you would like to format and click on one of the

Category number as shown in Figure 7.2 to apply that style to your

numbers. Select General if the cell contains text and number and

it does not have any specific number format. If you select

Number Category you can represent numbers as integers,

decimals with number of decimal as option etc. For example, if

you want to restrict the number of decimals to 2, choose Number

Category and then decimal places as 2. You may try the other

options in your computer.

Alignment tab

These options allow you to change the position and alignment of

the data with the cell. The Format Cells dialog box offers you more

options than the alignment buttons on the Formatting toolbar.

For example, you can change the orientation of the text.

Font tab

All of the font attributes are displayed in this tab including font

face, size, style, and effects. Using Formatting toolbar you can

bold, italicize, and underline your cell entries. For even more

formatting options you can use the Format Cells dialog box.

Border and Pattern tabs

You can use the Formatting toolbar for adding borders, cell

shading, and font colour. These buttons are actually tear-off

palettes. When you click on the picture portion of the button, the

format of the picture displayed will be applied to the contents of

the cell(s) you have selected in the worksheet. You can change

the picture displayed on the button by clicking on the button’s

small drop-down arrow to access the palette of samples from

which to choose.