4. Data Formatting

This chapter will show you how to format your data manually and create rules to format it automatically

You don’t have to format the data in a workbook, but good use of formatting can make a dull presentation pop or even highlight the point you are trying to get across. This chapter reviews formatting from the most basic options, such as bolding text, to the more advanced options, such as data bars.

Cell Formatting

All the formatting options described in this section can be found on the Format Cells dialog in Excel and Excel Starter, which you can open by right-clicking a cell and selecting Format Cells or by pressing Ctrl+1 (the number one). Many formatting options are also available on the minitoolbar in Excel and Excel ...

Get Using Microsoft® Excel® 2010 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.