6 Ways to number in Excel

I write about web development, design and tooling from a solopreneur's perspective. My wife and I are raising four kids, and I enjoy running ultras in my free time.

6 Ways to Number Things

Manual - You’re familiar with this, though you hang your head in shame at how often you use it. This is when you manually type everything in. Don’t worry, we all start here.

Drag - Level 1. At the bottom right corner of an active cell or range you can click and drag down. Excel is pretty smart. It will expand the sequence of numbers (or dates, or days) and fill in the missing values.

Double Click - Now we’re getting up to speed. By double clicking that bottom right corner, Excel will fill down just like when you dragged down. Where it stops will depend on other values in your workbook. If you don’t have other values, or a table you’re working in, this may not work.

Formula - The power of spreadsheets lies behind the scenes in all the gritty, delicious minutia. It’s here where the wild things live. It’s here where we can write custom formulas to do darn near anything. And I do mean anything - someone built a 16-bit CPU inside an Excel workbook recently.
For our purposes, we can simply reference the first cell and add something to it. Then if we drag that formula down just like in option 3, we can quickly expand the sequence of dates.

Sequence - This is an incredibly handy built-in function. It’s like a custom formula, only it’s already baked in to Excel. It allows you to generate sequences of values over a specified number of rows and/or columns. You let Excel know how many of each to use, what value to start with and then what value to increment by. *Bonus: to count down, you can use a negative value in the final “step” variable.

Row - Another nifty function, and lesser known. Row isn’t explicitly for numbering or sequencing things, but we can use it for this. Row will return whatever the numerical value of the current row is. We can use this as is, but if we worry about rows being deleted, we can also explicitly reference a cell using ROW(A1) or something similar. From here we can sequence subsequent rows using one of the above methods if need be.

What's your favorite method?

Thank you so much!

It means a lot that you’ve read this, and I hope it’s informed and/or entertained you for a few moments today!

Would love to say hi. Here are the best places to find me:

📺️ Videos on YouTube

💾 Products on Gumroad

✉️ Connections on LinkedIn

It's been a while since I've posted one of my articles on Hashnode. Never fear - I'll be repurposing some of my content from the past year or so to keep you in the loop!

6 Ways to number in Excel

Comments

More from this blog

How to Make a Lightbox in a Google Sheet

Google Sheets Tutorial – How to Enable Multiple Selection Data Validation Using Apps Script

Excel Tutorial – How to Clean Data with the TRIM() and CLEAN() Functions

Accounting Number Format in Excel – How to Apply it to Selected Cells

6 Ways to Number Things

Thank you so much!

Command Palette

Comments

More from this blog

6 Ways to Number Things

Thank you so much!