1
00:00:00,690 --> 00:00:05,590
If you use spreadsheets a lot,
keyboards shortcuts are your best friend.

2
00:00:05,590 --> 00:00:08,720
Learning how to use them will increase
your productivity exponentially, and

3
00:00:08,720 --> 00:00:10,820
save you so much time.

4
00:00:10,820 --> 00:00:14,870
An expert spreadsheet user, will very
rarely use their mouse to navigate and

5
00:00:14,870 --> 00:00:16,610
work with their spreadsheet.

6
00:00:16,610 --> 00:00:20,270
Microsoft Excel includes
tons of keyboard shortcuts.

7
00:00:20,270 --> 00:00:23,470
But sheets has useful shortcuts
that will save you time as well.

8
00:00:23,470 --> 00:00:25,434
Let's get started.

9
00:00:25,434 --> 00:00:29,450
First and most importantly, let's
start with inputting data into a cell.

10
00:00:29,450 --> 00:00:34,090
Instead of clicking on a cell, you can
just press the Enter or Return key.

11
00:00:34,090 --> 00:00:36,420
Here, is a cell with data already in it.

12
00:00:38,050 --> 00:00:41,140
If I start typing,
it replaces the data already in there.

13
00:00:42,870 --> 00:00:44,090
I don't want to delete the data.

14
00:00:45,200 --> 00:00:49,950
I can click on the cell,
then take my mouse up to the formula bar

15
00:00:49,950 --> 00:00:52,870
at the top of the screen and
click and start typing.

16
00:00:56,500 --> 00:00:59,700
Or, I can select the cell and
click Enter or Return.

17
00:01:00,880 --> 00:01:04,650
Now, see my cursor appears and I can
use the arrows to move around the cell.

18
00:01:06,260 --> 00:01:08,790
Next up are Copy, Paste and Cut.

19
00:01:08,790 --> 00:01:12,740
These work exactly the same in
spreadsheets as they do in text editors.

20
00:01:12,740 --> 00:01:15,870
And chances are use the same shortcuts
as text editing software you're

21
00:01:15,870 --> 00:01:17,470
familiar with.

22
00:01:17,470 --> 00:01:21,050
For example, Copy is Cmd+C.

23
00:01:21,050 --> 00:01:24,720
I select the cell I want to copy,
then press Cmd+C at the same time.

24
00:01:25,840 --> 00:01:29,170
Notice how the highlighting around
the cell has changed to be a dotted line.

25
00:01:29,170 --> 00:01:31,460
That means I've copied that cell.

26
00:01:31,460 --> 00:01:34,120
I can copy multiple cells
at the same time too.

27
00:01:34,120 --> 00:01:36,150
Note that you can copy
more than just a value,

28
00:01:36,150 --> 00:01:40,320
you can copy a formula from one cell
to another cell, or multiple cells.

29
00:01:40,320 --> 00:01:44,440
Paste and Cut are the same as copy,
you just have to use a V for paste and

30
00:01:44,440 --> 00:01:45,540
an X for cut.

31
00:01:45,540 --> 00:01:48,049
So I've copied these cells using Cmd+C.

32
00:01:48,049 --> 00:01:51,500
Now I'm going to move over here and
press Cmd+V, and it's gonna paste those.

33
00:01:52,610 --> 00:01:57,000
I can also Copy these,
Paste them over here or

34
00:01:57,000 --> 00:02:01,780
I can Cut them by pressing Cmd+X and
put them over there.

35
00:02:01,780 --> 00:02:03,920
Paste special is super powerful,

36
00:02:03,920 --> 00:02:06,860
it allows you modify what
you actually Copy and Paste.

37
00:02:06,860 --> 00:02:08,462
So if we look at the menu.

38
00:02:09,519 --> 00:02:11,842
Under Edit, and go down to Paste Special,

39
00:02:11,842 --> 00:02:15,080
we can see all the different
special pasting that we can do.

40
00:02:15,080 --> 00:02:19,940
We can paste the values, we can paste
the formats, we can paste a formula.

41
00:02:19,940 --> 00:02:22,670
Let's look at an example of this together.

42
00:02:22,670 --> 00:02:29,100
Here, I'm copying this cell, I'm moving
it over to column G and I'm pasting it.

43
00:02:30,620 --> 00:02:33,250
Now, that's the formula.

44
00:02:33,250 --> 00:02:34,390
It's a relative reference.

45
00:02:34,390 --> 00:02:37,660
So it follows along as we
explained in a previous video.

46
00:02:37,660 --> 00:02:40,920
But, I can also copy this.

