How to select multiple cells in contiguous range
A free Office suite fully compatible with Microsoft Office
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.
Was this helpful?
- 1. How to compare two excel sheets and highlight differences
- 2. How to expand cells to fit text in Excel
- 3. How to import external data in WPS Spreadsheet
- 4. How to copy file names in Excel from a folder?
- 5. How to use the VLOOKUP function across multiple sheets in WPS Office Excel?
- 6. Top 10 simple family tree template Excel free download