Knowledge Pack

Excel 2016 cheat sheet: Ribbon quick reference

Become An Insider

Sign up now and get FREE access to hundreds of Insider articles, guides, reviews, interviews, blogs, and other premium content. Learn more.

Our visual guide helps you find the most popular commands on Excel 2016’s Ribbon, along with keyboard shortcuts for performing each action.

Computerworld Cheat Sheet - Microsoft Excel 2016

This download accompanies our story Excel 2016 cheat sheet. See that article for detailed information on how to get the most out of Excel 2016.

For the most part, Excel 2016's Ribbon interface is intuitive to use. It's divided into a series of tabs that group related commands together. Since it's always present at the top of your screen, the Ribbon puts a wealth of commands in easy reach at all times.

But with so many tabs and so many commands, it's not always obvious where to go to perform a given action. To help, we've compiled a guide that shows each Ribbon tab, explains what it's for and highlights its most commonly used commands. And for those of you who don't like to take your hands from the keys to point and click, we've included keyboard shortcuts for all the actions.

For instance, if you want to insert a line chart in your spreadsheet, you'd go to the Insert tab and click the line chart icon in the Charts group, or press Alt-N and then Q. To freeze a portion of the sheet so it’s always visible while you scroll through the rest, you'd go to the View tab, find the Window group and select Freeze Panes, or press Alt-W and then F.

Keep this reference guide handy so you'll always know where to find the commands you need.

To continue reading this article register now