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