Quickly create a worksheet with the same structure with the WPS table

In practice, users sometimes need to create multiple worksheets with the same structure, this article mainly describes how to use the WPS table to create the same worksheets in detail.

In general, there are several things you can do to create the same structure sheet:

1. In the case where the source worksheet is not created, the user establishes multiple worksheets at the same time.

2, the source worksheet has been established, users need to use the source worksheet as a template to copy other worksheets.

SOURCE sheet not established

If the user creates the source worksheet for the first time, follow these steps to create a worksheet with the same structure at once.

1 Open the wps form and insert multiple empty worksheets as needed.

A, select the Insert | Sheet menu item to open the Insert Sheet dialog box.

Insert Worksheet

B, in the dialog box "Insert Number" text box enter the number of inserted worksheets (such as 2), click the "OK" button, insert the empty worksheet.

2 Click the right mouse button on the worksheet tab and select All Sheets from the shortcut menu that pops up, selecting all sheets.

Select all Worksheets

3 The table design in any worksheet, format adjustment, when the content input and formatting is complete, all worksheets have the same content and format.

The source sheet is established

If the source worksheet is already established, there are three ways to quickly copy the same worksheet.

First, the user uses the WPS table to open an already established workbook containing the source sheet.

Method One

1) point the mouse to the Source worksheet label, right-click, and select the Move or Copy Sheet menu item in the pop-up shortcut menu to open the Move or Copy Sheet dialog box.

Copying worksheets

2 in the dialog box, check the "Make Copy" checkbox and click on the "OK" button to create the same copy.

3) repeatedly, you can create multiple copies of the worksheet with the same structure based on the source sheet.

Method Two

1 Click the "Select All" button in the worksheet area to select all the range of cells in the current worksheet.

Select All Workspaces

2 Select the Edit | Copy menu item (or press the key combination) to copy the selected area.

3 Switch to another worksheet, click A1 Cell, select the Edit | Paste menu item (or press the key combination), paste all the content, complete the data copy.

4 repeated the 3rd step operation, can realize the duplication of multiple worksheets.

Method Three

The following fill feature allows users to copy multiple worksheets at once.

1 Insert multiple empty worksheets as needed;

2 Select all worksheets;

3 Click Label on the source sheet to activate the source worksheet as the current worksheet;

4 Click the Select All button on the worksheet to select all the range of cells in the source worksheet;

5 Select the Edit | fill | To group sheet menu item to open the Fill in Group Sheet dialog box.

Populate Group Worksheets

6 in the dialog box under "Fill" Select the "All" radio box, click the "OK" button, the entire contents of the source worksheet to fill the other group of worksheets.

Summary:

Using the 3 methods described below, users can quickly create multiple copies of worksheets with the same structure.

1, the source worksheet is not established, use a full selection of worksheets can be a one-time build multiple structure of the same worksheet.

2. The source worksheet is established, and you can create a copy by copying a worksheet or copying a range of cells.

3. The source worksheet has been established, and you can use the Fill command to copy multiple worksheets with the same structure at once.

Scope of application:

Applies to WPS Office 2005 and above.