Hey there stranger!

Sign up to get access.

Basic Keyboard Shortcuts To Speed Up Your Productivity

About this Tutorial

We're gonna talk about some of the most basic keyboard shortcuts that incredibly time saving and are gonna make you so much faster when using Google Sheets.

Video Transcript

 Hello, welcome to Better Sheets. We're gonna talk about some of the most basic keyboard shortcuts that incredibly time saving and are gonna make you so much faster when using Google Sheets. Here they are. We're gonna talk about pace values. We're gonna talk about going to the end. And then I'm gonna let you go because if you are getting this for free, you're gonna get the pace values and the command up and down that go to end one.

And I think those two are gonna make you so much faster. If you wanna continue and see how to select large amounts of data and you want to even hear about the use cases of clear formatting, go ahead and pay for lifetime access to better sheets.co right now. That video is waiting for you once you become a member.

But today let's just go through these really awesome keyboard shortcuts that I use. What's happened is we have say a list of lots of data right here, right? And we have a column that has a formula in. But we have, let's move that all the way down here. Let's do this. So we have, all of these are formula.

Now we don't want to copy the formula. If we do that, command C, command V over here in the column D, if we just copy and paste, we're gonna get that formula again. And that formula is gonna change to. One over right here. It is a two and it's gonna change to C2 here. And that's really to deal with.

And we just want, Gracie, we just want this data over here just for some reason, right? So what we do is we do command C to copy and then we hold down the shift key command and V two CO two PACE values. So all we're doing is painting the values. This is incredibly useful if we wanna grab this data, right?

But also if we wanna create like a little summary page, we want maybe the top three, maybe it's some kind of ranking system. Top three, get a nice color, get higher, bigger text. And we wanna grab the top three, move 'em over here and, oh, we made a mistake. The actual top three over here, we want the full names and we don't wanna have to redo this formatting.

So we do. Then move over here, shift command V, and there we have the winners, the these top three. Or maybe we are like, oh, again, we don't want their full name here. We just want their first names. We don't have to do the formatting ever again. We just have to sh command copy, and then shift command V for copy paste values.

Really useful keyboard shortcut if you're using a PC or if you have a different setup. Then here I'll show you what it looks like. You go. Copy is command C. You can find out the keyboard shortcut here, and then your. Pace values is in pace Special, and it's the first one here. Pace values only here shows me command shift and V on yours.

If you're using a pc, it'll tell you something else here. Go ahead and find it there. That's pace value. Next one. This is so useful when I'm moving around data. So let's kill this row, right? If we wanna kill an entire row, most of the time we're gonna just go over to this column and header, right above the first column.

Click here and we got the whole column. But say we don't want the entire column. Maybe we just want, let's have maybe some blank spaces here, right? And we just want, oh no, we got a top 10. We have these 10, and then we have maybe some blank spaces, or let's not kill that data. Let's just insert one above, right?

We have this top 10. We just want this top 10. And honestly, if we only have a few cells to highlight, you just want to click and drag. But what if it was the top 100? What if this was down here? We where. Struggling to scroll down hundreds of rows. So here's what you should do. You hold down the command and you hit the down arrow.

And what that's gonna do is it doesn't take you to the end of the column though. What it's doing is it's taking you to, when it's the next non, the last non empty route. And so it to get through the empty ones, you. Click command and down arrow again. Click and demand command and down arrow again and again.

And this is a really good way to get through the data very fast. If, for instance, we had, let's just let's just not have those there, right? We, let's do this. Let's go to the top. And now you can see that just with holding down command. Going down and hitting the down. I can get to the very bottom if there's no empty cells.

This is really handy to get through lots of data. It's only 61 rows in this one, but maybe there's hundreds or thousands. I've had to go through data where there was like empty roads on like a hundred. A hundred rows out of 10,000 and I, all I had to do was hold down the command key and click the downer.

I had to not, I never had to scroll through and look at this visually again. Now, if you are getting this for free, you have gotten hopefully some awesome tips. Now go ahead and get more over@bettersheets.co sign up for lifetime access. And if you are a paid member, we're gonna keep on going and I'm gonna share with you how to highlight and select all of those rows you can even see shift.

And then I'm gonna show you how to, how and why we use clear formatting. Thank you so much. Bye.


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


Create Drop Shadows! This makes your dashboards pretty.


Merge Cells for Dashboards


10 Things I Hate About Your Spreadsheets

Dark Mode / Better Font Color


Better Font Colors


Magical Things You Can do with Checkboxes in Google Sheets


How To Export Your Beautiful Sheets to PDF


Consider Labels as Opposed to Headers


Add Icons To Your Sheets With a Domain Name


How To Color Cell Blocks So Others Enter Data Easily


Great Sheets! Corona Hiring Sheet


Great Sheets! Community Information Board by Seedtable.com


Roast: Hotel PPC Channel Cost Calculator


Better Header Fonts - Best Fonts To Use In Google Sheets

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


Basic Keyboard Shortcuts To Speed Up Your Productivity


Basics - 5 Ways to Change Row Height


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


How to Refer to Other Cells - A1 and R1C1 Explained


Change the Default Font


Biggest Flaw In Dashboards with Dark Colors


Basics - 4 Ways to Change Column Width


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


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


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


Create an Auto-Update Sales Chart: Trailing 12 Months


Google Sheet Basics - The Absolute Basics


Secure Your Sheets by BetterSheets.co


How To Create An AutoFill in Google Sheets


Build a Thermometer for Savings Goals

Make Your Lists Spicy Hot in Google Sheets


Restrict Access to a Cell if Another Cell is Blank

How to Use Smarket


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


Job Application Tracker Template | From TheLandOfRandom - Sheet Improvement!