Academy ↓
Hey there stranger!
Sign up to get access.
How to Record Macros
About this Tutorial
Featured Formulas
Video Transcript
Every single thing I needed to do at a row, at a column, insert this, split this, I had to Google every single one. But Google Sheets and Google has made it incredibly easy to figure this stuff out because you can record macros. Now. When I first started, this didn't exist. The learning curve was so steep, and now they flattened that learning.
and now you can learn so much really quickly by just knowing how to record macro. So one of the things that I do a lot in, in Google Sheets and we all do is like keep track of things maybe every month or every week, uh, or every day. And if, if you're tracking something every month, you have, you know, January, February, March.
and you have what you're tracking. Maybe it's follow account or it's sales or it's revenue. Um, and, and month to month, you're literally only working one time every month. So 12 times a year you're coming in here and, and doing this, but sometimes you're doing it 52 times a year, right? Every week or 250 times.
If you have to do five days a week, um, if you're doing, if you're. adding like together revenue every day. Uh, you have to literally seven days a week, maybe some of those days you have to do three times, and then the other day you do once, you know, we end up going 25 more times into this document if we're doing this daily, uh, per year.
So here's something that happens is right, we go to the far left and we know every single Google shoot we ever start has 26 rows, right? It goes to. and it has a thousand rows, right? But sometimes we don't need those thousand rows. We need like 200 columns. And so when you're adding a column, and this is what we're gonna do, we're gonna add columns today, and this is gonna show you how to record a macro.
Um, you c you go up here, you, you, uh, can delete columns, right? You can insert one to the right if you, uh, highlight every. What is that? Six columns you can insert six to the right. So what? What happens is like you're end up like, oh, I know I have to get a column for every day of the year. Oh, I go over here and like this takes a long time.
I have to like insert 22 and then I have to count, you know, time and time again. Here we can even see all, we can look at the column number, right? Sometimes we have to do the math, right? We have to be like, okay, az, how many, how many columns are in az? But actually, if you do column, this is like a super easy to way to count the columns.
Uh, you can tell, okay, this is column two. So if we know, oh, we have. Today, maybe today's data, and then we have column three, but we really want that to be one. Okay, so let's do minus two. So we now have one, and then we have 25 columns. Here we need 365. So how would we do that? Right? We would insert right, insert, right?
Oh my God, it's this taking forever. Here's how you record a macro. You go up to tools, macro. Record macro click. Now we're already recording the macro, so all I'm gonna do is go click. I'm gonna insert one to the left. That's just what we're doing right now, and that's it. Safe. Let's say insert row. Now we can even create a shortcut if we want to make that a keyboard shortcut.
Um, we can do that. Let's do that. Insert row to left. Save. So now all I'm gonna do is, hold on. I'm gonna do command option shift one, and now it's running. Oh, this is what you're gonna have to run into every single time you create a document with a script attached. You just have to get it to, for permission to run every each start at the beginning.
So you'll do that once, run into this, click that, and then yes, I want to allow. and now sh command option shift one, and it's running the script. Then it'll say Finish script. Okay, let's do that again.
And every time we do that, we're adding a row. We know that because these column numbers are going up, right? What's really cool too, is we can manage them. So in the next video I'm gonna show you how to edit this. Um, but I just wanted to get that really quick to you. You can even do one to the right. So you can go up to tools, macros, record, macro insert Right.
Save, insert column to right. Two, safe. Now we have a nifty little keyboard shortcut to the left. One to the left, and one to the right. One to the right. And see each one is adding. We can go here. Um, here's one thing. If you are using this macro to add like hundreds of columns, what I would suggest first.
And this is a pitfall you're gonna run to. Your sheet will slow down incredibly because it has a thousand rows. Many times when we're, we're taking, you know, daily data, we're not, we don't need a thousand rows, uh, a thousand rows. So what I would do is delete that, delete all those, and now we can add a bunch of rows.
And in the next video I'm gonna show you how to edit macros. Uh, and it's gonna be really, really cool cuz we're gonna be adding like, not a thousand, but like 10 columns at a time or a hundred columns at a time. It's gonna make our job like so much faster, bite.
Courses
Why Code in Google Sheets? - Learn to Code in Google Sheets Part 1
Tips to Navigating Thousands of Lines of Code In Apps Script
How to Write a Function - Learn to Code in Google Sheets Part 2
From Sheet to Script And Back Again - Learn to Code In Google Sheets Part 3
Copy That, From One Sheet to Another - Learn to Code in Google Sheets Part 4
Now Do It Every Damn Day - Learn to Code in Google Sheets Part 5
Wrap Your Mind Around This - Learn to Code in Google Sheets Part 6
Write Your First Script
00:08:31
How to Record Macros
00:06:20
How to Edit a Macro
00:08:22
How to Trigger Macros Daily
00:06:58
Automatically Uncheck A Daily Checklist
How do I reference a different spreadsheet in Apps Script?
Sheet Stories / Video Notes + ADDED: Email Notifications
00:00:00
Fast FAQS
ChatGPT Clone in Google Sheets Part 2
Create an Internal Google Sheets Add-on
Why Different Cell References in AI Integration in Sheets?
Show Sheet Tabs Based on Edit
Add Title Case to Google Sheets
Getting Started Coding in Apps Script
How to Power Testimonials with Google Forms and Sheets
Seek Errors When Coding Apps Script
Think Like a Programmer: Develop The Mindset of an Apps Script Coder
ChatGPT Clone in Google Sheets Part 1
Embed a Number in a Website from a Google Sheet
Create Navigation Like A Book or Presentation
Add Click Tracking To Your Google Sheets | Bitly in a Google Sheet
00:29:08
Hold a Giveaway Raffle in a Google Sheet
Capture Emails from Website Form to a Google Sheet (Without Zapier)
Embed a Headline in a Website from Google Sheets
Quickstart Tutorial OpenAI API in Google Sheets
Create a new Spreadsheet from just a Name in a Sheet.
00:05:21
Bjarne Asks: Can I show the Last Time of the Last Edit in a sheet?
00:05:43
Email Yourself a Cell from a Google Sheet, Every Day
OpenSea Data Inside Sheets
Create an Email Campaign Stats Calculator
00:35:13
Twitter App Clone in a Google Sheet
Dylan Asks: How to Automatically Delete Rows If Cell Contains Value
Highlight Row as You Move Your Cell Selection
Create a Timer with Apps Script
LinkTree in a Google Sheet
00:11:22
Password Protecting Data In a Google Sheet
Automatic Weekly Backup of Google Sheets
Create a CPM Custom Function (Create Better Calculators!)
Move Entire Row when a Cell is changed to "Yes" - The $75,000 Google Script
00:12:29
What Can You Automate in Google Sheets? Every single trigger available to Google Sheet users
Sync Two Tabs Without ImportRange()
Google Sheets Stories? No! But we'll add timestamped video notes to your google sheets.
00:00:00
Password Protecting Data In a Google Sheet Part 2 The Basics
Benoit Asks: How to Convert Case
00:07:35
Learn to Code in Google Sheets, For Programmers
Add a Checkbox to Turn on Dark Mode
00:05:10
Write Your First Script
00:08:31
Find Keywords in Any Column. Create quick search dropdown to find keywords
00:09:37
Basic CRM - Add a Powerful Script To Move Row Based on Status
How To Improve: 1,000 Business ideas: Business Idea Generator
00:11:20
Let's Make a Bookmarklet!
00:12:37
Troubleshooting Bitly in a Google Sheet Script
00:07:07
Unique Features - Design a Better Dashboard Part 2
00:04:13
How To Set Up Stripe Webhook to Google Sheets with Google Script
00:22:10
How to Edit a Macro
00:08:22
Sheet Stories / Video Notes + Clear 24 Hour Old Videos
00:35:10
Add A Timestamp to Task Lists (without Now Formula)
00:07:44
Make your Custom Functions Like Native Functions | Custom Function Autocomplete
00:17:58
Create a Changelog Between 2 Cells Custom Function | To learn Double For Loop
00:23:26
New Syntax for WhatChanged Formula in Google Script
00:07:14
How to Record Macros
00:06:20
2 Ways to Delete Lines Quickly (CAREFUL, it's a script!)
00:09:53
Deep Inside Dark Habits Google Script
00:18:54
How to Trigger Macros Daily
00:06:58
5 Ways to Create Coupon Codes | Create UUIDs
Create a Radio Button From Checkboxes Using Google Apps Script
00:15:01
Topics