How to Fill a Value Down to the End of an Adjacent Range in WPS Spreadsheets
Question details
The user wants to copy a value from cell B1 down to the last populated row next to data in A1:A400 without overshooting the adjacent range.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A value is entered in B1, and column A contains contiguous data from A1 to A400. The user needs that value repeated beside every populated row in column A.
- Observed behavior
- Using Ctrl+Shift+Down selects to the bottom of the worksheet rather than stopping at the adjacent data range, so it does not reliably limit the selection to A1:A400.
Enter the value in the first cell and check the adjacent data column for blank cells. If the adjacent range has blanks, the fill handle stops at the first blank.
Double-click the fill handle to fill down alongside adjacent data
Use this method when the adjacent column is contiguous and you want the fastest mouse-based fill.
The fill handle is the small square in the lower-right corner of the selected cell. In WPS Spreadsheets, double-clicking it automatically detects the boundary of the adjacent populated range and copies the active cell down to that boundary.
Click cell B1, the cell that already contains the value you want to copy down.
Move the pointer to the small square in the lower-right corner of cell B1 until the cursor changes to a black cross.
Double-click the fill handle. WPS Spreadsheets fills the value down alongside the contiguous data in column A.
Use the Fill Down command to select an exact range
Use this method when the adjacent data contains blanks or when you need to fill a specific range such as B1:B400 without relying on automatic detection.
Fill a Value Down an Adjacent Range with WPS Spreadsheets
WPS Spreadsheets lets you fill a value down to the end of an adjacent range instantly by double-clicking the fill handle. You can also select an exact range and use Home > Fill > Down or Ctrl+D.
- 1. Open the workbook: Open the Excel workbook in WPS Spreadsheets.
- 2. Select the first cell: Select cell B1 containing the value you want to fill down.
- 3. Locate the fill handle: Move the pointer over the fill handle in the lower-right corner of cell B1.
- 4. Double-click the fill handle: Double-click the fill handle to fill down alongside the adjacent data in column A.
- 5. Save the workbook: Press Ctrl+S to save the workbook.
Frequently Asked Questions
Why does Ctrl+Shift+Down go to the bottom of the worksheet instead of stopping at A400?
Ctrl+Shift+Down selects to the last used cell in the current column. If column B has no data below B1, WPS Spreadsheets may jump to the worksheet bottom. To stop at the adjacent range, double-click the fill handle or select B1:B400 manually.
What should I do if there are blank cells in column A?
Double-clicking the fill handle stops at the first blank. Select the exact range in the Name Box, then click Home > Fill > Down or press Ctrl+D.
Can I fill down without using the mouse?
Yes. Type B1:B400 in the Name Box, press Enter, then press Ctrl+D or use Home > Fill > Down.
Will this technique work with a Microsoft Excel file opened in WPS Office?
Yes. WPS Spreadsheets supports .xlsx, .xls, and .csv files, so you can use the same fill handle and Fill Down commands on Excel workbooks.
