How to return a set number of consecutive numbers in Excel How to add input values to make the expression more flexible in Excel We may earn from vendors via affiliate links or sponsorships.

Type the next consecutive number below the last number in your list. For example, if cell G50 contained "120," type "121." Click and drag your mouse across both cells to select them.

It’s worth mentioning that other expressions will work, but I chose this one because the consecutive numbers are a visual clue to what they represent. With the helper column in place, it’s ...

How to use AutoSum in Excel. AutoSum works best when you have a column or row of numbers you want to add up. 1. Click the empty cell underneath the column of numbers that you want to add up.