1-866-245-5224 sales@keystonelearning.com

Excel 2003: Using the Formatting Toolbar

Excel 2003: Using the Formatting Toolbar

The Formatting toolbar is the first place to head when you want to add emphasis to specific text or cells on your Excel worksheet.

For the most part, formatting is applied to all text within a selected cell.

 

Figure 13. Formatting Toolbar

               

Command…

Function…

Font Face

This drop-down list displays the fonts available on your computer. The default Microsoft Office 2003 font is Times New Roman.

Font Size

This drop-down list displays typical font sizes. The default Microsoft Office 2003 font size is 10. One font size point is equal to 1/72” tall. So, 72 point text will print 1” high. If you need a size not listed in this drop-down, you can click inside the box and type the size you want.

Bold

This command applies bold formatting to selected text.

Italic

This command applies italic formatting to selected text.

Underline

This command applies an underline to selected text.

Left Align

This command will align the text with the left of the cell.

Center Align

This command will align the text between the left and right cell edges.

Right Align

This command will align the text with the right of the cell.

Merge and Center

This command will center the text between two or more columns.

Currency

Formats selected cells to currency with two decimal places.

Percentage

Formats selected cells to percent.

Comma

Formats selected cells to display commas and decimal places.

Increase Decimal

Increases the decimal display of selected cells.

Decrease Decimal

Decreases the decimal display of selected cells.

Decrease Indent

This command will decrease the indent of selected text to the nearest [Tab] stop. Default tabs are set every .5”.

Increase Indent

This command will increase the indent of selected text to the nearest [Tab] stop. Default tabs are set every .5”.

Borders

This command adds borders to the edges of your selected text.

Fill Color

Add a color to selected cells that appears behind the cell contents.

Font Color

This command changes the color of selected text lettering.