Excel® 2013 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