1. What’s New in Excel 2016 (and 2013)

This chapter explains the new features in Excel 2016 and a few important features that you might have missed if you upgraded directly from Excel 2010 to Excel 2016.

Color Returns to the Excel Interface

The first thing most people noticed in Excel 2013 was the RIBBON TABS IN ALL CAPS and the lack of color in the Excel interface. It was maddening—how could you tell if something was grayed out if the entire ribbon was already white and gray?

Apparently, the branding gurus responsible for Excel 2013 have been banished to the Xune team and color returns to the Excel 2016 interface. Go to File, Account and change the Office Theme to Colorful, as shown in Figure 1.1. Excel 2016 takes on a nice, deep green color. ...

Get Excel 2016 In Depth 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.