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

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. įor 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 N. Near the end is a section for Word 2019 only. 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. Related: Microsoft cheat sheets: Dive into Windows and Office apps Most of the tips in this article apply to both Word 2016 and Word 2019 for Windows. To help, we've compiled a guide that shows each Ribbon tab, explains what it's for and highlights its most commonly used commands. Since it's always present at the top of your screen, the Ribbon puts a wealth of commands in easy reach at all times.īut with so many tabs and so many commands, it's not always obvious where to go to perform a given action. It's divided into a series of tabs that group related commands together.

See that article for detailed information on how to get the most out of Excel 2016 and Excel 2019 for Windows.įor the most part, the Ribbon interface in Excel 20 is intuitive to use.

This download accompanies our Excel 20 cheat sheet.

Microsoft word 2016 cheat sheet pdf