1
00:00:00,800 --> 00:00:07,939
First off let's take a look at how we can hide and unhide rows and columns and also how we can find

2
00:00:08,090 --> 00:00:11,710
which rows or columns have been hidden. Hiding is easy.

3
00:00:12,050 --> 00:00:18,350
All you have to do is highlight the row you want to hide, right mouse click, and select hide.

4
00:00:18,380 --> 00:00:23,840
You can do the same for columns. Just highlight the column or just drag your mouse to highlight many

5
00:00:23,870 --> 00:00:27,870
columns, right mouse click and hide.

6
00:00:27,890 --> 00:00:33,980
Now let's say you received this worksheet and you quickly want to see is there any rows or columns that

7
00:00:33,980 --> 00:00:35,420
have been hidden.

8
00:00:35,420 --> 00:00:42,010
You can't easily see that if you look closely you'll notice that you see that double border here.

9
00:00:42,020 --> 00:00:47,720
That's an indication but you can't visually quickly see that something is hidden.

10
00:00:47,720 --> 00:00:54,710
If you're just looking in this area. If you highlight all the cells by clicking on this side box up here

11
00:00:55,190 --> 00:00:57,740
you still don't notice anything has been hidden.

12
00:00:58,220 --> 00:01:02,680
Here's how you can notice. Go somewhere within your dataset.

13
00:01:02,720 --> 00:01:07,010
If you're looking for hidden rows or columns in that data set, highlight it.

14
00:01:07,250 --> 00:01:14,950
So we already learned the shortcut key control+a then go to Home > Find and Select > Go to Special.

15
00:01:14,960 --> 00:01:18,000
Now the shortcut key you can get there is control+G.

16
00:01:18,080 --> 00:01:23,340
Once you're here, select visible cells only and then click on OK.

17
00:01:23,390 --> 00:01:27,800
Now you see some bright lines going through your data set.

18
00:01:27,800 --> 00:01:32,780
This is a visual indication that something was hidden here.

19
00:01:32,780 --> 00:01:39,710
To unhide, you can select only that area or select all the columns or all the rows, right mouse click and unhide.

20
00:01:40,580 --> 00:01:42,070
Repeat that for the rows.

21
00:01:42,070 --> 00:01:49,930
Let's highlight this area, right mouse click, unhide. If you want to do that for your entire workbook

22
00:01:50,000 --> 00:01:54,610
you can as well. Let's just hide something here.

23
00:01:54,950 --> 00:02:00,700
You don't need to make any previous selections first. Just go back to Go to Special. Press control+G

24
00:02:00,710 --> 00:02:10,460
alt+s, Y to select visible cells only. Press enter and you see that visual indication right here.

25
00:02:10,460 --> 00:02:15,370
Now let's take a look at inserting values in between other values.

26
00:02:15,620 --> 00:02:22,860
So if I wanted to move voltage and I wanted to move it between Halotot and Flowrrr.

27
00:02:23,060 --> 00:02:30,560
One way to do this is through right mouse click and cut it or do control+X, go here, right mouse click and

28
00:02:30,560 --> 00:02:32,960
select Insert cut cells.

29
00:02:32,960 --> 00:02:35,090
There is another way you can do this.

30
00:02:35,090 --> 00:02:42,420
I'm going to press control+z to go back. The other way is to highlight your row and then drag this down.

31
00:02:42,560 --> 00:02:45,440
But what happens if I let go here

32
00:02:45,710 --> 00:02:48,140
It wants to replace this data set.

33
00:02:48,170 --> 00:02:50,000
That's not something I want to do.

34
00:02:50,060 --> 00:02:53,390
I want to drop it between these two data sets.

35
00:02:53,420 --> 00:03:00,790
So when you're dragging this hold down the shift key. This highlights the border in between

36
00:03:00,810 --> 00:03:06,560
and this way just let go of your mouse and it drops it in between those two lines.

37
00:03:06,590 --> 00:03:08,720
Okay so drag, hold down shift,

38
00:03:08,840 --> 00:03:15,290
Let go of the mouse, and then let go of the shift key. Let's quickly talk about adjusting columns

39
00:03:15,350 --> 00:03:16,230
and rows.

40
00:03:16,370 --> 00:03:22,400
So if for some reason your columns are too small to show the numbers you're going to get this pound

