You can see we've entered January and March, but we want to enter February. We want to insert it here. We want to insert three rows. How do we do this? I'm going to show you how to insert one row, which you might know. You can just do control click or right click, insert row one above or one below. The trick is if you want to insert three rows, we need to select three rows. We're going to select three rows, right click, insert three rows below, and here we can select February now. So any time we want to insert multiple rows, we just need to select that many rows and we can insert above or below. You can see this insert for, insert for above or below here. you're constantly doing this and you want to automate it, we can record this as a macro . Extensions, macros, record macro. How to Insert Multiple Rows in Google Sheets (Easy to Hard) How To Add Columns in Google Sheets How to Insert Multiple Rows in Google Sheets (Easy to Hard) How To Insert Row Under Header Automatically

We're going to use a relative reference because we probably don't want to insert the rows in the exact same space, but wherever our cursor is. We're going to record this macro . We're going to make sure our things are selected. We're going to insert three rows below. We're going to hit save. Insert three rows below and save. Now, wherever our cursor is, go to extensions, macros, insert three rows below. You can see now every time we do that, we insert three rows below. There you go. That's how to insert multiple rows and even do it repetitively. If you're looking to get more out of your Google Sheets than you ever have before, do more with Google Sheets than you ever thought of. Subscribe here on YouTube to better sheets How to Insert Multiple Rows in Google Sheets (Easy to Hard) How To Add Columns in Google Sheets How to Insert Multiple Rows in Google Sheets (Easy to Hard) How To Insert Row Under Header Automatically