Chapter 6. Polishing Your Spreadsheet Data

Being able to crunch numbers or build database tables is of little use if your worksheet data is difficult or impossible for others to comprehend. Fortunately, you can mitigate this by liberally applying some of Excel's formatting tools. For example, you can apply themes to your workbooks to create a more polished and professional look, as well as add colors, patterns, and borders to cells to make them stand out. You can even use digital images as backgrounds in your worksheets.

To draw attention to cells that meet criteria you set, you can apply conditional formatting. For example, you might set a rule to highlight cells that contain values greater than, less than, equal to, or between a range of specified ...

Get Office 2010 Visual™ Quick Tips 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.