O'Reilly logo

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

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

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