1
00:00:14,850 --> 00:00:15,580
Hi, everyone.

2
00:00:16,260 --> 00:00:22,440
Today, you are going to discuss an important thing about Microsoft Excel, it's about Axl Rose and

3
00:00:22,440 --> 00:00:23,040
Cullum's.

4
00:00:24,390 --> 00:00:35,610
So the objectives of this lecture are exploring exit rows and columns about right click for rows and

5
00:00:35,610 --> 00:00:38,760
columns and the sort of feature.

6
00:00:40,490 --> 00:00:50,630
Max FLEXCEL is in tabular format consisted of row and columns, rows run horizontally and columns runs

7
00:00:50,630 --> 00:00:51,290
vertically.

8
00:00:51,950 --> 00:00:59,060
Each row is identified by row number, which runs vertically at the left side of the sheet.

9
00:00:59,960 --> 00:01:07,910
On the other hand, each column is defined by a column header which runs horizontally at the top of

10
00:01:08,030 --> 00:01:08,510
the sheet.

11
00:01:08,960 --> 00:01:12,860
Let's go more practically to Microsoft Sheet.

12
00:01:13,640 --> 00:01:14,570
Here is our sheet.

13
00:01:15,350 --> 00:01:19,040
These are columns and these are rows.

14
00:01:20,180 --> 00:01:31,130
If you want to get the last column in Microsoft Excel, just click Control and write ERU.

15
00:01:33,030 --> 00:01:41,010
And this is the last column named X, if the if you want to get the last row in the workbook sheet,

16
00:01:41,670 --> 00:01:46,650
just click control and arrow down.

17
00:01:49,610 --> 00:01:52,810
And this is the last row in our seat.

18
00:01:53,750 --> 00:01:58,740
Oh, it's one million, more than one million and our seat.

19
00:02:00,170 --> 00:02:08,200
So if you want to get back, just control left arrow and control up arrow.

20
00:02:10,010 --> 00:02:11,010
And this is our data.

21
00:02:12,980 --> 00:02:15,950
So what about right?

22
00:02:15,950 --> 00:02:17,960
Click on row.

23
00:02:18,800 --> 00:02:19,070
Right.

24
00:02:19,070 --> 00:02:28,430
Click on row we can use right click forgot cubie best special certainly clear content format all row

25
00:02:28,440 --> 00:02:29,960
high tide unhide.

26
00:02:30,740 --> 00:02:38,150
And this lecture we will discuss how to insert new rule by insert.

27
00:02:39,290 --> 00:02:41,380
Here you insert a new rule.

28
00:02:41,930 --> 00:02:42,920
This is a new rule.

29
00:02:43,160 --> 00:02:46,340
If you want to insert a new rule again, insert.

30
00:02:47,300 --> 00:02:53,120
If you want to delete this new insertion, just select right click delete.

31
00:02:54,260 --> 00:02:58,280
If you want to hide this row, select right click.

32
00:02:58,470 --> 00:03:01,430
Hide if you want, unhide again.

33
00:03:02,630 --> 00:03:04,250
Select here and.

34
00:03:05,450 --> 00:03:10,310
Unhide or Selecta on this column, right, click unhide.

35
00:03:15,340 --> 00:03:21,780
However, the data are disappeared and hidden, and I think there is something wrong and there is error,

36
00:03:22,990 --> 00:03:26,470
there is no sign how to hide this.

37
00:03:26,470 --> 00:03:36,760
No sign, no sign here refers to the space of the number is not enough to appear the number and to show

38
00:03:36,760 --> 00:03:37,270
the number.

39
00:03:37,290 --> 00:03:39,790
So he should increase the base.

40
00:03:40,900 --> 00:03:46,930
So I will increase this base by increasing the space of C column like this.

41
00:03:48,010 --> 00:03:48,490
So.

42
00:03:51,070 --> 00:04:03,730
Accordingly, all numbers have been appeared, if I wanted to, to this column, just come here by Kurzer

43
00:04:04,360 --> 00:04:09,410
and stand between column C and column D and click on this site.

44
00:04:10,570 --> 00:04:12,100
This is out of it for the column.

45
00:04:12,710 --> 00:04:21,610
Again, if you have the column by this shape, too large for the space and too large for the content

46
00:04:21,610 --> 00:04:22,210
of numbers.

47
00:04:22,510 --> 00:04:26,370
If you want to add this column, just click on this site.

48
00:04:27,400 --> 00:04:30,220
You fit the column if you want to, too.

