How to Generate Random Number Series in Excel

Today, we’ll go over simple ways to create random number series in Excel—perfect for tasks like simulations, testing, or generating sample data. If you’re already comfortable with these techniques, feel free to skip this edition.

For everyone else, let’s dive in and learn some quick methods to make data generation a breeze, helping you save time and boost productivity in Excel!

Stop getting ghosted on deals. Get SOC 2 compliant with Delve.

You're getting ghosted by your biggest deals. Days are ticking down and you need to get SOC 2 done before the Q4 winter. With Delve’s AI‑powered platform, you can complete SOC 2, HIPAA, and any other certification in just days—often in under 15 hours. Our customers move at Mach 2:

Lovable → Zero to fully SOC 2 compliant in just days

Micro1 → Unlocked millions in enterprise pipeline with minimal engineering time

Bland → Secured SOC 2 compliance and unlocked $500 K ARR within seven days

Already on another platform? We’ll handle your migration at no extra cost. Join hundreds of fast‑growing companies who trust Delve to eliminate downtime and accelerate deals.

Because there’s nothing scarier than losing a deal to a missing SOC 2.

The process is as follows,

1. Open Excel and Type the First Number to Start the Series

2. Go to “Fill”

3. Select “Series”

4. Choose “Columns” and Type the End number of the Series in this Case 111.

Tip: You may also choose the different types of Series with different frequencies.

Tired of your inbox being overwhelmed by newsletters? With Meco, your favorite reads are neatly organized in a clean, distraction-free space, making it easy to stay on top of the content you love.

Try Meco today—it’s free!

5. Follow the similar process for the Second Series as well

We are Done. Two Random Data Series is Ready.

And that’s how you can quickly generate random number series in Excel, whether for simulations, data sampling, or testing purposes. Using these methods, you’ll have flexible, randomized data ready for analysis in no time.

We Value Your Feedback

Was this featured story helpful? Rate it, and let us know how we can improve.