WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to insert row via shortcut in WPS Office Excel

March 19, 2024
12.3K Views

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.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.