FormatCellsDialog lets you change many of the ways in which data is displayed in a Spreadsheet cell. For example, you can specify the number of digits to the right of a decimal point, or you can add a pattern and border to the cell. You can access and modify the majority of these settings in the Format Cells dialog box.
This topic explains various settings of FormatCellsDialog and how they will affect the way cell data is presented.
Format Cells dialog has six individual tabs which provide different settings to modify the cell data:
Excel has a large array of built-in number formats from which you can choose. To use one of these formats, click any one of the categories below General and then select the option that you want for that format. When you select a format from the list, Excel automatically displays an example of the output in the Sample box on the Number tab. For example, if you type 1.23 in the cell and you select Number in the category list, with three decimal places, the number 1.230 is displayed in the cell.
The following table lists all of the available built-in number formats:
You can position text and numbers by using the Alignment tab in the Format Cells dialog.
Text Alignment : Using this setting you can control the horizontal, vertical alignment and indention of the text.
Text Control : There are some additional miscellaneous text alignment controls in the Text Control section of the Alignment tab. These controls are Wrap Text, Shrink to Fit and Merge Cells.
You can use the Font tab in the Format Cells dialog box to set a font and control its attributes like point size, font style, underlining, color, and effects.
You can use this tab to customize the cells' borders from their default settings by changing the line style, line thickness or line color.
Use this tab to set the background color of the selected cells. You can also use the Pattern Color or Pattern Style to apply color patterns or different styles of patterns to the background of the cell.
The Protection tab offers you an option for protecting your worksheet data and formulas:
Locked
However, this option takes effect only when you protect your worksheet.