© Guy Hart-Davis 2016

Guy Hart-Davis, Learn Office 2016 for Mac, 10.1007/978-1-4842-2002-3_13

13. Formatting Your Worksheets

Guy Hart-Davis

(1)Barnard Castle, Durham, UK

In this chapter, you’ll learn how to format your worksheets so that they show the information you need and present it clearly. You’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. Then you’ll learn 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, you’ll look at how to format worksheets quickly using table formatting or Excel’s styles, how to add headers and ...

Get Learn Office 2016 for Mac, Second Edition 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.