Uploaded December 2024 | Updated November 2026, 1 day ago
Stop dragging in Excel. Use this better and improved way to get what you want.
Introducing the SEQUENCE() in Excel. It puts FUN in Functions. We can use it to get numbers, texts, dates and even improve your formulas.
5 AWESOME examples to get started:
β¬ SEQUENCE(1000) - makes 1000 numbers row-wise
β‘ SEQUENCE(,1000) - makes 1000 numbers column-wise
π SEQUENCE(10, 10) - makes 10x10 grid of numbers, 1 to 100
π ="INV" & SEQUENCE(1000) - makes 1000 invoice numbers, starting with INV1, INV2... INV1000
π SEQUENCE(365,, "1-JAN-2025") - makes all the 365 days of 2025
Video topics:
0:00 - Why dragging is bad for you
0:27 - How to make 1000 numbers quickly!
1:16 - Adding prefixes like INV for invoice numbers
2:15 - Using SEQUENCE to make all the dates of 2025
2:55 - Six packs on the fingers π
3:12 - My absolute favourite trick with spill ranges
4:14 - How to add up all the spilled values
πΊ Watch next:
============
Using # operator in Excel (Spill ranges) - youtu.be/kR6czKY4FEw
Stop using Pivot Tables - youtu.be/SPFQX82X03Q
I don't use VLOOKUP anymore! - youtu.be/DDlZXXEI1bU
Excel LAMBDA function is a must have - youtu.be/YrMCkE59ef4
FILTER() Function is a must have - youtu.be/JuTdj2j-9Kg
~
If I can sing πΆ about it:
We don't drag any more...
We don't drag any more
Like we used to do.
#chandoo #chan2 #exceltips
Stop dragging in Excel. Use this better and improved way to get what you want.
Introducing the SEQUENCE() in Excel. It puts FUN in Functions. We can use it to get numbers, texts, dates and even improve your formulas.
5 AWESOME examples to get started:
β¬ SEQUENCE(1000) - makes 1000 numbers row-wise
β‘ SEQUENCE(,1000) - makes 1000 numbers column-wise
π SEQUENCE(10, 10) - makes 10x10 grid of numbers, 1 to 100
π ="INV" & SEQUENCE(1000) - makes 1000 invoice numbers, starting with INV1, INV2... INV1000
π SEQUENCE(365,, "1-JAN-2025") - makes all the 365 days of 2025
Video topics:
0:00 - Why dragging is bad for you
0:27 - How to make 1000 numbers quickly!
1:16 - Adding prefixes like INV for invoice numbers
2:15 - Using SEQUENCE to make all the dates of 2025
2:55 - Six packs on the fingers π
3:12 - My absolute favourite trick with spill ranges
4:14 - How to add up all the spilled values
πΊ Watch next:
============
Using # operator in Excel (Spill ranges) - youtu.be/kR6czKY4FEw
Stop using Pivot Tables - youtu.be/SPFQX82X03Q
I don't use VLOOKUP anymore! - youtu.be/DDlZXXEI1bU
Excel LAMBDA function is a must have - youtu.be/YrMCkE59ef4
FILTER() Function is a must have - youtu.be/JuTdj2j-9Kg
~
If I can sing πΆ about it:
We don't drag any more...
We don't drag any more
Like we used to do.
#chandoo #chan2 #exceltips










