Chapter 2: Formatting Worksheets

In This Chapter

arrow.png Selecting cell ranges and adjusting column widths and row heights

arrow.png Formatting cell ranges as tables

arrow.png Assigning number formats

arrow.png Making alignment, font, border, and pattern changes

arrow.png Using the Format Painter to quickly copy formatting

arrow.png Formatting cell ranges with Cell Styles

arrow.png Applying conditional formatting

Formatting — the subject of this chapter — is the process by which you determine the final appearance of the worksheet and the data that it contains. Excel’s formatting features give you a great deal of control over the way the data appears in your worksheet.

For all types of cell entries, you can assign a new font, font size, font style (such as bold, italics, underlining, or strikethrough), or color. You can also change the alignment ...

Get Excel 2013 All-in-One For Dummies 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.