Format a Workbook

Lesson 2 – Microsoft Excel 2010

Learning Goals

• The goal of this lesson is for students to successfully apply formatting to a worksheet that was created in Microsoft Excel 2010. The student will learn to edit a worksheet and apply formatting attributes to enhance the appearance of the worksheet.

Learning Objectives

• On completion of this lesson, students will be able to do the following:– Format text– Format numeric data– Format numbers as currency– Use Format Painter– Add borders to cells– Add shading to cells– Use AutoFormat– Apply conditional formats– Create and apply styles– Merge cells

Formatting: What is it and Why?

• Formatting is changing the way that something looks.

• Proper formatting should enhance the readability and presentation of data.

• What could you do to make text or data easier to read?

Formatting Text

• Font – A set of printable or displayable text characters in a specific style and size.

• Font Style – Style of font chose• Font Size – The measurement of the typeface in

points (1 point = 1/72 of an inch) For example:

Font: Arial Bold 12 pointFont Size: 12 pointFont Style: Bold

Formatting Text, continued.

Use the Font group on the Home ribbon to change the font, font size, and font style.

Use the Alignment group on the Home ribbon to change the alignment of and indent text.

c

Formatting Numeric Data

• Numeric data is any number that will be used in calculations.

• Formatting a numeric entry as text allows the entry to be treated as text even when a number is present in the cell.

Formatting Numeric Data, Cont.

Applying currency style applies a dollar sign, commas, and two decimal places.

By default, numbers use the “General” format.

Use the increase/decrease decimal buttons to add or remove decimal places. (Decimal places can be used in numbers other than currency.

Applying percent style multiples the number by 100 and adds a percent symbol.

Applying comma style inserts commas between groups of thousands.

Using Format Painter

• The Format Painter will copy a format from one area to another without altering the data.

• It will copy the font, font size, font style, font color, alignment, indentation, number format, border, and shading.

HOW TO: Select an object with the formatting you want, click the format painter, click or select the new object that you want to apply the formatting to.

Adding Borders to Cells

• Borders will emphasize a specific portion of a worksheet by applying various styles and colors of lines around a range of data.

Adding Shading to Cells

• Applying shading and patterns to a cell or range of cells can draw attention to the area.

• Shading is also a good method for improving readability of cells.

Using Cell Styles

• The Cell Styles Command – will apply predefined

formats to a range of cells.– will serve as a time saver in

worksheet creation.– will automatically apply

borders, shading, patterns, and font changes to a range of cells.

Creating and Applying Styles

• Styles:– are a defined set of

formats that can be applied to cells or a range of cells.

– can be defined by the user and that they facilitate consistency in worksheet formats.

Merging Cells

• Merging cells will convert multiple cells into one individual cell.

• Merging cells allows for ease of formatting within the cells.

Select the cells and click “merge and center” in the Alignment group on the Home tab or on the Alignment tab in the Format Cells Dialog box.

Advanced Formatting Techniques—Numeric formatting options