It is a toolbar that has the icons that provide the various formatting settings for cells, columns, rows and data in Excel. For example, it can allow to change the colours of rows, cells and columns. It allows to change fonts. It allows to set the alignment for data in cells. It allows to apply borders to cells.
It allows to change the format of numbers, like adjusting the amount of decimals they have or changing them to percentage format. All of these and other things can be done with it.
1. Format Cells Dialog Box:
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.
2. Number tab:
The data type can be selected from the options on this tab. Select General if the cell contains text and numbers, or a different numerical category if the cell is a number that will be included in functions or formulas. The number tab can be used to limit the number decimal places,
3. Alignment tab:
These options allow you to change the position and alignment of the data within the cell. For example, right, left, center, vertical alignments, text wrap, etc.,
4. Font tab:
All of the font attributes are displayed in this tab including font face, size, style, and effects. For example, bold, italicize, underline, increase/decrease the font size, changing the ***** of font, fill, etc.,
5. Border and Pattern tabs:
These tabs allow us to add borders, shading, and background colors to a cell.
