Microsoft® Excel 2010 On Demand

5 Formatting a Worksheet

What You’ll Do

Format Numbers and Text

AutoFormat Text While You Type

Apply Conditional Formatting

Create and Manage Conditional Formatting

Create Sparkline Formatting

Change Data Alignment

Control Text Flow

Change Data Color

Add Color and Patterns to Cells

Add Custom Colors

Add Borders to Cells

Format Tabs and Background

Copy Cell Formats

Understand, Apply, and Create Themes

Choose Theme Colors, Fonts, and Effects

Create, Apply, and Modify a Cell Style

Find and Replace Cell Formatting

Introduction

Microsoft Excel offers several tools for making your worksheets look more attractive and professional. Without formatting, a worksheet can look like a sea of meaningless data. To highlight important information, you can change ...