Chapter 12. Formatting Worksheet Data

Excel makes formatting data easy with many simple, yet powerful, tools. In addition to applying traditional formatting common to all Office applications, you can also 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 looking for.

Formatting your worksheet data using colored cell styles or as a table are other ...

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