Chapter 3

Making It All Look Pretty

IN THIS CHAPTER

check Selecting the cells to format

check Formatting data tables with the Format as Table command button

check Using various number formats on cells containing values

check Adjusting column width and row height in a worksheet

check Hiding columns and rows in a worksheet

check Formatting cell ranges from the Home tab of the Ribbon

check Formatting cell ranges using Styles and the Format Painter

check Formatting cells under certain conditions

In spreadsheet programs like Excel, you normally don’t worry about how the stuff looks until after you enter all the data in the worksheets of your workbook and save it all safe and sound (see Chapters 1 and 2). Only then do you pretty up the ...

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