O'Reilly logo

Learn Office 2011 for Mac OS X by Guy Hart-Davis

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

Chapter 13. Formatting Your Worksheets

In this chapter, you'll learn how to format your worksheets so that they show the information you need and present it clearly.

We'll start by looking at how to work with rows and columns—inserting, deleting, and formatting them so that your worksheet is the right shape. I'll then show you how to format cells and ranges, how to apply conditional formatting to quickly flag values that need attention, and how to use data validation to check for invalid entries.

After that, we'll look at how to format worksheets quickly using table formatting or Excel's styles, how to add headers and footers to worksheets, and how to print worksheets and workbooks.

Lastly, you'll learn to use Excel's features for sharing workbooks ...

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