Academy ↓
Hey there stranger!
Sign up to get access.
Use Cmd + Y To Do It Again, and Again, and Again
About this Tutorial
Video Transcript
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
Better Than Happy | Redesign of The Feelings Wheel
How Starter Story Designs Data
Learn to Love Your Sheets
Best Header Font Ever
Sheet Review! 150 Active VCs by LemonIO
Anika Asks: How To Set Text Overflow All The Time
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
Merge Cells for Dashboards
00:05:29
10 Things I Hate About Your Spreadsheets
Dark Mode / Better Font Color
00:09:35
Better Font Colors
00:02:45
Magical Things You Can do with Checkboxes in Google Sheets
00:12:31
How To Export Your Beautiful Sheets to PDF
00:04:06
Consider Labels as Opposed to Headers
00:04:02
Add Icons To Your Sheets With a Domain Name
00:04:21
How To Color Cell Blocks So Others Enter Data Easily
00:10:30
Great Sheets! Corona Hiring Sheet
00:10:43
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
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
Change the Default Font
00:03:33
Biggest Flaw In Dashboards with Dark Colors
00:07:45
Basics - 4 Ways to Change Column Width
00:05:48
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
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
Google Sheet Basics - The Absolute Basics
00:09:48
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
Make Your Lists Spicy Hot in Google Sheets
00:01:47
Restrict Access to a Cell if Another Cell is Blank
How to Use Smarket
00:03:28
Combine Data from a Tab and a Totally Different Sheet | ImportRange and Curly Brackets!
00:06:23
Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!
00:53:31
Topics