Show Me Microsoft® Office Excel 2003

Chapter 5. Formatting a Worksheet

What You'll Do

• Format Text and Numbers

• Design Conditional Formatting

• Copy Cell Formats

• Change Fonts

• Change Data Alignment

• Control Text Flow

• Change Data Color

• Add Color and Patterns to Cells

• Add Borders to Cells

• Format Data with AutoFormat

• Modify an AutoFormat

• Format Tabs and Background

• Create and Apply Style

• Modify a Style

• Find and Replace Formatting

Introduction

Microsoft Office Excel 2003 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 of selected numbers and text by adding dollar signs, commas, and other numerical formats or by applying attributes, ...