47
00:02:42,160 --> 00:02:44,870
And then if I paste special values,

48
00:02:46,220 --> 00:02:50,570
you can see that the formula wasn't
copied anymore but the value was.

49
00:02:50,570 --> 00:02:54,120
I use paste special values for
all sorts of reasons.

50
00:02:54,120 --> 00:02:57,521
One of the most obvious,
is if I have a spreadsheet that is using

51
00:02:57,521 --> 00:03:01,780
a bunch of formulas, and
I don't want the data to change anymore.

52
00:03:01,780 --> 00:03:05,940
I might copy everything, and paste special
values so the data won't change any more.

53
00:03:05,940 --> 00:03:08,367
Let's look at an example
here on this spreadsheet.

54
00:03:10,610 --> 00:03:11,710
These are all formulas.

55
00:03:13,210 --> 00:03:14,740
I could paste special value.

56
00:03:17,470 --> 00:03:20,564
And now the volumes are accurate still,
but

57
00:03:20,564 --> 00:03:24,500
they're not relying on
a relative reference formula.

58
00:03:24,500 --> 00:03:26,960
How about paste special formats?

59
00:03:26,960 --> 00:03:31,029
You may format a cell one way, and instead
of having to redo that formatting in

60
00:03:31,029 --> 00:03:33,920
another cell,
which could require multiple clicks.

61
00:03:33,920 --> 00:03:35,870
You can just paste special format.

62
00:03:35,870 --> 00:03:37,502
Let's look at an example.

63
00:03:38,890 --> 00:03:45,605
I'm making this cell yellow,
I'm bolding it and I'm adding a border.

64
00:03:47,345 --> 00:03:50,050
This cell looks very differently
than the other ones.

65
00:03:50,050 --> 00:03:51,770
I'm copying it.

66
00:03:51,770 --> 00:03:56,440
And instead of having to do
all those different clicks.

67
00:03:56,440 --> 00:03:59,469
I can just do one and
the format has been copied.

68
00:04:02,060 --> 00:04:03,820
How about this one here?

69
00:04:03,820 --> 00:04:04,412
Again.

70
00:04:05,880 --> 00:04:09,338
Format only, and we can see that
the values haven't changed, but

71
00:04:09,338 --> 00:04:10,990
the formatting has.

72
00:04:10,990 --> 00:04:15,680
Moving along, there are ways to navigate
around the cells without using your mouse.

73
00:04:15,680 --> 00:04:20,070
Naturally, you can use the arrow keys
to move around from cell to cell.

74
00:04:20,070 --> 00:04:24,560
So here I'm pressing right on my arrow,
now I'm pressing down on my arrows.

75
00:04:24,560 --> 00:04:27,900
Holding down Shift, will allow you
to select multiple cells at once.

76
00:04:30,461 --> 00:04:32,020
Like so.

77
00:04:32,020 --> 00:04:35,461
This is helpful if you want to copy or
change a lot of cells at once.

78
00:04:36,806 --> 00:04:39,600
So I'm copying these all,
and I'm pasting all of them.

79
00:04:40,740 --> 00:04:45,400
Instead of having to delete every single
cell individually, I can hold down Shift,

80
00:04:45,400 --> 00:04:48,510
and use my arrows, and
now I've selected all of them and delete.

81
00:04:48,510 --> 00:04:51,370
Holding down command on a Mac or

82
00:04:51,370 --> 00:04:54,910
control on a PC, will allow you to
jump to the next cell with data in it.

83
00:04:56,260 --> 00:05:00,250
Holding on command, press left and
it jumps to the next cell with that in it.

84
00:05:00,250 --> 00:05:02,290
If you're already in
the cell with that in it,

85
00:05:02,290 --> 00:05:05,840
it will jump to the next cell before
there is a cell with no data in it.

86
00:05:05,840 --> 00:05:07,430
So now I'm going to hold down command and
press up,

87
00:05:07,430 --> 00:05:12,630
and you can see that it stopped at
480 right before there's a blank.

88
00:05:12,630 --> 00:05:14,490
What happens here, I press down command,

89
00:05:14,490 --> 00:05:17,340
I press right,
it takes to the end of this spreadsheet.

90
00:05:17,340 --> 00:05:20,724
Hold down command I press left, takes
me to the beginning of the spreadsheet.

91
00:05:20,724 --> 00:05:23,493
Holding down command I press down,
it takes me to 6,

92
00:05:23,493 --> 00:05:26,710
I press down again while holding
command it takes me to the 5.

93
00:05:26,710 --> 00:05:29,646
So you can see if you're
working with a big spreadsheet,

