Microsoft Office Excel 2007 On Demand

5. Formatting a Worksheet

What You'll Do

Format Numbers and Text

AutoFormatting Text While You Type

Apply Conditional Formatting

Creating and Managing Conditional 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 Office 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 the appearance ...