6 Ways to Number in Excel

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:

要查看或添加评论,请登录

Eamonn Cottrell的更多文章

  • How to Use VBA

    How to Use VBA

    Create a Workbook Table of Contents I put off learning VBA for a long time. Like 10 years long.

    2 条评论
  • How to Use the IF function

    How to Use the IF function

    Don't let your spreadsheet intimidate you. We’re all familiar with the logic behind IF().

  • Apps Script Form Submission to Google Calendar

    Apps Script Form Submission to Google Calendar

    Since last we spoke I’ve… Set a new personal marathon record (3:14:30) Played some old school Zelda with my kids (SNES)…

    4 条评论
  • Sort in a Cell

    Sort in a Cell

    Get these handy tips in your email by subscribing to my free newsletter at https://got-sheet.beehiiv.

    2 条评论
  • Apps Script All Day Events

    Apps Script All Day Events

    Since last we spoke I’ve made some short videos… Microsoft table breaks mobile view Combine Excel Data onto New Lines…

    2 条评论
  • Name Those Ranges

    Name Those Ranges

    Since last we spoke… It’s snowed 7+ inches at our house! The kids are in heaven. I’ve driven to Mississippi and back…

  • Double XLOOKUP

    Double XLOOKUP

    Since last we spoke I’ve… Run my first 5K in over a decade Run a 50K Started writing a book… Now to the sheets… Double…

  • Time Zones in Google Sheets

    Time Zones in Google Sheets

    Since last we spoke I’ve… Run 40 miles up and down Boring Road Built an open source memory verse website Hung Christmas…

  • Deck the Halls With QUERIES

    Deck the Halls With QUERIES

    Hi there! Since we last spoke I've Run a couple half marathons (of my own making) Analyzed a collectible card game that…

  • Abuse Your Spreadsheet

    Abuse Your Spreadsheet

    AKA: How to use your spreadsheet to do non-financial, cool challenges. The Palindrome Challenge Since last we spoke…

社区洞察

其他会员也浏览了