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.

If you want to keep the leading zeros in Excel as it is to input numeric data like account numbers, postal codes, phone numbers, etc., this post will show you how.

Open the Excel 2010 files that holds your phone numbers. Click on the cell that you want to change into a series of numbers spread out over several columns, or click on the letter above the column ...