How to duplicate a sheet in WPS Spreadsheet

· Option 1:

1. Use WPS Office to open the sheet.

2. Click the title area of the sheet below, right-click and select Duplicate Sheet.

· Option 2:

1. Use WPS Office to open the sheet.

2. While pressing the Ctrl key, click the left mouse button to drag thesheet to the desired position. Then, we can complete the copy of the sheet.

· Option 3:

1. Use WPS Office to open the sheet.

2. Click the title area of the sheet below, right-click and selectMove Sheet.

3. In the pop-up dialog, choose Move to end in the Before sheet box, check the Create a copy option, and click the OK button. Then, we can complete the copy of the sheet.

· Option 4:

1. Use WPS Office to open the sheet.

2. Right-click the triangle button in the upper left corner. In the pop-up menu, choose Copy, or use the shortcut Ctrl+C.

4. Click the New Sheet button to create a new sheet.

5. In the new sheet, right-click the triangle button in the upper left corner. In the pop-up menu, choose Paste, or use the shortcut Ctrl+V. Then, we can duplicate the original sheet.

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