How to Use WPS Fill on macOS

Use WPS Fill on macOS with 8 how-to topics, including Fill Down, Fill Right, Fill Up, and Fill Left; 6 topics are available without membership and 2 are membership-related, and you can jump to each task from the index.

How-to Index

How-to Guide

1. Fill Down

Feature path: Home → Data Processing → Fill → Fill Down

1. Select the cell with source data and the target cells below it.
2. Click the Home tab.
3. Open Data Processing.
4. Open the Fill menu.
5. Click Fill Down.
6. The content of the top cell is copied to all selected cells below.

Success Criteria

• Interface result: The cells below show the same content as the top cell.
• What you can do next: You can continue editing, saving, or applying another fill command.

Tips While Using

• Common mistake: If the target range is not selected together with the source cell, the action only applies to the current selection.

2. Fill Right

Feature path: Home → Data Processing → Fill → Fill Right

1. Select the cell with source data and the target cells to its right.
2. Click the Home tab.
3. Open Data Processing.
4. Open the Fill menu.
5. Click Fill Right.
6. The content of the leftmost cell is copied to all selected cells on the right.

Success Criteria

• Interface result: The cells on the right show the same content as the leftmost cell.
• What you can do next: You can continue formatting or save the file.

Tips While Using

• Common mistake: If the selected range includes cells you do not want to overwrite, their original content will be replaced.

3. Fill Up

Feature path: Home → Data Processing → Fill → Fill Up

1. Select the cell with source data and the target cells above it.
2. Click the Home tab.
3. Open Data Processing.
4. Open the Fill menu.
5. Click Fill Up.
6. The content of the bottom cell is copied to all selected cells above.

Success Criteria

• Interface result: The cells above show the same content as the bottom cell.
• What you can do next: You can review the result or continue with other data-processing actions.

Tips While Using

• Common mistake: Make sure the bottom cell contains the correct value before you run the fill action.

4. Fill Left

Feature path: Home → Data Processing → Fill → Fill Left

1. Select the cell with source data and the target cells to its left.
2. Click the Home tab.
3. Open Data Processing.
4. Open the Fill menu.
5. Click Fill Left.
6. The content of the rightmost cell is copied to all selected cells on the left.

Success Criteria

• Interface result: The cells on the left show the same content as the rightmost cell.
• What you can do next: You can continue entering data or save the worksheet.

Tips While Using

• Common mistake: Check whether the existing data on the left needs to be kept before you run the command.

5. Enter 123 Sequence

Feature path: Home → Data Processing → Fill → Enter 123 Sequence

1. Select the data range.
2. Click the Home tab.
3. Open Data Processing.
4. Open the Fill menu.
5. Click Enter 123 Sequence.
6. WPS calculates the ranking for each value in the selected range and writes the result into cells.

Success Criteria

• Interface result: Ranking results appear in the selected range.
• What you can do next: You can continue sorting, filtering, or analyzing the data.

Tips While Using

• Membership: This feature requires WPS Premium.
• Common mistake: Confirm the selected range first so unrelated data is not included in the ranking.

6. Fill Blank Cells

Feature path: Home → Data Processing → Fill → Fill Blank Cells

1. Select the data range that contains blank cells.
2. Click the Home tab.
3. Open Data Processing.
4. Open the Fill menu.
5. Click Fill Blank Cells.
6. Choose whether to use the value above, below, left, or right to complete blank cells in batches.

Success Criteria

• Interface result: Previously blank cells are completed in batches.
• What you can do next: You can continue filtering, summarizing, or exporting the data.

Tips While Using

• Membership: This feature requires WPS Premium.
• Common mistake: Different fill directions produce different results, so confirm the rule before applying it.

7. Enter Current Date

Feature path: Home → Data Processing → Fill → Enter Current Date

1. Select the target cell or cell range.
2. Click the Home tab.
3. Open Data Processing.
4. Open the Fill menu.
5. Click Enter Current Date.
6. The current system date is inserted into the selected cells.

Success Criteria

• Interface result: The target cells display the current system date.
• What you can do next: You can format the date or save the file.

Tips While Using

• Common mistake: If the system date is incorrect, the inserted result will also be incorrect.

8. To Same Group Worksheets

Feature path: Home → Data Processing → Fill → To Same Group Worksheets

1. In the current worksheet, select the cell range you want to synchronize.
2. Click the Home tab.
3. Open Data Processing.
4. Open the Fill menu.
5. Click To Same Group Worksheets.
6. The selected content from the current worksheet is filled into the corresponding range in other grouped worksheets.

Success Criteria

• Interface result: The corresponding range in grouped worksheets shows the same content.
• What you can do next: You can switch to other worksheets and verify the synchronized result.

Tips While Using

• Common mistake: Make sure the target worksheets are already grouped before you run the command.