Chapter 7. Formatting Your Worksheet

In this chapter

• Enhancing the appearance and readability of your worksheets.

• Changing the way entries line up in cells and columns .

• Adding borders around cells and shading inside cells, rows, and columns.

• Instructing Excel to flag values that dip below, rise above, or fall within a specified level or range.

• Creating sets of cell enhancements you can apply with a single command or keystroke.

Plain text entries, numbers, and dates can make your worksheet appear drab and dumpy. To make your numbers a little more appealing, and make the rows and columns easier to follow, you need to format your worksheet. You can format by inserting blank rows and columns to give your values a little elbow room, laying down a few lines around your cells, or even shading individual cells, rows, or columns to make them stand out. In this chapter, you learn several ways to adorn your worksheets and make your numbers a little more exciting.