Stop Dragging in Excel, there is a BETTER way! @chandoo_
Stop Dragging in Excel, there is a BETTER way!  @chandoo_
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, there is a BETTER way!UNPIVOT: Data Cleaning Power Tricks πŸ’‘Powerful trick to get data from any folder in Excel (works even after renaming!)Excel formula to get CLOSEST Matching ValueIntroducing Free Data Analyst Course - SQL / Excel / Power BI / Python3 Things I do in my new Job to Succeed as a Data Analyst3 Powerful Data Slides for your NEXT Presentation (Free PPT File)Excel PROs use these hidden features to work faster πŸš€Test Your SQL Skills With These Real Interview Questions!FILTER Function Hacks That Save Hours of WorkPower Query - Beginner to PRO Masterclass in 30 minutesThe little known BYROW function changes how you write formulas in Excel 🀫
Chandoo |

Stop Dragging in Excel, there is a BETTER way!

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER