How to select multiple cells in contiguous range

November 8, 2021
94 Views 0

Graphic skills

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.

How to select multiple cells in contiguous range 1.jpg

How to select multiple cells in contiguous range 2.gif


To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.