Chapter 19. Advanced Worksheet Formatting

In this chapter

Entering Data in an Excel Worksheet 554

Changing Formatting for a Cell or Range 560

Designing and Formatting a Worksheet for Maximum Readability 573

Using Conditional Formatting to Identify Key Values 583

Copying Formats with the Format Painter 587

Troubleshooting 588

Secrets of the Office Masters: Storing Multiple Scenarios in a Single Workbook 588

Entering Data in an Excel Worksheet

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 how they’ll look in your ...

Get Special Edition Using Microsoft Office 2007 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.