How to Quickly Fill a Number Series in Excel 2021 by Dragging

27 September 2022

Home » Blogs » Software » Ms Excel » How to Quickly Fill a Number Series in Excel 2021 by Dragging

doesn’t include the option to automatically number data, unlike other applications. However, you can quickly add a sequence of numbers to a row of data by moving the Fill Handle to fill the column.

is a useful function that increases spreadsheet productivity. Based on the interval, type, unit, and value of the user-defined step, it allows filling in the data directly in the selected cell.

TOP TUTORIALS:  How to Repair Windows with Upgrade Using Windows 11 ISO File

How to Use the Fill Handle

An interesting feature used inside spreadsheets is the Fill Handle from . The Fill Handle, a plus sign, is displayed when you select the initial cell and move the cursor to the lower-right corner of the cell range.

Press and drag the Fill Handle to the desired cell while holding down the button to enable auto-load. After the is released, the compartment has been filled.

The default in Microsoft differs from previous versions of Excel. In the 2021 version of Excel, you use the right mouse button to drag it. Whereas in the previous Excel, use the left mouse button.

How to Use Fill Series in Excel 2021

  1. Select the starting cell in the range that you want to fill.
  2. Type the initial value for the series.
  3. Drag the lower right corner of the range you selected using the mouse’s “Right” button.
TOP TUTORIALS:  Listen to Music on YouTube without Videos to Save Bandwidth
excel fill handle
  1. Once in the range you want, release the mouse button. In the options that appear, select ““.
excel fill series

If you want sequential numbers (1, 2, 3, 4, 5… ), simply type the initial number (1) and drag it by using the right mouse button.

And if you want numbers with intervals (2, 4, 6, 8…,), type the numbers 2 and 4. Then select the numbers 2 and 4 and drag them using the right mouse button.

Related Articles


Submit a Comment