How to Make Excel Continue to Count Up for Each Row. Entering a series of sequential numbers into an Excel spreadsheet, one per row, can be a time-consuming and repetitive task.

Select a range, such as a row, and then use AutoSum to automatically sum all values in the row. You also can click an empty cell near the row, and then allow AutoSum to estimate the expected range.