Easy Microsoft® Excel® 2010

Chapter 4. Formatting Worksheet Data

The primary purpose of Excel’s formatting tools is to make your worksheet more readable. For example, you can change the display of the numbers so that they don’t contain decimal places. This allows your audience to see the needed data without being inundated with superfluous numbers.

Excel’s formatting options can be partitioned into two buckets: cell formatting and data formatting. Cell formatting is essentially the act of changing the look and feel of the cells themselves. For instance, you can change the cell background colors, add borders, change alignment, add underline or bold effects to cell contents, and wrap text. Data formatting is the act of formatting the data in the most readable and appropriate ...