6 Ways to Number in Excel
Since last we spoke I’ve been recording several new long and short form videos. Check out the YouTube Channel if you haven’t.
I’ve also wrapped up training for a marathon I’ll be racing on March 3rd… ????
Now to the sheets…
Do you ever feel lost in Excel? Like you should know a lot but struggle to grasp the basics?
Fear not. Today's tips are all about some fundamentals that will be useful and speed up your spreadsheet work.
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.
Thank you so much!
If you'd like these tips in your inbox, you can sign up for free on my newsletter here: https://got-sheet.beehiiv.com/
I would love to say hi. Here are the best places to find me: