Press this combination of keys to quickly access the find function. It is an amazing shortcut that will allow you to skip all the navigation through Excel’s toolbar. This shortcut will show you which cell is active. This command will switch the worksheet tabs to the left. Press this command combination to switch the worksheet tabs to the right. Navigate through Excel and switch between worksheets tabs quicker using the following keyboard shortcuts. Now that you know the basic shortcuts let’s focus on other Excel keyboard shortcuts that will boost your productivity and speed. Ungroup the pivot table items you selected Right-clickĪccess the context menu for the selected row, column, or cell. If you find yourself using many pivot tables, start using the shortcuts below regularly. Pivot tables are handy if you have long rows of data that you need to summarize, and they also allow you to compare your data. It can summarize the selected rows and columns of the spreadsheet or even reorganize them. The Pivot Table is a potent tool in Excel.

These shortcuts are convenient, and you should get used to using them not only in Excel, but also in Microsoft Word, internet browsers, or any other app you frequently use for business or leisure. Nonetheless, here’s a useful table with the most commonly used Excel keyboard shortcuts that you need to start using to quickly improve your mastery over spreadsheets. You’re probably familiar with some shortcuts as they are commonly used across most Windows 10/11 and Microsoft Office apps. So let’s focus on the most important ones that you’ll need on a daily basis. You will use some Excel shortcuts more often than the others.

Key shortcuts for excel 2016