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 – 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.