Learn Office 2011 for Mac OS X

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