Chapter 2
Formatting Worksheets
In This Chapter
Selecting cell ranges and adjusting column widths and row heights
Formatting cell ranges as tables
Assigning number formats
Making alignment, font, border, and pattern changes
Using the Format Painter to quickly copy formatting
Formatting cell ranges with Cell Styles
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 ...
Get Excel 2016 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.
