Chapter 2

Formatting Worksheets


check Selecting cell ranges and adjusting column widths and row heights

check Formatting cell ranges as tables

check Assigning number formats

check Making alignment, font, border, and pattern changes

check Using the Format Painter to quickly copy formatting

check Formatting cell ranges with Cell Styles

check 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 of entries ...

Get Excel 2019 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.