00:00Assalamualaikum dosto uimis aye ap sab chik hoonge
00:03dioussto aaj ki is videoyome bei me ap ko bataung ga
00:06ki ap apenye excel sheet per eis tarah k berder line kaise lagwa sakti hay
00:11berder line ko color kaise kar sakti hay
00:14aur berder line ko patla Ų§ŁŲ± mota kaise kar sakti hay
00:17jeINE saksanthe alluraeli ap kuo screen per nazaraa raha ghehan
00:19mirai excel per
00:20tu api apenye excel sheet per eis tarah berder line bhi lagwa sakti hay
00:25hara eka line ko berder karwa sakti hay
00:26and you can have a color and you can have a color
00:29and you can have a motor and a lot of color
00:31so let's go to this video
00:33I will give you a video
00:35that you can see how easy it is
00:37and you can see it
00:39these three tricks
00:41which you can see
00:42so first of all
00:44you can see Excel sheet
00:46like this
00:47I will show you a new sheet
00:49I will show you
00:51I will show you
00:53I will show you
00:55so first of all
00:57you can see here
00:59where you can see
01:01border
01:02so you can select
01:04here
01:05I will show you
01:07here
01:09here
01:10here
01:11here
01:12here
01:13here
01:14here
01:15here
01:16file
01:17home
01:18insert
01:19page layout
01:20formula
01:21data
01:22here
01:25I will show you
01:26here
01:27here
01:29more border
01:30more border
01:31Now, more border.
01:34The more border.
01:36Is it where you click?
01:38So, as far as I'm...
01:41I'm going...
01:42I'm going to...
01:44I want to check the other one.
01:45So, here I am...
01:46I'm going to....
01:48This is style.
01:50This line style.
01:51So, line style.
01:52I'm going to...
01:53I'm going to...
01:54I'm going to click on it.
01:55Then I'm going to click on it.
01:58This one will go...
02:00If you have just side of the line or motor, you can select it.
02:07You can select it.
02:10You can select it.
02:12You can select it.
02:14You can select it.
02:16If you want to click on the line, you can select it.
02:21You can select it.
02:25Home.
02:27Here you go.
02:30father click on the line.
02:34Here he now is bottom.
02:36If you want all border.
02:38If you want to click on the line, you can select okćć§ just write leaf side.
02:41Changes in all border. So if you want to click. If you want to click the left side
02:46side or left side, right side just said, then we should click. Right border, left
02:53to click. Left border, left border, top border and bottom border, so all the options here
03:00are put in front. So I click all border. The all border. It turns that all border
03:06click on the line, the border is all over here.
03:11They are all over here.
03:14I will tell you if you can change the border line,
03:19the color change,
03:21this is a very easy way to select.
03:26You can select the border line.
03:31here on home page and then here on the color selects we click here on the line color
03:39click and here on the color selects we click here on the line color and here on the black
03:46green color yellow color and this color you can put it on the red color so I want to
03:56red color I want to click here on all border all border I want to click here on all border
04:03all border I want to click here on all border I want to click here on the color line
04:08so this is the three step this is very simple and easy way I hope you will understand
Comments