Use Cmd + Y To Do It Again, and Again, and Again

<div>&nbsp;Hey, I wanted to share with you a very quick interesting little keyboard shortcut where you might not even know it exists. And if you do, you probably stumbled upon it. So, if I have some say data here, data one and data two I'll show you how I use this incredible thing. And actually this came up in a.<br><br>Question. Someone asked this week, they asked, you know, how can I add a number of rows of actually four rows between each of these? Say I have, you know, some data and I want to add four rows. So how you do that right, is you can get this outta the way. Absolute Basics of Google Sheets 3 Most Important Keyboard Shortcuts

You can right click here and insert one below.<br><br>And then you probably looked at this, you probably see there's an undo and a redo . Redo usually only comes into place when you undo something and you want to do it again. But redo also works in just repeating the last thing you did. And I'll show you. So we just, the last action we took was to add a row here, right?<br><br> Insert row . So if I hit command, why again, it is gonna insert a row and it will insert relatively. Relative to wherever I am. So I can insert a row here and I can do this four times. How do I insert emojis into Google Sheets? How To Insert Row Under Header Automatically

I can even go from the bottom, 1, 2, 3, 4, 1, 2, 3, 4, 1, 2, 3, 4, and very quickly, insert four rows. Right there. And that task is done relatively much quicker than having to go here.<br><br> Insert row below, click here, insert row below. We don't wanna do that. We can just do Command Y or redo whatever. If you're on a non Mac, you can, it's probably control y. This is goes along with command C for copy command V for paste, command Z for undo and command, Y for redo . How do I insert emojis into Google Sheets? How To Insert Row Under Header Automatically

You can use this for formatting as well if you want to say, okay, I want this to be this color and I want it, I want 'em all, but they're all separate.<br><br>Places I can do that here, here and now. I'm just using command Y to redo the same thing again and again and again. I can do the if I want, want to highlight some sort of interesting dashboards or data , weird colors, but these, they're really hard to read. 80 Years In 1 Spreadsheet How to Add Alternating Row Colors

It's hurting my eyes, but I can do redo as well and command y time and time.<br><br>And that's how you use command Y to pretty much do something and again, and again and again, and maybe make your life a little bit easier with Google Sheets. Bye.</div> No More Google Sheet Tricks How to Undo in Google Sheets