Avoid Dragging Down for Numbered Lists in Excel

Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-courses

You want to create a dynamic numbered list in Excel? You have different ways of creating numbered lists. The one most people use is to input numbers in the first two cells and then drag down the fill handle to fill up the next sequence of numbers. That's not always the best approach. In this video, I'll show you 3 reasons why you don't want to just drag down to create a numbered list in Excel. Especially if you have long repeated lists that frequently change. In this case, it's much better to create a dynamic solution that updates automatically. I'll show you how to use the SEQUENCE function in Microsoft Excel to do just that. You'll also learn how to combine SEQUENCE with Excel's custom number formatting to get text before the numbers for example "No.1", "No.2" etc.

⬇️ Download the workbook here: https://pages.xelplus.com/numbered-lists-file

🌍 My Online Courses ► https://www.xelplus.com/courses/

00:00 Creating Automatically Numbered Lists in Excel
00:09 3 Reasons Not To Drag
01:05 How to Use SEQUENCE
03:14 Wrap Up

🎬 LINKS to related videos:
Breaking News! We FINALLY get the Excel functions we've been Wanting!: https://youtu.be/VWcLM6_Q_00

Shorts video version: https://youtube.com/shorts/JZewxiKFplk

👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

📚 Excel RESOURCES I Recommend: https://www.xelplus.com/resources/

🎥 GEAR I use: https://www.xelplus.com/resources/#gear

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

🚩Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#Excel