How to duplicate a sheet in WPS Spreadsheet

October 20, 2021
336 Views 0

Graphic skills

· 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.

1.gif

 

· Option 2:

1. Use WPS Office to open the sheet.

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

2.gif

 

· Option 3:

1. Use WPS Office to open the sheet.

2. Click the title area of the sheet below, right-click and select Move 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.

3.gif

 

· 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.

4.gif

 

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