How to Use WPS Fill on Windows

Use WPS Fill through 8 how-to topics, including Fill Down, Fill Right, and Enter Current Date; 6 topics are available without membership and 2 are membership-related.

How-to Index

How-to Guide

1. Fill Down

Feature path: Home tab → Fill drop-down menu → Fill Down

1. Select the source cell and the target range that you want to fill downward.
2. Click the Home tab.
3. Open the Fill drop-down menu.
4. Click Fill Down.
5. The content of the top cell in the selection is copied to all selected cells below.

Success Criteria

• Interface result: The cells below show the filled result based on the first cell.
• What you can do next: You can continue editing, save the file, or run another fill action.

Tips While Using

• Common mistake: If you select only one cell, there is no downward target range to fill.
• Environment note: If you fill formulas, check whether the cell references match your expected result.

2. Fill Right

Feature path: Home tab → Fill drop-down menu → Fill Right

1. Select the source cell and the range that you want to fill to the right.
2. Click the Home tab.
3. Open the Fill drop-down menu.
4. Click Fill Right.
5. The content of the leftmost cell in the selection is copied to all selected cells on the right.

Success Criteria

• Interface result: The cells on the right are filled in batch.
• What you can do next: You can continue formatting or add more data.

Tips While Using

• Common mistake: If the source cell and target range are not selected together, the result may be incomplete.

3. Fill Up

Feature path: Home tab → Fill drop-down menu → Fill Up

1. Select the source cell and the range that you want to fill upward.
2. Click the Home tab.
3. Open the Fill drop-down menu.
4. Click Fill Up.
5. The content of the bottom cell in the selection is copied to all selected cells above.

Success Criteria

• Interface result: The cells above display the filled content.
• What you can do next: You can continue checking data consistency.

Tips While Using

• Common mistake: If the source data is not at the bottom of the selection, the result may differ from what you expect.

4. Fill Left

Feature path: Home tab → Fill drop-down menu → Fill Left

1. Select the source cell and the range that you want to fill to the left.
2. Click the Home tab.
3. Open the Fill drop-down menu.
4. Click Fill Left.
5. The content of the rightmost cell in the selection is copied to all selected cells on the left.

Success Criteria

• Interface result: The cells on the left are filled in batch.
• What you can do next: You can continue adjusting formatting or save the file.

Tips While Using

• Common mistake: Choosing the wrong source-cell position affects the fill direction.

5. Calculate and Enter Ranking

Feature path: Home tab → Fill drop-down menu → Calculate and Enter Ranking

1. Select the data range that contains the values to rank.
2. Click the Home tab.
3. Open the Fill drop-down menu.
4. Click Calculate and Enter Ranking.
5. The ranking result is calculated from the selected data range and entered into the corresponding cells.

Success Criteria

• Interface result: Ranking results appear in the target area.
• What you can do next: You can continue sorting, filtering, or summarizing the data.

Tips While Using

• Membership note: This feature requires WPS Premium.
• Common mistake: If the selected range includes unintended content, review the ranking result before continuing.

6. Fill Blank Cells

Feature path: Home tab → Fill drop-down menu → Fill Blank Cells

1. Select the data range that contains blank cells.
2. Click the Home tab.
3. Open the Fill drop-down menu.
4. Click Fill Blank Cells.
5. Choose whether to fill blank cells with values from above, below, left, or right.

Success Criteria

• Interface result: Blank cells in the selected range are completed in batch.
• What you can do next: You can continue filtering, building summaries, or exporting the worksheet.

Tips While Using

• Membership note: This feature requires WPS Premium.
• Common mistake: Confirm the reference direction before filling so that the result matches your worksheet logic.

7. Enter Current Date

Feature path: Home tab → Fill drop-down menu → Enter Current Date

1. Select the cell where you want to insert the date.
2. Click the Home tab.
3. Open the Fill drop-down menu.
4. Click Enter Current Date.
5. The current system date is inserted into the selected cell.

Success Criteria

• Interface result: The selected cell displays the current date.
• What you can do next: You can change the date format or copy it to other cells.

Tips While Using

• Common mistake: If the cell format is not suitable, you may need to adjust how the date is displayed.

8. To Worksheets in Same Group

Feature path: Home tab → Fill drop-down menu → To Worksheets in Same Group

1. In the current worksheet, select the range that you want to sync.
2. Click the Home tab.
3. Open the Fill drop-down menu.
4. Click To Worksheets in Same Group.
5. The selected range in the current worksheet is copied to the corresponding area in other grouped worksheets.

Success Criteria

• Interface result: The corresponding range in grouped worksheets is updated.
• What you can do next: You can switch to other worksheets and verify the result.

Tips While Using

• Common mistake: Confirm that the target worksheets are already grouped before you run the command.