How to select multiple cells in contiguous range
September 14, 2026
14.7K
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. Top 10 free Excel timesheet Templates for Multiple Employees
- 2. How to share an excel file in excel for multiple users
- 3. How to display multiple tables side by side under the same window?
- 4. How to set the cell color to change as the data changes？
- 5. How to cross reference cells between Excel sheets in WPS Office
- 6. How to share excel file for multiple users
15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.
