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
When it comes to populating a worksheet with data, Excel doesn't put a lot of hurdles in your path. Most of the time, you click the cell you want to use, type your label or data, press Enter, and — voilà! — you've got yourself a cell entry. Repeat as needed and soon enough your worksheet is done.
Or is it? The problem with Excel's data entry process is that it tends to produce worksheets that are, well, unattractive: All the text is the same ...
Get Excel 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.
