5 Excel Tips for Easy Number Lists

Add to Favorites
Author: | Edits: don

How to make a list of numbers in Excel? This tutorial covers 5 tips and tricks for making a numbered sequence almost instantly.

I show you how to do this for small lists, for big lists, for lists that span columns, for lists that span rows, for lists that increment by 1, and for lists that increment by a custom amount.

Two of the tips in this Excel tutorial also cover making numbered lists that can be used within more advanced formulas and functions in Excel.

This tutorial also covers using the sequence function and how to freeze the numbers from that function within the worksheet.

 

 


Downloadable Files: Project File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
5 Best Tips for Tables in Excel (To Make You a Pro!)
Tutorial: Speed up your workday with these 5 great Table Tips for Excel! These tips make it easier ...
5 Tips for Passing Values to Macros (VBA) - Beginner to Advanced
Tutorial: VBA Course Learn 5 simple tips for how to send values from one macro to another macro in ...
5 Simple Tips for Making BETTER Macros in Excel!
Tutorial: 5 ways to make better Macros in Excel - fewer errors, smoother coding, less fuss! These 5...
5 Tips for Evaluating Complex Formulas in Excel
Tutorial: 5 simple tips to evaluate any complex formula in Excel! These tips combine to give you th...
Excel Formatting for Zip Codes and Phone Numbers
Tutorial: Display numbers in Excel as zip/postal codes and phone numbers in order to make them easi...
ARRAYTOTEXT() Function Excel - 5 Practical Examples
Tutorial: 5 Practical uses of the ARRAYTOTEXT() Function in Excel. It works well for creating nice...
Tutorial Details
Downloadable Files: Project File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course