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

March 11, 2022
1.8K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

Welcome to todays 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, youve come to the right place.

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

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

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

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

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

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

Alt+K: Open the Tools tab and WPS Spreadsheet will tell you each buttons 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.