Chapter 13. Making Great-Looking Worksheets

In this chapter

How Cell Formatting Works

Changing Formatting for a Cell or Range

Designing and Formatting a Worksheet for Maximum Readability

Using Conditional Formatting to Identify Key Values

Copying Formats with the Format Painter

Saving Formats as Named Styles

Troubleshooting

Extra Credit: Redesigning a Worksheet Clarifies the Information

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 how they’ll look in your worksheet; afterwards, use cell ...

Get Special Edition Using Microsoft® Office Home and Student 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.