Chapter 12. Formatting Worksheet Data

Image

Excel makes formatting data easy with many simple, yet powerful, tools. In addition to applying traditional formatting common to all Office applications, you can wrap cell text and merge columns to create headings in Excel.

As expected for a spreadsheet application, Excel offers many options for formatting numbers, including formatting as currency, percentages, fractions, dates, times, and more.

If your worksheet contains a lot of data, Excel makes it easy for you to find a specific cell or even replace cell content automatically. Freezing row numbers and column letters also makes it easier to find what you’re ...

Get Easy Office 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.