Hi, everyone.
Today, you are going to discuss an important thing about Microsoft Excel, it's about Axl Rose and
Cullum's.
So the objectives of this lecture are exploring exit rows and columns about right click for rows and
columns and the sort of feature.
Max FLEXCEL is in tabular format consisted of row and columns, rows run horizontally and columns runs
vertically.
Each row is identified by row number, which runs vertically at the left side of the sheet.
On the other hand, each column is defined by a column header which runs horizontally at the top of
the sheet.
Let's go more practically to Microsoft Sheet.
Here is our sheet.
These are columns and these are rows.
If you want to get the last column in Microsoft Excel, just click Control and write ERU.
And this is the last column named X, if the if you want to get the last row in the workbook sheet,
just click control and arrow down.
And this is the last row in our seat.
Oh, it's one million, more than one million and our seat.
So if you want to get back, just control left arrow and control up arrow.
And this is our data.
So what about right?
Click on row.
Right.
Click on row we can use right click forgot cubie best special certainly clear content format all row
high tide unhide.
And this lecture we will discuss how to insert new rule by insert.
Here you insert a new rule.
This is a new rule.
If you want to insert a new rule again, insert.
If you want to delete this new insertion, just select right click delete.
If you want to hide this row, select right click.
Hide if you want, unhide again.
Select here and.
Unhide or Selecta on this column, right, click unhide.
However, the data are disappeared and hidden, and I think there is something wrong and there is error,
there is no sign how to hide this.
No sign, no sign here refers to the space of the number is not enough to appear the number and to show
the number.
So he should increase the base.
So I will increase this base by increasing the space of C column like this.
So.
Accordingly, all numbers have been appeared, if I wanted to, to this column, just come here by Kurzer
and stand between column C and column D and click on this site.
This is out of it for the column.
Again, if you have the column by this shape, too large for the space and too large for the content
of numbers.
If you want to add this column, just click on this site.
You fit the column if you want to, too.
If you want to outfit all the shit or column in the sheet, click here.
You select old columns and those stand by cursor between any two columns and.
And one click on this site.
You outfit on the sheet columns.
Similarly on the rules, you cannot fit all the rules by clicking here.
Like this.
This is about this is about a out of it feature four columns, zero, right, click here if you want
to clear the content of this.
All right, click right.
Click on this row and select clear contents so you clear the contents.
If you want to clear the whole contents for this row, just select it right.
Click clear content if you want to get back for this step.
Just controlled it.
Controlled it again.
OK.
Similarly, on the columns, if you want to add a new column just right, click for the column you want
to add and right click insert you add column here.
If you want to add a new column here beside the circular, just select it right.
Click and insert.
There is a new column for the see if you want to delete this row.
You can select this row and you can select the other row and right.
Click delete.
So you delete the two new columns by one time.
So you have the right click feature of row here in the column.
So if you want to hide or unhide, want to hide this column, just click hide.
If you want to hide all this table just right, click on the columns and hide.
You hide on the table.
If you want to unhide, just select the column.
Right.
Click and hide.
If you want to increase the rawhide, just stand on Rawhide, if you want to increase the rawhide,
just stand for the role and select the roll.
Right, click Rawhide and.
Right, the new size.
And right, the new size, I want to write 30.
OK, I increase the roll by 30 if I want to increase this column.
Width by 60, just like 60 here, there is 60.
I want to outfit the call and just click on call and.
Just click on row 10 here.
This is about auto fitting, it is about adding, moving, clearing content and their lead columns or
four columns, Andrew and Microsoft Excel.
Moreover, if you want to freeze this rule.
Just select.
The general road annexed by this road and from view to select freeze bands and to and select freeze
bands from here, so you freeze this table.
If you want to unfreeze this table, just select the row and from a few freeze bands on freeze bands.
And here on frizzed tape.
This lecture today is about columns and row of Microsoft Excel.
See you in the next lecture.