How to Select Multiple Cells and Use the Excel Fill Handle
Question details
Learn how to select multiple cells and use their existing pattern to fill a series in Excel.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user wants to extend a sequence of numbers, dates, or list items without entering each value manually.
- Observed behavior
- Excel uses the selected starting values to continue a recognizable pattern when the fill handle is dragged.
Enter at least two starting values in adjacent cells to make the intended pattern clear. Make sure the cells you plan to fill are available, because dragging into them can replace existing content.
Continue a series with Excel's fill handle
Select adjacent starting values and drag the fill handle to extend a number, date, or recognized list pattern.
In a worksheet, enter 1 in A1, 2 in A2, and 3 in A3.
Click A1 and drag through A3 to select the range A1:A3.
Move the pointer to the small square at the lower-right corner of the selection. When it becomes a cross, drag down to A6 and release.
Confirm that A4:A6 contain 4, 5, and 6. If needed, select the Auto Fill Options button beside the filled range and choose the appropriate fill option.

Create a custom list for Excel AutoFill
Use a custom list when you repeatedly need to fill a sequence that Excel does not recognize automatically.
Continue cell patterns in WPS Spreadsheets
Use the fill handle in WPS Spreadsheets to extend a sequence from adjacent cells without typing each value.
- 1. Open a spreadsheet: Open WPS Office, select Spreadsheets, and create a blank workbook or open an existing Excel file.
- 2. Enter starting values: Type 1, 2, and 3 into cells A1, A2, and A3.
- 3. Select the pattern: Drag from A1 through A3 to select the starting cells.
- 4. Extend the series: Drag the small fill handle at the lower-right corner of the selection down to A6, then check that the sequence continues.

Frequently Asked Questions
Why should I select multiple cells before dragging the fill handle?
Multiple starting values show Excel the intended pattern. For example, select cells containing 2 and 4, then drag the fill handle to continue with 6, 8, and so on.
Can I fill a series horizontally instead of vertically?
Yes. Select the adjacent starting cells, then drag the fill handle to the right or left across the row.
What if Excel copies a value instead of continuing the series?
Select multiple cells that establish the pattern and drag again. You can also select the Auto Fill Options button beside the filled range and choose Fill Series when it is available.
How do I enable the fill handle in Excel?
In Excel for Windows, go to File > Options > Advanced and check Enable fill handle and cell drag-and-drop, then select OK.
Can Excel continue my own list of names?
Yes. In desktop Excel, create a custom list in the custom list settings. Then enter a list item in a cell and drag its fill handle to continue the list.