49
00:04:30,460 --> 00:04:35,320
If you want to outfit all the shit or column in the sheet, click here.

50
00:04:35,590 --> 00:04:44,830
You select old columns and those stand by cursor between any two columns and.

51
00:04:48,080 --> 00:04:50,630
And one click on this site.

52
00:05:00,000 --> 00:05:02,370
You outfit on the sheet columns.

53
00:05:10,100 --> 00:05:15,530
Similarly on the rules, you cannot fit all the rules by clicking here.

54
00:05:17,300 --> 00:05:17,900
Like this.

55
00:05:23,670 --> 00:05:33,390
This is about this is about a out of it feature four columns, zero, right, click here if you want

56
00:05:33,390 --> 00:05:34,720
to clear the content of this.

57
00:05:34,770 --> 00:05:36,630
All right, click right.

58
00:05:36,630 --> 00:05:43,410
Click on this row and select clear contents so you clear the contents.

59
00:05:43,740 --> 00:05:50,220
If you want to clear the whole contents for this row, just select it right.

60
00:05:50,220 --> 00:05:56,370
Click clear content if you want to get back for this step.

61
00:05:56,610 --> 00:05:57,920
Just controlled it.

62
00:05:58,800 --> 00:05:59,570
Controlled it again.

63
00:06:00,040 --> 00:06:00,390
OK.

64
00:06:03,550 --> 00:06:11,140
Similarly, on the columns, if you want to add a new column just right, click for the column you want

65
00:06:11,140 --> 00:06:15,670
to add and right click insert you add column here.

66
00:06:16,000 --> 00:06:22,780
If you want to add a new column here beside the circular, just select it right.

67
00:06:22,780 --> 00:06:25,180
Click and insert.

68
00:06:26,800 --> 00:06:33,100
There is a new column for the see if you want to delete this row.

69
00:06:33,880 --> 00:06:38,950
You can select this row and you can select the other row and right.

70
00:06:38,950 --> 00:06:39,910
Click delete.

71
00:06:40,450 --> 00:06:45,970
So you delete the two new columns by one time.

72
00:06:47,500 --> 00:06:55,330
So you have the right click feature of row here in the column.

73
00:06:55,810 --> 00:07:01,730
So if you want to hide or unhide, want to hide this column, just click hide.

74
00:07:01,750 --> 00:07:08,200
If you want to hide all this table just right, click on the columns and hide.

75
00:07:08,500 --> 00:07:09,670
You hide on the table.

76
00:07:09,940 --> 00:07:15,040
If you want to unhide, just select the column.

77
00:07:15,130 --> 00:07:15,460
Right.

78
00:07:15,460 --> 00:07:16,420
Click and hide.

79
00:07:20,260 --> 00:07:27,670
If you want to increase the rawhide, just stand on Rawhide, if you want to increase the rawhide,

80
00:07:27,670 --> 00:07:31,890
just stand for the role and select the roll.

81
00:07:31,930 --> 00:07:35,440
Right, click Rawhide and.

82
00:07:37,520 --> 00:07:39,590
Right, the new size.

83
00:07:43,500 --> 00:07:47,430
And right, the new size, I want to write 30.

84
00:07:48,560 --> 00:07:54,580
OK, I increase the roll by 30 if I want to increase this column.

85
00:07:55,650 --> 00:08:02,400
Width by 60, just like 60 here, there is 60.

86
00:08:02,520 --> 00:08:08,820
I want to outfit the call and just click on call and.

87
00:08:11,890 --> 00:08:16,180
Just click on row 10 here.

88
00:08:18,140 --> 00:08:26,170
This is about auto fitting, it is about adding, moving, clearing content and their lead columns or

89
00:08:26,690 --> 00:08:29,840
four columns, Andrew and Microsoft Excel.

90
00:08:30,440 --> 00:08:33,710
Moreover, if you want to freeze this rule.

91
00:08:37,040 --> 00:08:38,300
Just select.

92
00:08:40,080 --> 00:08:50,400
The general road annexed by this road and from view to select freeze bands and to and select freeze

93
00:08:50,400 --> 00:08:54,410
bands from here, so you freeze this table.

94
00:08:56,070 --> 00:09:06,540
If you want to unfreeze this table, just select the row and from a few freeze bands on freeze bands.

95
00:09:08,840 --> 00:09:11,450
And here on frizzed tape.

96
00:09:13,540 --> 00:09:18,220
This lecture today is about columns and row of Microsoft Excel.

97
00:09:18,700 --> 00:09:20,050
See you in the next lecture.