O'Reilly logo

Using Microsoft Office for Mac 2011 by Yvonne Johnson

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

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

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