2

Excel 2007 ® Business and Personal Finances

How can Excel 2007 help you format a workbook?

2

Lesson 3: Format Data and Content

Excel 2007 provides many different tools to format the data and overall look of a spreadsheet.

2

Lesson 3: Format Data and Content View This Presentation to Answer the Following Questions:

• How can I change fonts and font styles?

• How can I apply a border?

• How do I convert text to columns?

• How do I make sure cells are consistently formatted?

• How do I modify the size of rows and columns?

• Why change horizontal and vertical alignment?

• What vocabulary words should I review?

2

Lesson 3: Format Data and Content

Choose the right font to make your worksheet more readable.

The font is the “look” of the characters. A fontstyle is a trait such as bold, italic, or underline.

2

Lesson 3: Format Data and Content

To change a font or font style, use the Format group or launch the

Format Cells

dialog box.

2

Lesson 3: Format Data and Content

You can change the font color of text and numbers. You might use different font colors for totals to make them distinct.

2

Lesson 3: Format Data and Content

To change font color, use the Format menu or the

Formatting

toolbar.

You can also copy a font color from one cell to another without changing any of the data.

2

Lesson 3: Format Data and Content

Click the Borders button drop-down arrow to apply a border to the edges of a cell.

A border is a line along one or more edges of a cell. Applying a border to a cell or groups of cells, makes information easier and quicker to find.

2

Lesson 3: Format Data and Content

To apply a border around certain cells and not around others, change the settings to copy the text without copying the border. Use the Paste Special dialog box to control which information is pasted into a new cell.

2

Lesson 3: Format Data and Content

Academic Skills Check

How can you ensure readability in a worksheet?

Answer: Choosing the right font can help ensure readability in a worksheet.

2

Lesson 3: Format Data and Content

Tech Check

How do you change font color in a worksheet?

Answer: Use the Format menu or the Formatting toolbar to change font color.

2

Lesson 3: Format Data and Content

Tech Check

How do you copy text without copying the border in a worksheet?

Answer: Use the Paste Special dialog box to copy text without copying the border in a worksheet.

2

Lesson 3: Format Data and Content

To make many changes to a group of data in one step, use the Convert Text to Columns Wizard.

Excel makes use of a delimiter, or divider, to separate the text.

The Convert Text to Columns Wizard separates the content of a cell, such as a list of first names and last names, into different columns.

2

Lesson 3: Format Data and Content

To make sure cells cells are consistently formatted, use themes, table styles, and cell styles. A theme is a predefined set of colors, fonts, and effects you can apply to an entire workbook. Microsoft Office Excel 2007 has 16 built-in themes that you can apply or modify to create your own.

2

Lesson 3: Format Data and Content

To apply a table style, or predefined set of formats, to a range of data, use the Format as Table command.

Themes and table styles save time by making formatting changes, such as adding borders and changing font colors, in one step.

2

Lesson 3: Format Data and Content

A cell style is a set of formatting traits that has been given a name. When you apply a cell style, you apply all of the formatting traits of that style.

2

Lesson 3: Format Data and Content

Microsoft Office 2007 has several built-in cell styles, called

Quick

Styles.

Quick Styles allow you to change the look of a group of data— such as applying currency or percentages—in one quick step.

2

Lesson 3: Format Data and Content

Tech Check

How can you make many changes to a group of data in one step?

Answer: Use the Convert Text to Columns function to make many changes to a group of data in one step.

2

Lesson 3: Format Data and Content

Tech Check

How can using themes and table styles help you save time in formatting a worksheet?

Answer: Themes and table styles save time by making formatting changes, such as adding borders and changing font colors, in one step.

2

Lesson 3: Format Data and Content

Excel 2007 offers several ways to change the size of rows and columns.

To change column width, drag the line between the column headings and double-click the line between the column headings to AutoFit them.

You can also use the Format menu to adjust column width using a specified value.

2

Lesson 3: Format Data and Content

To change the row height… Drag the line between row headings or use the Format menu.

2

Lesson 3: Format Data and Content

To center text across a range of cells… use the Center Across Selection feature.

2

Lesson 3: Format Data and Content

Change the horizontal alignment to align the contents of a cell to the left, center, or right.

To change the alignment of a cell’s contents, use the Format Cells dialog box or the buttons in the Alignment group on the Home tab.

2

Lesson 3: Format Data and Content

Change the vertical alignment to position the contents of a cell in relation to the top and bottom of the cell.

To change the vertical alignment of a cell’s contents, use the

Format Cells

dialog box.

2

Lesson 3: Format Data and Content

Tech Check

How can you adjust column width? Answer: To adjust column width, drag the line between the column headings, double-click the line between the column headings to AutoFit them, or use the Format menu.

2

Lesson 3: Format Data and Content

Tech Check

How do you change the vertical alignment of a cell’s contents? Answer: Use the Format Cells dialog box to change the vertical alignment of a cell’s contents.

2

Lesson 3: Format Data and Content

Tech Check

How do you center text across a range of cells?

Answer: To center text across a range of cells, use Center Across Selection.

2

Lesson 3: Format Data and Content

Vocabulary Review

font The overall design of a full set of characters. Also known as typeface.

2

Lesson 3: Format Data and Content

Vocabulary Review

font style An effect that can be applied to a font, such as bold, italic, or underline.

2

Lesson 3: Format Data and Content

Vocabulary Review

border A line or box that frames text or a cell.

2

Lesson 3: Format Data and Content

Vocabulary Review

delimiter A divider that separates text.

2

Lesson 3: Format Data and Content

Vocabulary Review

theme A collection of design elements, graphics, and colors that help items such as documents, presentations, and Web pages maintain a consistent image.

2

Lesson 3: Format Data and Content

Vocabulary Review

cell style A set of formatting traits that has been given a name.

2

Lesson 3: Format Data and Content

Vocabulary Review

table style A pre-defined set of formats that can be applied to a range of data.