Part 11. Formatting Worksheet Data

When you format a worksheet, you can change the appearance of the data in it. With Excel's formatting tools, you can make your worksheet more attractive and readable. For example, you can increase and decrease the width of columns and height of rows, as well as change the color of your data or the cell background.

In addition to changing the look of your cell data, you can change how it is displayed in your worksheet. For example, you can merge and center a title or add header information. You can change the placement of the data in a cell so that it is at the top, bottom, left, right, justified, centered, or even displayed vertically.

After you add all the formatting to your data, you can always clear it and return to just the regular default data format. Or, after you have applied formatting to your data, you can choose one of Excel's default formats, known as AutoFormats. Excel even lets you apply formatting based on a set of conditions you establish.