41
00:03:22,400 --> 00:03:23,190
sign.

42
00:03:23,240 --> 00:03:25,550
This doesn't mean there is an error in there.

43
00:03:25,580 --> 00:03:29,110
It only means it's too small to show the number inside.

44
00:03:29,150 --> 00:03:33,340
So just make it auto fit by double clicking on the border here.

45
00:03:33,360 --> 00:03:39,620
Now you can also set specific cell widths. If you highlight the columns you want to set.

46
00:03:39,620 --> 00:03:44,840
Just right mouse click and go to the column width. Here you can type in the exact

47
00:03:44,840 --> 00:03:48,160
width that you want and then click on OK.

48
00:03:48,320 --> 00:03:57,200
If you like a specific width and you want it applied to other columns you can copy the entire column

49
00:03:57,200 --> 00:04:04,130
and here's the thing, so I'm copying the entire "I" column, I'm going to go to "K", right mouse click and go

50
00:04:04,130 --> 00:04:08,900
to paste special. Don't select paste because that's going to paste the values and everything in there.

51
00:04:09,200 --> 00:04:13,310
Go to paste special and select column widths.

52
00:04:13,550 --> 00:04:21,440
So notice when I press Okay the "K" column becomes as wide as the "I" column, so you can do the same thing

53
00:04:21,440 --> 00:04:22,720
for rows as well.

54
00:04:22,820 --> 00:04:30,440
You can highlight many rows or hold down control and highlight different rows, right mouse click, go to

55
00:04:30,440 --> 00:04:37,790
row height and set a specific row height. Let's go with 15 here and that's going to adjust them slightly.

56
00:04:38,450 --> 00:04:42,430
Here's a bonus tip for you. Instead of hiding rows and columns

57
00:04:42,470 --> 00:04:44,060
you can also group them.

58
00:04:44,090 --> 00:04:50,180
The advantage of grouping over hiding is that you can visually see that something was hidden.

59
00:04:50,720 --> 00:04:51,410
Let me show you.

60
00:04:51,440 --> 00:04:53,910
Let's just highlight these two columns.

61
00:04:54,050 --> 00:04:55,270
Go to the data tab.

62
00:04:55,280 --> 00:04:57,980
That's where the grouping option is. On the right

63
00:04:57,980 --> 00:05:00,430
here you see these outline options.

64
00:05:00,500 --> 00:05:06,120
Just click on group. You automatically get this line here with the minus icon.

65
00:05:06,320 --> 00:05:10,090
When you click the minus icon it's going to collapse those columns.

66
00:05:10,310 --> 00:05:14,750
But if someone takes a quick look at this worksheet they notice something is hidden because they're

67
00:05:14,750 --> 00:05:16,900
going to see this icon up here.

68
00:05:16,940 --> 00:05:23,580
You can apply grouping to different columns as well. Just highlight them and click on group.

69
00:05:23,630 --> 00:05:26,790
Notice that we also get this one and two here.

70
00:05:26,840 --> 00:05:33,590
These are the levels of grouping that you have. Because you can also add a grouping within another grouping.

71
00:05:34,280 --> 00:05:38,120
To collapse and open all groupings in your columns,

72
00:05:38,120 --> 00:05:44,480
You can click on the 1 and 2 or you can individually open the groups that you need.

73
00:05:44,480 --> 00:05:50,810
You can do the same thing for rows, so let's just highlight these and group the rows and we get the same

74
00:05:50,840 --> 00:05:53,700
icons in here. To ungroup,

75
00:05:53,720 --> 00:05:56,420
you can either ungroup specific sections.

76
00:05:56,540 --> 00:05:57,860
So let's say I want to ungroup this,

77
00:05:57,860 --> 00:06:03,220
just highlight it and click on ungroup. To ungroup all columns,

78
00:06:03,260 --> 00:06:09,290
Highlight your cells by clicking on the icon up here and then click on ungroup.

79
00:06:09,290 --> 00:06:16,430
You get the choice of ungrouping your rows and columns so let's ungroup all rows again and let's go back

80
00:06:17,150 --> 00:06:25,520
and ungroup all columns as well. So that's how you can manipulate data in rows and columns. In the next

81
00:06:25,520 --> 00:06:26,070
lecture.

82
00:06:26,390 --> 00:06:31,240
Let's take a look at the different options we have when we use paste special.