How to insert row via shortcut in WPS Office Excel

March 4, 2022
4.2K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

A free Office suite fully compatible with Microsoft Office

Free Download

Welcome to WPS Official Academy to check the contents of how to insert row via shortcut in WPS Office Excel. This quick tutorial will help you make progress in using office software and improving your work efficiency. Continue to read together with WPS!

The proper use of shortcut keys enables us to speed up our work. Now let's meet a practical shortcut used to insert in WPS Office Excel, Ctrl+Shift+ +.

lSteps to insert row via shortcut in WPS Office Excel

1. Open the excel file in WPS Office, and locate the row above which you need to insert a new row.

2. Press the three keys, Ctrl, Shift and + on the keyboard in the meantime.

3. Consequently, the Insert box is activated, where you can check Entire row and modify the amount of row to insert.

4. Click OK in the end, and a new row is inserted successfully.

2.gif 

lWhat is WPS Spreadsheet?

WPS Spreadsheet is a component of WPS Office suite, the best alternative to Microsoft office suite trusted by over 200,000 of the world’s leading organizations. Committed to providing the users with the best office experience, WPS Spreadsheet is equipped with abundant useful features and various exquisite templates. Its concise interface and intuitive operation guide are also favored by students, teachers, business professionals and so on.

In this course, how to insert row via shortcut in WPS Office Excel is introduced in detail. If you are desired to master more useful shortcut keys, please click the following links to visit WPS Academy.

Must-have shortcut tricks in making slides | WPS Academy Free Office Courses

How to customize text shortcut keys | WPS Academy Free Office Courses

The following is the sum of some common shortcut keys.

Common shortcut keys in WPS Spreadsheet | WPS Office Quick Tutorials Online

Shortcut keys in PowerPoint | WPS Office Quick Tutorials Online

The most useful Microsoft Excel Keyboard Shortcuts can be free to learn in WPS Academy. There's no denying the fact that shortcuts make our lives easier and if you're a Excel user, you can refer to WPS Speadsheet guide to learn some of the major shortcuts. WPS Academy list some of the most important Microsoft Excel shortcuts for Windows, PC, Mac, Linux, Android, and iOS devices to make your work easier.