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 live online training, plus books, videos, and digital content from nearly 200 publishers.