For Beginners · Lesson 64 of 78

Magical Numbering

Members-only tutorial

Watch the video and get the practice sheet with membership.

Unlock tutorials
Create a sequence of numbers that magically appears as you type in each row. Put this in A1 and start typing in column B: =SEQUENCE(COUNTA(B:B),1,1,1)
5 formulas linked inline Click any highlighted terms to learn more.

<div>0:00 Alright, better sheet members and friends and family. Check out this absolute magic that you can do with sequence . So we're gonna do equals sequence .<br>0:12 How many rows we're doing. Count all. Count A we're gonna do B, colon B. And then columns one. Start one.<br>0:23 Step one. We're gonna get an error right here, but if we start writing something, writing Hello World. Now we have absolute banger.<br>0:36 It's &lt;laugh&gt;. It's actually numbering as we go, right? Like this is pretty cool. This is pure magic. Absolute Basics of Google Sheets How to Add a Series to a Google Sheet

You can spit fire from your fingertips, fingertips all the way down as many rows as you want.<br>0:52 It's just gonna keep numbering them over and over and over. Isn't that cool?</div>

Big Year 2027 calendar: the whole year on one Google Sheet

Free 2027 calendar.Plan all of 2027 on one Google Sheet, free.

Copy it to your Google Drive.

Free. No password, no card. The sheet link shows up right here.