Knowledge Pack

Excel 2016 and 2019 cheat sheet: Ribbon quick reference

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

Computerworld Cheat Sheet - Microsoft Excel 2016

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

For the most part, the Ribbon interface in Excel 2016 and 2019 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