How to insert row via shortcut in WPS Office Excel
A free Office suite fully compatible with Microsoft Office
A free Office suite fully compatible with Microsoft Office
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.
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.
Was this helpful?
Yes
No
Trending Tutorials
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to color cell based on value in Excel?
- 5. How to compare two excel sheets and highlight differences
- 6. How to add text to beginning or end of all cells in Excel