Chapter 18. Making Great-Looking Worksheets

In this chapter

How Cell Formatting Works 560

Changing Formatting for a Cell or Range 566

Designing and Formatting a Worksheet for Maximum Readability 577

Using Conditional Formatting to Identify Key Values 584

Copying Formats with the Format Painter 586

Saving Formats as Named Styles 587

Using AutoFormat 588

Troubleshooting 590

Extra Credit: Redesigning a Worksheet Clarifies the Information 590

How Cell Formatting Works

In an Excel worksheet, what you see in a cell is not necessarily what’s stored in that cell. If you enter a formula, for example, Excel stores the formula but displays its result. When entering numbers, dates, and text, you can go as quickly as you want, without too much regard for ...

Get Special Edition Using Microsoft® Office 2003 Student-Teacher Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.