Excel for Office 365 cheat sheet: Ribbon quick reference

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

This download accompanies our Excel for Office 365 cheat sheet. See that article for detailed information on how to get the most out of Excel for Office 365 in Windows.

For the most part, the Ribbon interface in Excel for Office 365 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 pie chart in your spreadsheet, you'd go to the Insert tab and click the pie 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

Where does this document go — OneDrive for Business or SharePoint?
  
Shop Tech Products at Amazon