اظهار واخفاء الصفوف والاعمدة وورقة العمل في الاكسيل

Shereen Elmasry

يعد هذا الكورس من أكثر الكورسات التي تحتاجها في سوق العمل وكذلك الدراسة وهو عبارة عن ثلاثة كورسات في كورس واحد أولهم كورس الاكسيل للمبتدئين، وفيه تتعلم الأساسيات العامة لاستخدام البرنامج، ثم كورس الاكسيل التأهيلي والذي يؤهلك لسوق العمل بكافة مجالاته كمستخدم عام لبرنامج الاكسيل، ويليهم كورس الاكسيل المستوى المتقدم والذي يتدرج لمستوى المحترفين حيث يؤهلك للعمل في قطاعات أكبر ومعرفة التعامل بشكل احترافي مع البرنامج.

Transcript

00:00Time comes to us with some important topics in the Excel program

00:05Hide and show

00:06What is concealment and revelation?

00:08If we have data to work on or a lot of data

00:12We can hide the parts that we are not working on now.

00:16We will only leave the parts we are working on.

00:19Or, for example, we work on quarters, which are each season of the year.

00:26Depending on our work, the first three months, the second three months, and so on.

00:31So we start by hiding the data for the first three months of the year.

00:35Or the next three months of the year and so on

00:39We will only spend the period we want

00:41Or we start by allocating a set of private data

00:46On a specific topic, this is the only thing we show, and we hide the rest of the data.

00:50From the first time we look at the devil, we know that there are hidden things in him.

00:56We know how. Come on, let's look together here at this devil.

00:59There is something hidden in it

01:01How did you know?

01:02Look with me at the alphabetical order of the columns.

01:06ABC

01:07After that, right away

01:09We learned this

01:10Or this is the alphabetical order ABC all the way around

01:13There is a column called Di

01:15But this column is not visible here.

01:17Even if we take care here

01:20The dividing line between the columns from above

01:22Here is one line here

01:24Mardug line

01:25I mean there is a column here in my brain

01:28Ok, can I look at this column?

01:31How do I start? I use a very easy method.

01:34I stand on the triangle

01:36What is between the first column and the first row?

01:39Click on it and it will select or define the entire area.

01:44I start by raising more than one method

01:48The first way is to go here to format in the main ribbon by clicking on it

01:53I have a show and a failure

01:56Because I have a column failure, it will show me here failure or show columns

02:01Here I have Show Columns, click on it

02:03The column called religion appeared with me

02:06good

02:08So that we can hide, let's take a failure

02:12The first way is that it is a right-hand property.

02:14Ahaqaf

02:16The use of the device remains

02:20So-and-so's finger is coordinated

02:22Failure and flowers of column flowers

02:25The first method with BS

02:27I have another way

02:30muted failure

02:33Flowers there is no failure this

02:38Ok? Very nice and I will start holding it again.

02:42As I hid it, I will start telling him to show the mayor

02:46Make sure it is for the column. Okay, and I can do this for the rows as well. Yes, of course it is possible.

02:51Come here to the third, fourth and fifth rows too

02:56I want to hide them, so I will start to identify them and tell them who touched you

03:01Show and hide for me

03:03Hide me what rows

03:06So, two or six remained here all the time.

03:10Ok, I want to show them back.

03:12I will start telling him who touched you, show and hide

03:15Make me show the classes so that they start to show again

03:19Here I have the subject easy and simple, Azhar and Khafi

03:23What I want, whether it is columns or rows

03:27Ok, can I hide the worksheet itself or can I hide it?

03:31I have more than one worksheet below.

03:34To hide it, I stand on it, for example, two worksheets.

03:37Right click on it from below

03:39I will start telling him what to do for me

03:41Hide it for me

03:44Like this or

03:45So I only have one sheet

03:49Okay, to show it, I will come back to make you forget

03:52Sorry, I justified it here somewhere.

03:55Come back to forget you again

03:57Show and hide I tell him to show the paper

03:59Here it shows me all the papers that I have hidden.

04:03And since there is only one teacher on it, I say to him, “Good luck.”

04:06You will appear with me again

04:07The first way is to right-click on it and tell it to do something for us, hide it.

04:13The second way is that we can specify on our paper the date.

04:19And we tell him who made you forget

04:21Show and hide what should I do to hide the paper

04:25It remains either from below or from above, and return from below again if you want to show it

04:30I will tell him to show the paper

04:32Stay here, I will specify on the column

04:37And when I started to tell him to sleep, he made me forget you

04:41Completely ignorant and ignorant

04:43Sleep for me

04:45I specify the rows and tell him to ignore the rows for me

04:48Or I tell him to hide the paper, and he will hide the paper I am working on.

04:51Or right click on the paper and hide

04:56I fell asleep

04:57And again, ignore your right cole and make it visible

04:59But here the show is not clear with me

05:02Because we do not hide the paper.

05:05So there is nothing to show for it.

05:07This is simply how we hide and show.

05:11Whether the currency, the rows, the worksheet

05:14Very easy and simple, train yourself on it

Category

Transcript

Be the first to comment

Recommended