Welcome to YTUnity

One free SpiderTaz Network account works across every network site.

How to Do a Number Sequence in Microsoft Excel

Max Dalton Guide 2 days ago

Description

In this video I'll show you how to create a number sequence in Microsoft Excel. Numbering rows by hand is slow and easy to mess up, and Excel can do it for you in seconds.

Timestamps:
Introduction: 0:00
Use the Fill Handle: 0:14
Use the Series Window: 1:11
Use the SEQUENCE Function: 2:02
Conclusion: 2:35

Check out my website for other great tutorials about all kinds of technology: https://maxdalton.how/

Support this channel by becoming a member: https://www.youtube.com/channel/UCBbDWMccTJCL0WmbMHNLZIw/join

#excel #microsoftexcel #exceltutorial #techtips #tutorial

Video Transcript:
Step 1. Open your Excel spreadsheet. For this example, I'm using a pull list for a comic book shop, and I want to number each customer in the empty No. column in column A.

Step 2. Click in cell A2, type 1, and then press "Enter." Type 2 in cell A3, and then press "Enter" again.

Step 3. Click and drag to select cells A2 and A3. This shows Excel the pattern you want to follow.

Step 4. Double-click the fill handle, which is the small square in the bottom right corner of the selection. Excel fills the numbers down to the last row of your data. You can also click and drag the fill handle down instead.

This works for other patterns too. If you start with 5 and 10, Excel counts up by 5.

If you want more control, like a specific step or stopping point, use the Series window.

Step 1. Type 1 in cell A2, and then click cell A2 to select it.

Step 2. Click the "Fill" button on the Home tab, which is the down arrow icon under AutoSum in the Editing group on the right side of the ribbon, and then click "Series." The Series window opens.

Step 3. Click "Columns" in the Series in section (Excel selects Rows by default), and make sure "Linear" is selected under Type.

Step 4. Type 1 in the Step value box, type 20 in the Stop value box, and then click "OK." Excel fills in the numbers 1 through 20.

In Microsoft 365 and Excel 2021 or newer, you can also click in cell A2 and type =SEQUENCE(20), and then press "Enter." Excel spills the numbers 1 through 20 down the column. You can add more arguments to set the starting number and step, like =SEQUENCE(20,1,100,10) to count from 100 by tens.

Featured creators

Creators on the SpiderTaz Network

Become a creator →