WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to duplicate a sheet in WPS Spreadsheet

October 20, 2021
9.7K Views

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

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.