- All right, what we're going to do
in this video is we're going to
put our mouse in a drawer,
and we're going to make ourselves use just the keyboard.
I have a link to this spreadsheet, it's in the description.
It'll bring you straight there, if you wanna follow along.
And the point of what we're doing is we're not going
to try to memorize 20 different shortcut keys,
we're going to go through what I would consider
a core set of shortcut keys.
They're the only ones that I know,
but they helped me to use spreadsheets
far faster than just using the mouse.
(ethereal music)
All right, so we have this...
I just went to try to grab the mouse,
here's our keyboard.
And the first thing that we're going to do,
there's an empty row in here and we're going to find it.
But the classic thing that I see people do,
there's a long table of data, they'll take their mouse
and they'll just scroll through it
so that you'll hear the wheel going
and they'll just look through it like this.
Well that's fine if it's just 20 rows or maybe 100 rows,
but a lot of spreadsheets are 10,000 rows, right?
So what you can do is if you hold down the Control Key
and then use the arrows,
we'll do it to the right, right now.
So I'm holding the Control Key, go to the right,
the cell that's selected,
moves all the way it can in that direction
until there is a gap.
So that comes in handy when you want to find blank rows.
So I'm going to hold down the Control Key,
I'm going to press down and I'll go down one more,
so you can see it a little bit clearer.
Goes to the first blank row.
So it just skipped down to row 79.
I went down one more to 80
and we're already where we want to fix things up.
So what we want to do is delete this row.
A lot of times in a spreadsheets
you'll want to select a row, right?
You might want to make it bold because it's a header.
You might want, delete it, move it around.
What you can do is just hold down the Shift Key,
and press the Space Bar.
And in this case you have to press it twice
because there's a blank column in here as well.
And then you have the row selected.
And from there all you have to do is hold down Control
while holding down Alt and hit the Minus Key,
that deletes your row.
So let's check to see if we have anymore.
So we'll go back a step,
and remember how we do that is using the Up an Down Arrow,
but we're going to combine it with Control.
And so that'll bring us all the way down
until there's another gap.
And let's go down a little bit more,
just with some single Arrow Keys,
and you see there's nothing left.
So we've deleted the row,
now just to get some repetition
and to understand this concept, let's do it with a column.
So we'll hold down the Control Key again,
this is a little bit more obvious at looking,
but if I hit the Right Button, it brings me to Column E,
because F is blank and G is blank as well.
So let's try that from the other side
just to get the same concept.
Hold down the Control Key,
Alt hit Left and it stops at H.
So what we want to do is we want to delete F and G.
So we'll be using the Control Key
and the Shift Key over and over.
And those two concepts alone
will get you twice as fast with a spreadsheet.
So let's go one to the left,
so we'll hit the Arrow Key, we're in Column G.
Now do Control and your Space Bar.
So Shift and the Space Bar did a row,
Control and the Space Bar does a column,
and you have that column selected.
While still holding down the Control,
let's hit the Space Bar one more time
to select the entire column.
And now we want to expand this range.
So when you want to expand the range
and get everything in between,
you want to start holding down the Shift Key.
So hold down the Shift Key right now and hit the Left Arrow,
and I've expanded the range to contain both of the columns
that we want to delete.
Now we'll do that Control Alt Minus again,
and got rid of the area I selected,
in that case it was a column.
All right, so our table's already a lot tighter.
There's no empty columns, no empty rows.
A great way to check is to hold the Control Key down,
go all the way to the right, all the way to the left.
If you forget any of these shortcut keys
you can always just use a Control and the Forward Slash Key,
in the middle of what you're doing
this window will just pop-up,
and you can look for something like Delete Rows.
And it's going to remind you that it's Control Alt Minus,
so that's super handy.
(chuckles) It's a little off topic,
but to close this window without the mouse,
I just tabbed over to where the X was
and I'll hit the Space Bar.
You probably don't have to remember that one.
All right, the next thing that we're going to do,
let's go to the bottom of the table.
And now let's act like the person
that you got this table from,
they're just not very familiar with spreadsheets
and you're afraid that they may have hard keyed some data
instead of used formulas.
So if you hold down the Control Key and press the Tilde Key,
that's going to show you all the formulas
in the spreadsheet, in this case there's only one.
In your more advanced spreadsheet,
this would change the way the entire thing looks,
but it allows you to look in all the formulas at one time.
And in this case you're realizing
that this is just hard keyed in here.
You want it to be a sum,
in case any of these values change, it will update.
So now let's just use some more shortcut keys here.
Let me do Control Tilde to get the show formulas oft.
And I want to copy this formula from H105 over to I105,
because I want both of these to be sum formulas.
The way to do this, which is far faster
than Right-Click-Copy, Right-Click-Paste using your mouse,
or typing the sum function over again,
is just to hold down the Control Key and press C for Copy.
Use your Right Arrow, go to I105 in
and Control V as in Victor for Paste.
It's not Control P because that's Print,
that was decided 20-years ago. (laughs)
So we're stuck with Control V for Paste.
And if want to see if there's a formula in here
I can either look up at the Formula Bar,
or I can hit the F-2 Key.
And the F-2 Key comes in handy a lot,
because if you want to modify the formula
you either have to double-click in the cell,
which is using your mouse, or just hit F-2.
If you hit Escape Key it toggles back out of it;
F-2 to get in it.
And you just use your arrows to move around.
So I can escape to get back out of that.
And I want to show you one more function here
that's very handy in certain situations, okay.
So what I did was I copied and pasted, right?
So that's going to take the contents of one cell,
paste them into another.
It will adjust formulas, so I use it all the time,
but sometimes you might just want to repeat
the last action that you did.
So let's delete this. We'll retype the sum formula.
So just type Sum and to get the range in here
without a mouse, hit the Up Arrow.
I'm going to hold down Control, so it goes all the way up.
I'm also going to hold down Shift,
so it selects everything in between.
Hit the Up Arrow, it goes all the way up,
and you notice it went up one too many.
So I will take the Control Key off,
so I'm just holding Shift now.
I'll hit the Down Arrow once, and now I have my range.
I'm going to type the ending parentheses and hit Enter.
And there you go.
Okay, if you had a lot more columns
and you wanted to repeat this action, another way to do it
is to use a key that just repeats your last action.
All right, so this isn't
an official Google Sheets Shortcut Key,
it's actually a carryover from Excel,
so it's not in Google Sheets Documentation.
But if I go into J105,
it doesn't really make sense here because there's no data,
but if I hit F-4, it puts the Sum Function in there again.
You may ask, what's the point of doing that
if you can just copy and paste?
But what F-4 can also do,
is that it's repeating the last action.
It's just not copying and pasting.
So if I were to, let's say, let's just delete a row again.
I'll hold down the Shift Key as we went through before
and I'll tap on the Space Bar twice,
Control Alt Minus to get rid of a row.
Okay, I can repeat that with the F-4 Key.
There we go, I just deleted another row.
So remembering the F-4 key,
depending on what you're doing in spreadsheets,
can save a ton of time if you remember to use it.
All right, let's assume that this data's good.
And what we want to do is select all of it.
So I've just gone back up to the top here
but we're going to use the shortcut key of Control A,
and that will select the entire table.
It's aware of where the boundaries are.
Just selecting the table's probably fine,
but if you want to select everything in the spreadsheet
just do Control A again.
So you're seeing the same concept
as when we were trying to select the rows.
It does a smaller part.
If you want it to expand, just do the same command again.
We want to get rid of the bold font
and we want to get rid of underline fonts here
just so that everything is the same
but there are only a few cells that are bold.
So the shortcut for that is just to make everything bold.
Hold down Control and type the B Key as in Bold,
and then just do it again.
That turned them all on and then it turned them all off.
So we'll do the same thing with underline.
We're going to do Control U and Control U again.
And now all the font styling is the same in the table.
But we're going to just do one more thing
just to make this apparent that it's a table.
We're going to hold down the Control Key
and we're going to go up
and then you'll see the same concepts repeating.
So I'm going to hold the Shift Key,
I'll press the Space Bar.
This time let's not press it twice, right.
We don't need the entire row,
for really all we're trying to do is style this table.
So we'll just do it once, and we'll do Control B.
And then I want center align this data.
But let's say I don't know the shortcut key
for center aligning,
but if what you're trying to do is not use your mouse,
you don't need to know all the shortcut keys.
Let's do Alt O to get us into the format menu.
And we'll type A to go down to align,
and then C to center align it.
All right, so I hope that with some practice
that you can learn these and just get a lot faster
using spreadsheets, right, because if you're faster
at the end of the day maybe you're done working earlier?
Maybe you do more work? I don't know.
Or maybe you just watch another video?
If you want to watch another video,
you check out this one on How to Sort By Color.
It's a pretty cool little function
that's built into Google Sheets.
I'll see you in that video. Thanks.