Join 400,000+ professionals in our courses here 👉 [ Ссылка ]
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: [ Ссылка ]
🌍 My Online 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!: [ Ссылка ]
Shorts video version: [ Ссылка ]
👕☕ Get the Official XelPlus MERCH: [ Ссылка ]
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: [ Ссылка ]
📚 Excel RESOURCES I Recommend: [ Ссылка ]
🎥 GEAR I use: [ Ссылка ]
More resources on my Amazon page: [ Ссылка ]
🚩Let’s connect on social:
Instagram: [ Ссылка ]
Twitter: [ Ссылка ]
LinkedIn: [ Ссылка ]
👉 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
