How to select worksheets in WPS Spreadsheets

Select A Single Sheet

If you want to select a single worksheet, just need to click the sheet tab,shown as below:

If you can't see the tab that you want, click the tab scrolling buttons to display the tab, and then click the tab.

Two or More Adjacent Worksheets

If you want to select two or more adjacent worksheets, follow the steps as below:

- Click the tab for the first sheet.

- Hold down Shift key while you click the tab for the last worksheet that you want to select.

Two or More Nonadjacent Worksheets

If you want to select two or more nonadjacent worksheets,follow the steps as below:

-Click the tab for the first sheet.

- Hold down Ctrl key while you click the tabs of the other worksheets that you want to select.

Note: You can right-click the sheet tab, and choose Select All Sheets in the corresponding menu. And if you want to cancel this operation, you just need to click any unselected worksheet.