Take a shortcut with 11 Excel workbook and ribbon tab shortcut keys

Welcome to today’s WPS Academy, WPS Spreadsheet comes with multitudes of shortcut keys to help you work faster and more productively. Considering there are so many shortcut keys to explore, some of which areunusual in reality, we need to classify these shortcuts first.

Today we will get familiar with the shortcut keys used to for workbook and ribbons.

· Frequently used Excel shortcut keys to process a workbook:

Creating or removing workbooks in Excel is a simple process that just takes a few clicks. Here, you can choose some other shortcuts to achieve the same effect.

Ctrl+N: To create a new workbook.

Ctrl+S: To save the current workbook.

Ctrl+S:To close the current workbook.

Ctrl+PgUp/PgDn: To switch between worksheets in your workbook.

· Frequently used Excel shortcut keys for ribbon tabs:

Switching between different tabs is not a difficult task. If you want to process your data entirely with your keyboard, you’ve come to the right place.

Alt+H: Go to the Home tab and WPS Spreadsheet will tell you each button’s shortcut.

Alt+N: Go to the Insert tab and WPS Spreadsheet will tell you each button’s shortcut.

Alt+P: Go to thePage Layouttab andWPS Spreadsheet will tell you each button’s shortcut.

Alt+M: Go to theFormulastab and WPS Spreadsheet will tell you each button’s shortcut.

Alt+R: Go to theReview tab and WPS Spreadsheet will tell you each button’s shortcut.

Alt+W: Open the View tab and WPS Spreadsheet will tell you each button’s shortcut.

Alt+K: Open the Tools tab and WPS Spreadsheet will tell you each button’s shortcut.

To learn more shortcut keys, please click the following links:

Take a shortcut with 20 shortcut keys for cells in excel

WPS Spreadsheet is a powerful chart and form processor. In WPS Academy, you can learn not only how to use Spreadsheet to sort out data but also how to corporate numeric information into graphs. By watching the step-by-step tutorials on WPS Academy, you will become a spreadsheet expert soon.