6. Formatting Sheets and Cells
Formatting data is important—it makes it easier to interpret the data and pulls the user’s eye to important parts. You also need to know how to resize rows and columns so more of your data is visible. This chapter includes the following topics:
→ Merging cells
→ Formatting dates
→ Centering data in a cell
→ Quickly copying a format from one range to another
→ Switching between number formats
Now that you have your data on a sheet, you need to format it so that it’s easy to decipher and readers can quickly make sense of it. From formatting the font, wrapping text, and merging cells to changing how a number is displayed ...
Get My Excel 2016 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.
