79% OFF online library of tutorials for mastering Google Sheets

One time purchase $149

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

About this Tutorial

Very quick interesting little keyboard shortcut where you might not even know it exists. Repeat what you're doing, over and over again.

Video Transcript

 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.

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. You can right click here and insert one below.

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?

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. 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.

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. 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.

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. It's hurting my eyes, but I can do redo as well and command y time and time.

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.

Courses

1

Better Than Happy | Redesign of The Feelings Wheel

Best Header Font Ever

3

Learn to Love Your Sheets

4

Sheet Review! 150 Active VCs by LemonIO

Anika Asks: How To Set Text Overflow All The Time

6

Introducing: Brutal Calendar

Add a Checkbox to Turn on Dark Mode

00:05:10

Create Drop Shadows! This makes your dashboards pretty.

00:12:04

9

Merge Cells for Dashboards

00:05:29

Dark Mode / Better Font Color

00:09:35

11

Better Font Colors

00:02:45

Magical Things You Can do with Checkboxes - Google Sheets

00:12:31

Export Your Beautiful Sheets to PDF

00:04:06

Consider Labels as Opposed to Headers

00:04:02

15

Add Icons To Your Sheets With a Domain Name

00:04:21

16

Coloring Cell Blocks for Others to Enter Data

00:10:30

17

Great Sheets! Corona Hiring Sheet

00:10:43

18

Great Sheets! Community Information Board by Seedtable.com

00:07:35

Roast: Hotel PPC Channel Cost Calculator

00:11:25

Better Header Fonts - Best Fonts To Use In Google Sheets

Rishabh Asks: Conditional Format Whole Row Via Text inside a Cell

00:09:49

Basic Keyboard Shortcuts To Speed Up Your Productivity

00:13:44

23

Basics - 5 Ways to Change Row Height

00:05:08

Anders Asks: Can I Highlight Whole Row if Certain Columns have text?

00:09:31

How to Refer to Other Cells - A1 and R1C1 Explained

00:13:22

26

Change the Default Font

00:03:33

Biggest Flaw In Dashboards with Dark Colors

00:07:45

28

Basics - 4 Ways to Change Column Width

00:05:48

29

Basics - Structure of a Sheet: Index() Row() and Column()

00:06:49

Communicate Better with Gridlines, Border Styles, and Border Colors - Google Sheets

00:08:55

31

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

00:03:03

Create an Auto-Update Sales Chart: Trailing 12 Months

00:09:57

33

Google Sheet Basics - The Absolute Basics

00:09:48

34

Secure Your Sheets by BetterSheets.co

00:11:07

How To Create An AutoFill in Google Sheets

00:06:07

Build a Thermometer for Savings Goals

37

Make Your Lists Spicy Hot in Google Sheets

00:01:47

Restrict Access to a Cell if Another Cell is Blank

39

How to Use Smarket

00:03:28

Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!

00:06:23