00:00Peace be upon you. I am here in a new video explaining Excel.
00:05In this video, we will learn together how to highlight and copy a worksheet.
00:11Our discrimination is either by coloring the worksheet, which is the part that I point to with the mouse, every day.
00:19It is called a complete worksheet.
00:22We can make this distinction for her by changing her color or giving her a different name so that we can return to her at some point in time.
00:30We will also know together how to copy this worksheet or move it to the Excel sheet.
00:37Ok, this is about oil. Let's see together.
00:40First of all, if I want to name my worksheet something other than “Sheet One,” which is the default name...
00:46I want to name it, for example, Ah Q One, or the first part, or whatever my name is.
00:54Right click on it
00:57And I start telling him to rename
00:59I call her Q One
01:02So I got a name
01:05The one next to it is the same thing. I start by right-clicking on it.
01:09I tell him to rename it
01:10Call it Q Tom for example
01:12Okay
01:14Ok, very nice, I have Q1 and Q2m
01:17good
01:18Yes, he says, we would like to color our tab or our worksheet.
01:24Right click on it in the same way
01:26But this time, instead of telling him to rename, I tell him to color the tab.
01:31Let it be purple, for example.
01:34Right click on the one next to it
01:37Give it a color like this
01:40And so on
01:41Ok, I wanted to give them all the same color.
01:45I will start by right-clicking on it and telling it to select all papers.
01:49So it's all set for me, right click again
01:51And I started to tell him the color of the tab
01:54And it will turn red, for example.
01:58Should I change the color of all of them to another color?
02:03So, each one has his own preferences.
02:06Ok, very nice
02:08Now we know how to name them with the custom of naming
02:10How do we color them?
02:12In their color
02:14Tab color
02:16How do we color them all at once?
02:18We will do all the paperwork for them.
02:22Now I want to take a copy of the diaspora and throw it in the file.
02:26I have this one and another one
02:29I will give you who
02:31And I will start to tell him this time to copy or paste
02:35Okay?
02:36I wouldn't want to put it in the same file or the same folder.
02:40I will bring this classifier as it is
02:42If I want to write it in another file
02:44I will like and see the classifier that will tell me
02:47His name will be E
02:48Okay? Of course we do, so he only opens one file.
02:50So answer me, the author is one
02:52Okay, I want to cut to the chase.
02:55I will start to say it to the end
02:57Okay? I'm moving now.
02:58No, I don't want to say it.
03:00I want to take a copy of it
03:02It remains with me at the beginning and the end
03:04The ambush remains
03:05Transfer or copy
03:07I will make the version that is under the DVD as it is
03:10And I start to choose his place
03:12It will be above
03:13I tell him to create a copy
03:15I still have the possibility of transferring
03:17Or copy
03:19And the transfer we did
03:21I didn't say at the end
03:23So he took the worksheet.
03:25Thrown into the devil from the other
03:27Now I want to be there twice
03:29So I start to define here
03:31Create a copy
03:32I tell him to leave
03:33I have Q1
03:35Between two cups
03:37This means the second version
03:39I have Q1
03:41good
03:43I have another way to transport
03:45I want to transfer the tabs
03:47Or change their order
03:49I start to pull the tab
03:51With the mouse
03:53Click left
03:55And I drag it by throwing it around
03:57And arrange the tabs
03:59The way I want
04:01Ok Q One
04:03Which is copied the second time
04:05I don't want this
04:07I'll start making a cricket on it
04:09And I start to say shame on him
04:11Finally
04:13If I wanted to add a new tab to it
04:15or a new worksheet
04:17I will start clicking here on the disappearing sign
04:19So he brings me a new worksheet.
04:21Okay?
04:23So we know how
04:25We work on our awareness
04:27For the worksheet
04:29How do we color it?
04:31How do we call it?
04:33How do we transfer it or make an additional copy of it?
04:35Of course, here too there are special settings for our worksheet.
04:39Can we rename it?
04:41Or move and copy the paper
04:43Or we color it
04:45And the protection that we had previously provided from below
04:47Come on, try it
04:49Come on, try it
Comments