O'Reilly logo

Microsoft Office Excel 2007 On Demand by Steve Johnson - Perspection, Inc.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required