Summary of shortcuts for Microsoft Excel 2016-P1

The launch of Office 2016 toolkit gives users new features, serving the diverse needs of users. For those who work in computing, Microsoft Office becomes an effective tool, when the calculation will be much easier. However, due to the changes and upgrades of Office 2016, there are quite a few people who are not familiar with the use.

In particular, for those who only use the mouse to perform operations with spreadsheets, it will take a lot of time. So why not try using more useful shortcuts. We introduced you to the shortcuts for Excel 2007, 2010. And this article will summarize the shortcuts for Excel 2016.

Note: If a shortcut requires pressing two keys or multiple keys at the same time, the keys will be separated by a plus sign (+). If you have to press a key right after another key, the keys will be separated by a comma (,).

1. Common shortcuts are used:

This table lists the most commonly used keys in Excel 2016

Close the spreadsheet Ctrl + W Open the spreadsheet Ctrl + O Go to the tab Home page Alt + H Save the spreadsheet Ctrl + S Copy Ctrl + C Paste Ctrl + V Undo Ctrl + Z Remove the contents of the Delete key Select the color Fill Alt + H, H Cut Ctrl + X Insert Card Alt + N Bold Click Ctrl + B Center Alt + H, A, then C Page Layout Alt + P Data Alt + A Card View Alt + W Format cell from right-click menu Shift + F10 Add border Alt + H, B Delete column Alt + H, D, then C Formula Alt + M

2. Shortcuts to navigate the Ribbon interface:

The Ribbon bar also calls the menu bar in Excel 2016 that contains easily accessible commands that are displayed on the screen. There are main Ribbon groups: Home, Insert, Page Layout, Formulas, Data, Reviews, View, Developer, Add-Ins. Shortcuts will help you access commands on the Ribbon much faster. For example, to hide or display the Ribbon, we use Ctrl + F1. To access the Ribbon press the Alt key, move between tabs using the left or right arrow.

Access the keys on the Ribbon interface:

Open the Tell me dialog on the Ribbon and enter the search keyword Alt + Q, then enter the search term Open the file and use the Backstage feature Alt + F Open the Home tab, alphanumeric format, use the Find Alt + tool H Open Insert tab, insert Pivot Tables, charts, add-ins, Sparklines, images, drawings, Header, Alt Text box + N Tab Layout, work with theme, Page setup, scale and align Alt + P Formulas tab, insert formulas, or work with functions as well as Alt + M calculations Data tab, connect, sort, filter, analyze, work with Alt + A Tab Review data, spell checking, Insert comments, Protect sheets and Workbooks Alt + R Tab View, preview how to interrupt interrupts and page layout, display and hide gridlines, heading, scaling or zooming, manage windows and panes, Alt + W macro

Working on Ribbon tabs and menus with the keyboard:

When you want to switch between tabs on the Ribbon, or the right-click menu we can navigate in those tabs as follows:

Select the active tab on the Ribbon, activate the access keys Alt or F10. To switch to another tab, use the access key or the arrow Move to commands on Ribbon Tab or Shif t + Tab Move up, down, left, right corresponding items on the Ribbon Use 4 arrows: up, down , left, right Activate the selected button Spacebar or Enter Open the list for the selected command Down arrow Open the menu for a selected button Alt + Down Arrow Opens the menu or submenu, moves to the next command Down Arrow Ribbon size Ctrl + F1 Open Context menu Shift + F10 or Context key Move to submenu when opening or choose a main menu Left arrow

Use Access Keys (access key) to see Key Tip:

You can display Key Tip, which is a new version of the underlined character system that you are familiar with in Excel versions before you want to access the menus using the Alt key.

1. Press the Alt key.The Key Tip appears in the small squares according to each Ribbon command.
2. To select a command, click on the letter displayed in the Key Tip. The square appears immediately next to the command.

Depending on the letters you press, you can see the additional Key Tips.For example, if you press At + F, the Backstage feature will open on the Info page, this page has another set of Key Tip.If you leave the Alt most, Key Tip will appear and navigate on the current page.

Above is part 1 of the shortcuts used in Excel version 2016. Save the article to be able to perform operations on the spreadsheet faster.We will soon return to the next part of the Excel 2016 shortcuts.

Refer to the following articles:

1. You want to print text, data in Microsoft Excel. Not as simple as Word or PDF! Read the following article!

1. MS Excel - Lesson 4: Working with lines, columns, sheets

1. 10 ways to recover corrupted Excel files

I wish you all success!