How to Quickly Number Cells from 1 to 100000 in Excel Using Fill Series

Learn how to number cells from 1 to 100000 in Excel efficiently using the Fill Series feature or dragging the fill handle.

41 views

To quickly number cells from 1 to 100000 in Excel, select the starting cell and type `1`. Click on the bottom-right corner of the cell to drag down, or use the Fill Series feature: select starting cell, in the 'Home' tab go to Fill > Series > Columns and choose Stop Value: 100000. This will automatically fill the column with numbers from 1 to 100000.

FAQs & Answers

  1. How do I fill a column with numbers from 1 to 100000 in Excel? Use the Fill Series feature by selecting the starting cell, then go to Home > Fill > Series, choose Columns, set the stop value to 100000, and click OK.
  2. Can I quickly number cells without dragging the fill handle in Excel? Yes, you can use the Fill Series dialog to automatically fill large ranges without manually dragging.
  3. What is the Fill Series feature in Excel? Fill Series is a tool in Excel that allows you to populate cells with data following a certain pattern or sequence automatically.

Watch More

For more helpful Excel tips, check out our tutorials on advanced data formatting, formulas, and productivity shortcuts to maximize your spreadsheet efficiency.

  1. Mastering Excel: How to Efficiently Fill a Large Series Learn how to fill large series in Excel with easy step-by-step instructions for efficient data entry.
  2. How to Convert Formulas to Values in Excel Automatically Learn how to automate the conversion of formulas to static values in Excel with a quick and easy method.
  3. How to Fill a Series in a Spreadsheet: Step-by-Step Guide Learn how to easily fill a series in a spreadsheet with our quick step-by-step guide.