1
00:00:00,05 --> 00:00:01,05
- [Instructor] Just as commonly

2
00:00:01,05 --> 00:00:03,05
as you'll be deleting rows and columns,

3
00:00:03,05 --> 00:00:05,05
you'll also be inserting them in Excel,

4
00:00:05,05 --> 00:00:07,06
and it works much the same way.

5
00:00:07,06 --> 00:00:09,02
The first thing you might want to do

6
00:00:09,02 --> 00:00:11,04
is insert a row above this one.

7
00:00:11,04 --> 00:00:13,05
So I'll select the entire row

8
00:00:13,05 --> 00:00:16,04
and I can either click Insert from the Home ribbon tab,

9
00:00:16,04 --> 00:00:20,03
or I can right click and choose Insert.

10
00:00:20,03 --> 00:00:22,02
The new blank row will be inserted

11
00:00:22,02 --> 00:00:25,02
directly above where the cursor was.

12
00:00:25,02 --> 00:00:26,07
I'll undo that.

13
00:00:26,07 --> 00:00:28,04
Now, also, just like deleting,

14
00:00:28,04 --> 00:00:30,07
if I wanted to, I could only select

15
00:00:30,07 --> 00:00:36,04
a certain amount of cells in the row.

16
00:00:36,04 --> 00:00:38,05
For example, we can insert a row,

17
00:00:38,05 --> 00:00:41,07
but keep this table intact over here on the right.

18
00:00:41,07 --> 00:00:44,00
I'll select my data, right click,

19
00:00:44,00 --> 00:00:46,04
and choose Insert.

20
00:00:46,04 --> 00:00:48,01
And just like when we deleted,

21
00:00:48,01 --> 00:00:51,03
I'm prompted with what I want to do.

22
00:00:51,03 --> 00:00:54,01
In this case, I'll shift the cells down

23
00:00:54,01 --> 00:00:56,02
and it's going to insert a new row

24
00:00:56,02 --> 00:00:58,08
above where my cursor was.

25
00:00:58,08 --> 00:01:00,07
It's the same with columns.

26
00:01:00,07 --> 00:01:05,06
I'll right click on a column, choose Insert,

27
00:01:05,06 --> 00:01:08,02
and my column gets introduced to the left

28
00:01:08,02 --> 00:01:10,05
of the column that I had selected.

29
00:01:10,05 --> 00:01:12,02
There's one more thing that's really neat,

30
00:01:12,02 --> 00:01:14,04
and you can do this with deletions too.

31
00:01:14,04 --> 00:01:18,02
You can insert multiple rows or columns at the same time.

32
00:01:18,02 --> 00:01:22,01
For example, let's say I need two new rows of data.

33
00:01:22,01 --> 00:01:25,00
I'll select two rows by clicking and dragging,

34
00:01:25,00 --> 00:01:28,06
right click and choose Insert,

35
00:01:28,06 --> 00:01:30,01
and that's what I get.

36
00:01:30,01 --> 00:01:32,01
Two new rows of data.

37
00:01:32,01 --> 00:01:33,08
This also works for deletions,

38
00:01:33,08 --> 00:01:36,09
if you wanted to delete two rows at the same time.

39
00:01:36,09 --> 00:01:40,02
In addition, I can select all of this data here.

40
00:01:40,02 --> 00:01:44,00
I've got four rows, but I haven't selected the entire row.

41
00:01:44,00 --> 00:01:48,01
I'll right click, choose Insert,

42
00:01:48,01 --> 00:01:50,09
shift the cells down,

43
00:01:50,09 --> 00:01:54,00
and now I have all this space to work with here,

44
00:01:54,00 --> 00:01:57,05
again, leaving this intact on the right.

45
00:01:57,05 --> 00:01:59,02
What if I needed two columns?

46
00:01:59,02 --> 00:02:01,07
I can do the exact same thing.

47
00:02:01,07 --> 00:02:06,00
Select two columns, right click, choose Insert,

48
00:02:06,00 --> 00:02:09,00
and I get two brand new columns.