How to Quickly Fill Numbers in Cells without Dragging

What do you do when you have to enter a sequence of serial numbers in a column in Excel? For example, entering numbers 1 to 1000 in cell A1:A1000.

The regular way of doing this is:

  • Enter 1 in cell A1.
  • Enter 2 in cell A2.
  • Select both the cells and drag it down using the fill handle.

Sometimes it may get a bit irritating to drag the fill handle to the last cell which can be many folds below the current cell.

In this tutorial, I’ll show you a faster way to fill numbers in cells without any dragging.

Quickly Fill Numbers in Cells without Dragging

Here are the steps:

  • Enter 1 in cell A1.
  • Go to Home –> Editing –> Fill –> Series.Quickly Fill Numbers in Cells without Dragging Excel - fill Series
  • In the Series dialogue box, make the following selections:
    • Series in: Columns
    • Type: Linear
    • Step Value: 1
    • Stop Value: 1000Quickly Fill Numbers in Cells without Dragging Excel - Series DB
  • Click OK.

This will fill the cell A1:A1000 with the numbers 1 to 1000.

Notes:

  • If you want to fill the numbers in the row instead of the column, select ‘Rows’ in the ‘Series in’ options.
  • If you want to start from a number other than 1, fill that number in cell A1. Also, you can choose a different step. For example, select 2 for getting all numbers with a difference of 2.

You May Also Like the Following Excel Tutorials:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

5 thoughts on “How to Quickly Fill Numbers in Cells without Dragging”

  1. That is all nice, but what if my number need to start with
    0161481 and finish with 0163030. That is impossible to do with fill option.
    I would be happy if someone know how.

    Reply
  2. This is a nice website. I looked at various tutorials and found them to be easy, especially that several examples are also given. I ended up getting the free e-book.

    Reply

Leave a Comment