14. Enhancing Worksheets

Formatting a spreadsheet and adding graphics and charts are the topics of this chapter.

After explaining just the bare basics in Chapter 13, “Getting Started with Excel,” this chapter covers numerous features and operations that enhance the structure, format, and usefulness of a worksheet. It shows you how to change the column widths and row heights; insert, delete, hide, and unhide cells, columns, and rows; format text and numbers; edit and create Excel styles; work efficiently in very large spreadsheets by freezing and splitting panes; and create charts, sparklines, and SmartArt.

Configuring the Worksheet for Your Data

In a new, blank worksheet, all the columns are the same width, and all the rows are the same height. ...

Get Using Microsoft Office for Mac 2011 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.