Dragging down to create a numbered list in Excel? There’s a better way!
Channel: ForeverMore Training
Date: 2023-03-13

You want to create a numbered list in Excel? Most people use the fill handle – input numbers in the first two cells, then drag down with the fill handle to create a sequence of numbers. There is another approach, using the sequence function. This is a great way to create a dynamic numbered list that updates automatically.
Works with the following versions: Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones
Nested functions and autofill are features mentioned in the video. Here are the links to learn more:
Nested functions https://youtu.be/HksyCY5SKKk
The autofill features https://youtu.be/cWh2N-tOCQw