Hey there stranger!
Sign up to get access.
Escape Spreadsheet Hell A Mini Game
About this Tutorial
0:08 It's a very minigame to teach you exactly three keyboard shortcuts. It is free for everyone. And as members of, uh, better sheet members get to see it first and free.
0:20 But everybody gets it free today. This is a fun game. Very little game. Just to teach you three keyboard shortcuts, I'm going to, um, share in this video the entire game.
0:29 So if you want to play, just go in the description to the link. Go to Gum Road. Pay $0. It is $0 to get.
0:38 You can name a fair price to $0. And click I want this, and enter if you dare. If you escape spreadsheet, hello.
0:46 This is what you're going to come out with. You're going to learn you're going to discover how to navigate around a spreadsheet quickly with your keyboard.
0:53 You're going to discover how to reveal underlying formulas hiding within the cells. And you're going to learn how to wield powerful UN formatting keystroke to reveal the natural born format of cells.
1:04 So come with me as we endeavor into spreadsheet how and out. We're going to escape. We're definitely going to escape.
1:11 Uh, but spoiler alert, as you're watching this video, I am going to go through the entire thing. So stop the video now.
1:18 Pause the video now. Go play for yourself. And actually, I think it's pretty fun. Even if you do watch this entire video and go back and play it, I think you'll get something out of it because it's the action of doing the keystrokes that are going to get you out of, um, spreadsheet H***.
1:35 All right? So if you click zero, I want this. You're going to get here. This is inside of Gum Road.
1:41 And all we have to do is go to this spreadsheet. So we don't need edit access. You'll see, there's one little thing we do, and you'll see that as we go in.
1:51 But let's stop preparing you. Let's get in there. Let's go deep down into Spreadsheet H*** and escape. All right, we are in a spreadsheet.
2:00 You poor, unfortunate soul. You have entered spreadsheet h***. The demons here are plenty foul creatures of bad habits and ignorance.
2:08 You can defeat them by wielding your keyboard. Find the diamond. It is the way out. Here's a bunch of diamonds.
2:15 These are black diamonds. We do not need these. All right? First, we must find the diamond. In a blank abyss of a sheet, arrows lead our way, journey forth and go where they point.
2:26 Nothing but folly in our past. Only pure, pristine, time saving goodness lay ahead. Because if we merely held down the arrow key to go where we're going, we'd waste precious time.
2:36 It is so slow. So click and rest your cursor on a two. Go to your keyboard. Hold down the command key and the arrow on the keyboard.
2:45 That you're on. So if you're on an arrow, go that way on your keyboard. Uh, if you encounter an angled arrow, first go down one row and then hold down command and the arrow key in that direction.
3:00 Cool. So, um, we have our rules. We have how we're going to get out of here. So we start on a two.
3:08 We have this green arrow. It is pointing to the right. So I'm going to hold down command and I'm going to hit the right arrow key.
3:16 Okay, my selection went to C two. I'm going to hit down, then left and command. And now we got to an angled arrow.
3:26 So we go down one row and we have to go to the right. And we just keep going. Keep going.
3:33 We got another I got to move my face a little bit. We got to another angled one. So we go down one row and to the left.
3:41 All right, we're going to the left. And now we got to there's a lot of columns in here. Go down.
3:49 My God. Did you see that? We're on row 19,000. Oh, my God, that was fast. If we had held down the down arrow, we would have got it.
4:00 Taken us minutes to get there. All right, now we're on a right arrow. So we hold down command and go to the right.
4:06 We're on a right arrow. Hold down command, go to the right. Go up. Uh, we're going up. And we got to another angled one.
4:14 Go down, one to the left. There's a diamond. That's not the diamond we're looking for. Okay, keep going down. All right.
4:21 To the right. Okay, my cursor is over here to the right. It's got to go up, then right, then down.
4:30 My God. 190 rows. And we go up. Now we go down and to the right. And we found the diamond.
4:41 Okay, we haven't escaped it. We got to click on the diamond. Click on the diamond. There is an escape. Let's go.
4:46 Level two. We got out. Great. You have a new tool in your tool belt. I see you've escaped the first level.
4:52 But can you escape this particular spreadsheet h***. Find the door to lead you out. These are all door emojis, and they're all going to Google.
5:02 It's all hyperlinks. You don't have to click on every single door to see the link. Each door is a hyperlink formula.
5:08 You can reveal what's behind the door by holding CTRL and then pressing the squiggly that's I think the Tilde. So hit what is that?
5:17 Control and tilt. And there's the hyperlink. Wow. So now we see. These are all Google. So now what do we do?
5:25 There is another way. See the hint? So if you can't find it just scrolling through here, there's some arrows. There it is.
5:35 So there's the answer. Oh, there's the door. But if you can't go through here, let's go through the hint. I want, uh, to show you the hint because it's pretty cool.
5:43 So we go to the hint. We go press command F, finding the sheet. This is going to be in a different language than yours, but if you do this hint, you also find that you can search within formulas, which is a little bonus lesson.
5:56 You get there. All right, I won't do that here. We found these arrows and these doors. If we scroll down scroll down.
6:04 There it is. There's our link. And there we can escape to level three. Exciting stuff. Where has everything gone? No grid lines, no text, no background.
6:15 Is this spreadsheet? H***, we're almost out. Just one more escape. You can do it. We can do it. Everything on the sheet is formatted.
6:23 Someone made a huge error. Its text is white and the background is white. Oh, my God. Oh, no. But that's not the original natural formatting of a sheet.
6:33 Click the area between A and one. We don't see it yet, but B, one B here. We got to click over here, I guess, and select all the cells.
6:44 Then use the keyboard shortcut command and the slash, which is right above the return key on a Mac. You, uh, can change all the formatting to its original format and reveal an escape path somewhere in the sheet.
6:56 All right. For this one, you have to have edit access. So I've made it so you can make a, uh, copy.
7:02 So we're going to make a copy in our Google Drive, and you can just click this and make a copy.
7:08 Okay, we're going to click here. We're going to make a copy now. We can make a copy there. Make a copy?
7:18 Yeah. All right. So you make a copy in your Google Drive, and then when you go here to a one, now we're going to hit with a command and right above the arrow key.
7:30 Wow. So now everything got unformatted or reformatted back to its original aerial, and we have not a way out. We have some text here.
7:38 Well, okay. So we have some text. Not a way out. How are we going to find this? This isn't that big of a sheet.
7:44 This isn't that big, but what is this? Not a way out. I feel like we're in h*** right now. This is spreadsheet.
7:52 This is really spreadsheet. Oh, we found it. We just scrolled around for it. There we go. What have we done?
7:59 What's next? Oh, we've escaped. You've escaped, reggie h***. Now we can tweet. If you click this button, it's a Twitter intent link.
8:08 It'll open Twitter. It will let you say you escape Spreadsheet Hill. If you add me add at campfire to it and I'll retweet you, I'll give you kudos for escaping.
8:20 I'm, um, so happy we escaped. And we learned three new keyboard shortcuts. You get some prizes for escaping. You get all the free stuff.
8:30 You can become a better sheet member for free access. To over 60 tutorials. If you're watching this on July 27, you're probably a member.
8:38 So you got this for free first. You got notified of it first. You can become a paid member, and you get everything for free, including 200 tutorials.
8:49 If you become, uh, a lifetime member, you get every product for free, every tutorial for free, every single tool for free.
8:56 But here we got free Track Anything, which is a daily tracker you can use to track anything, and 100 business ideas for free.
9:03 Click on those $0 go get them on Gum Road. But now you have the gift of knowledge as well, which is three new keyboard shortcuts.
9:11 Now, if you're not a member yet, bettersheets co are making new content all the time. Updating the content and, uh, tools, tips, tricks, templates.
9:22 Go check out atomic sheetscom. That's a free ten templates for you. Actually, 30 templates if you give me your email address.
9:29 Become a better choice member. Now, there's still lifetime deal happening on AppSumo. When I am recording this, I'm, um, so excited that we escape.
9:38 You can go play as well on Gum Road, and you can go play and enjoy and learn this keyboard shortcut.
9:46 Thanks so much. Have a great one. Bye.