94
00:05:29,646 --> 00:05:31,185
instead of having to scroll.

95
00:05:32,520 --> 00:05:35,822
In different directions by using
the command or control on your arrows,

96
00:05:35,822 --> 00:05:38,300
you can jump around pretty quickly.

97
00:05:38,300 --> 00:05:40,278
Now, if we combine Shift+Cmd,

98
00:05:40,278 --> 00:05:44,670
you can see how it will speed
up your workflow rather quickly.

99
00:05:44,670 --> 00:05:47,750
So before when I was showing the Shift
example, I would hold down Shift and

100
00:05:47,750 --> 00:05:48,940
then do this.

101
00:05:49,950 --> 00:05:53,410
But, if I hold down
Shift+Cmd then press down,

102
00:05:53,410 --> 00:05:56,190
I've selected all of them very quickly.

103
00:05:56,190 --> 00:05:59,520
Now, look how much faster
this is than using my mouse.

104
00:05:59,520 --> 00:06:02,461
With my mouse, I have to go move
my hand over to the mouse, and

105
00:06:02,461 --> 00:06:04,100
then I have to select all of them.

106
00:06:05,750 --> 00:06:11,900
But, with my keyboard shortcuts, I can
just hold down two keys and press down.

107
00:06:11,900 --> 00:06:14,520
And I've done it much more quickly.

108
00:06:14,520 --> 00:06:16,730
You can see how this can
save you a lot of time,

109
00:06:16,730 --> 00:06:19,030
when you're working with
a large spreadsheet.

110
00:06:19,030 --> 00:06:22,050
And would also help you when
you're selecting data to sort.

111
00:06:22,050 --> 00:06:26,346
The last shortcuts we'll talk about
in this video, are Undo and Redo.

112
00:06:26,346 --> 00:06:32,130
Cmd+Z or Ctrl+Z if you're in a PC, allows
you to undo an action you've just done.

113
00:06:32,130 --> 00:06:36,740
So here I'm going to use Shift+Cmd and
press down.

114
00:06:36,740 --> 00:06:39,820
And then up one time because
I don't want that bottom row.

115
00:06:39,820 --> 00:06:42,510
I'm going to press Cmd+C to copy.

116
00:06:42,510 --> 00:06:45,400
And I'm going to press Cmd+V to paste.

117
00:06:45,400 --> 00:06:50,050
But, maybe I didn't want to paste those
there, so I want to Undo what I just did.

118
00:06:50,050 --> 00:06:52,720
I could go up here to Edit,
and do Undo there.

119
00:06:52,720 --> 00:06:56,130
But, the much faster thing
to do would be Cmd or

120
00:06:56,130 --> 00:07:00,200
Ctrl+Z, and
it undo's the action I just took.

121
00:07:00,200 --> 00:07:02,100
If you want to Redo something.

122
00:07:02,100 --> 00:07:04,486
You can press Cmd+Y, and it's back.

123
00:07:04,486 --> 00:07:06,568
Cmd+Z, Cmd+Y.

124
00:07:06,568 --> 00:07:08,650
Cmd+Z, Cmd+Y.

125
00:07:08,650 --> 00:07:12,230
Now interestingly,
this can go for multiple steps.

126
00:07:12,230 --> 00:07:16,400
So, let's start over here
just to make it simple.

127
00:07:17,550 --> 00:07:22,260
I've deleted that,
now I'm selecting these cells.

128
00:07:22,260 --> 00:07:26,680
I'm going to paste them,
paste them, paste them, paste them.

129
00:07:27,820 --> 00:07:33,100
Now I can press Cmd+Z once,
twice, again and again, and

130
00:07:33,100 --> 00:07:37,060
redo works the same way,
redo, redo, redo, redo.

131
00:07:37,060 --> 00:07:41,880
So, just remember that you can go
multiple steps forward or backwards,

132
00:07:41,880 --> 00:07:43,720
by using Redo and Undo.

133
00:07:44,930 --> 00:07:47,820
Those are some of the basic
keyboard shortcuts that you should

134
00:07:47,820 --> 00:07:49,910
start building into your work flow.

135
00:07:49,910 --> 00:07:51,780
As you start to use spreadsheets more,

136
00:07:51,780 --> 00:07:56,580
pay attention to places where you can use
keyboard shortcuts and practice them.

137
00:07:56,580 --> 00:08:00,309
See the teacher's notes for links to
keyboard shortcut documentation, for

138
00:08:00,309 --> 00:08:01,809
both Google Sheets and Excel.

139
00:08:01,809 --> 00:08:05,670
You should explore these, and
work towards mastering keyboard shortcuts.