Others

How to Select Multiple Cells and Use the Excel Fill Handle

Anum MushtaqAnum Mushtaq Nov 18, 2026 870 views

Question details

Learn how to select multiple cells and use their existing pattern to fill a series in Excel.

How to Select Multiple Cells and Use the Excel Fill Handle
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.
Before you start

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.

Solution 1Recommended

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.

1
Enter the starting pattern

In a worksheet, enter 1 in A1, 2 in A2, and 3 in A3.

2
Select the cells

Click A1 and drag through A3 to select the range A1:A3.

3
Drag the fill handle

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.

4
Check the result

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.

Continue a series with Excel's fill handle
Try dates and days: You can also enter consecutive dates or Sunday, Monday, and Tuesday in adjacent cells, select them, and drag the fill handle to continue the series.
Fill sequences in WPS Spreadsheets

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. 1. Open a spreadsheet: Open WPS Office, select Spreadsheets, and create a blank workbook or open an existing Excel file.
  2. 2. Enter starting values: Type 1, 2, and 3 into cells A1, A2, and A3.
  3. 3. Select the pattern: Drag from A1 through A3 to select the starting cells.
  4. 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.
Continue number and date sequences with the fill handleOpen and edit Microsoft Excel XLSX and XLS filesWork with a familiar spreadsheet interfaceUse WPS Office for free
microsoft office alternative - wps office

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.