The Excel Formatting Toolbar

Excel formatting toolbar normally located near to the top of your screen as shown here. The toolbar icons have a specific purpose that can change the outlook of your spreadsheet when you apply formatting to it.

The formatting toolbar icons and functions:

·  Font – to select fonts from a drop-down list.

·  Font Size – to select a font size from a drop-down list.

·  Bold – to apply bold to a selected range.

·  Italic – to apply italic to a selected range.

·  Underline – to underline a selected range.

·  Align Left – to align a selected range to the left.

·  Center – to center a selected range

·  Align Right – to align a selected range to the right.

·  Merge and Center – to merge cells and center text across a selected range.

·  Currency Style – to apply currency style to a selected range.

·  Percent Style – to apply percentage style to a selected range.

·  Comma Style – to apply comma style to a selected range.

·  Increase Decimal – to decrease the number of decimal points displayed in a selected range.

·  Decrease Decimal – to increase the number of decimal points displayed in a selected range.

·  Decrease Indent – to decrease the level of indentation in a selected range.

·  Increase Indent – to increase the level of indentation in a selected range.

·  Borders – to select and apply borders to a selected range.

·  Fill Color – to select and apply color to a selected range.

·  Font Color – to select and apply color to text in a selected range.