O'Reilly logo

Special Edition Using Microsoft Office 2007 by Woody Leonhard, Ed Bott

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

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

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