O'Reilly logo

My Excel 2016 by Tracy Syrstad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

6. Formatting Sheets and Cells

Image

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required