Excel tip to make a dynamic numbered list

In this Excel tip, we'll show you how to create a dynamic numbered list in Excel. This tip will come in handy when you want to create a sequence of numbered items, like a shopping list or a to-do list.

With this Excel tip, you'll be able to create a sequence of items in no time at all! This tip is easy to follow, and will help you to create a dynamic numbered list in Excel quickly and easily!

#exceltips #exceltricks #exceltips

Are you tracking the hours you spend working on projects like this?

[beemerguy]

I would do "+1" at the end of the formula, to invite the reader to write another line, and they'll learn that it auto-sequences

[altinallmuca]

=IF(B1<>0, COUNTA($B$1:B1), "") might do it when your excel doesn`t supprot Sequence formula

[Rice]

It's so pitty that you can't combine array formulas with smart tables. 😕