How to Autofill a Sequence of Numbers in Excel With or Without Dragging

👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺.
Thank you! 👍👍
In this video I demonstrate how to quickly create a sequence of numbers in Excel. To achieve this you need to create a fill series. There are two types of fill series:

1) A linear series
2) A growth series

A fill series can be created by dragging with your mouse or by using the Series dialog.

Table of Contents:

00:00 - Introduction
00:06 - Use the AutoFill Options button to create a linear series
00:40 - Use the CTRL drag method to create a linear series
01:13 - Increment by a value other than one
01:51 - Create a growth series using the right-click mouse method
02:36 - Create a growth series using the Series dialog
03:19 - Use a stop value
------------------------

[marilyndevonish]

That used to work the drag, and I've been doing for for a few years, however it now longer does for me, but your 'Series' tip has solved the problem. Thank you!

[frasermacpherson]

Thank you for your very clear and easy instructions.

[MichaelKlein-wero]

OMG! Thank you! I needed the auto fill with increment!!

[jeongwonc]

Good tip Chester! Something new in Excel all the time!

[Sunshine]

Thank you so much! I don’t remember having to click ctrl in the past.

[seatwarmer]

This was an AMAZING & informative video! Thank you!!! A+++

[flavel]

I was panicking on a spreadsheet and about to head into a meeting. This really came in handy! Thank you!

[wayneedmondson]

Thanks Chester. Great summary of the multiple methods. Knew a few.. learned a few. Thanks for demonstrating. Thumbs up!!

[countduckula]

Thanks Chester, I learnt something a new useful thing I can do on Excel.

[abdelkrimmesaiahmed]

Thank you Chester for this great video

[IvanCortinas_ES]

Thumbs up! Good explanation. Thank you for the trick "Linear Trend" and "Growth Trend" option.

[mohammadafsari]

Hi Mr.Chester, how can fill series filter column ? Tnx

[polygonmap]

Great video! I once learned the way to fill sequence number only when we fill the column besides it but then forgot how. Do you happen to know how to do it?

[smhameed]

Is there anything we can do it in points

[HARSHAKNV]

How to do this without using the mouse/trackpad. Is there any keyboard shortcut for this?

[dee]

my new excel version doesn't have that, so frustrating, how do i use it on new excel ? my icon shows quick analysis, not auto fill can i change it to auto fill ?

[MsTinkr]

Interesting, I didn't know about the growth trend option. How about after you've created lists through data validation? The cursor option to drag doesn't come up. Is there another way around this?

[iTUstaad]

I want to fill the series of a different writing pattern, like No. ADMIN/-100 of 2022, next should be automatically ADMIN-/101 of 2022, then 102, 103, how to do it?

[dumbjack]

what do you do when this doesn't work and all of the advance settings in Edit are checked?

[timucinpusat]

hi, well How to Autofill a Sequence of Numbers which is in the middle of sentence in Excel With Dragging