WPS Office
Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Free download
Windows • MacOS • Linux • iOS • Android

How to select multiple cells in contiguous range
February 13, 2023
13.2K
Views
52
In WPS Spreadsheet, we can select an entire cell range with a shortcut key until the empty cell. Here are the steps.
1. Select a cell in WPS Spreadsheet.
2. Press the shortcut key Ctrl+Shift+↓on the keyboard.
To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.
Also Read:
- 1. How to use goal seek in excel for multiple cells
- 2. Name Manager: How to delete named range in excel
- 3. How to select text color
- 4. 10 Best Gift Range Chart Template Excel: A Comprehensive Guide
- 5. How to check if value exists in a range in Excel
- 6. How to search for text in a range of cells in Excel