Skip to playerSkip to main content
  • 1 day ago
Excel aik aisa powerful software hai jo duniya bhar me har tarah ke office kaam ke liye use hota hai aur har din laakhon log Excel ko apne data ko organize karne calculations banane aur tables ko maintain karne ke liye istemal karte hain isi liye Excel me border line lagana ek bohot hi common aur zaroori feature hota hai lekin bohot se log Excel me border line lagane ke liye unnecessary steps follow karte hain jis se time zaya hota hai aur efficiency bhi kam ho jati hai is lambi description me hum detail se samjhenge ke Excel me border line sirf ek click se kaise lagai jati hai aur kaise ek choti si Excel trick aapka kaam kai guna tez kar deti hai ye detail un users ke liye bohot helpful ho gi jo Excel ko rozana use karte hain chahay wo office ka kaam ho accounting ka kaam ho school college projects hon business data management ho ya kisi bhi tarah ka reporting ka kaam ho Excel ki border line feature har jaga kaam aati hai Excel ne hamesha se users ko data ko neat and clean form me present karne me help ki hai isliye jab bhi aap Excel me koi table banate hain ya koi list tayyar karte hain to border line us data ko professional look deti hai Excel me border line manually lagana aksar time consuming hota hai kyun ke user ko home tab me ribbon ke andar border icon par click karna padta hai phir dropdown khulta hai phir all borders ya outside border ya thick border select karna padta hai lekin jab aap rozana Excel use karte hain to aapko ek aisa shortcut chahiye hota hai jo aapka kaam seconds me mukammal kar de isi liye Excel me ek hidden shortcut diya gaya hai jo bohot kam logon ko pata hota hai ye shortcut Ctrl Shift and ampersand key ka hai jise pressure dene se Excel selected cells par instantly border line apply kar deta hai is se aapko kisi menu me jane kisi option ko choose karne kisi dropdown ko open karne ya kisi tab ko switch karne ki zaroorat nahi hoti ye bilkul ek click ki speed per kaam karta hai Excel me ye shortcut tab aur bhi powerful ho jata hai jab user tables ke saath kaam kar raha hota hai kyun ke border lines se data structured dikhta hai aur Excel sheet neat aur readable ban jati hai Excel ki ye one click border trick sirf beginners ke liye hi nahi balki advanced users ke liye bhi equally faida mand hoti hai agar koi user large data sheet par kaam kar raha ho jahan hundreds of rows aur multiple columns hon aur un sab par border lagani ho to Excel ka ye quick shortcut aik bohot bada time saver banjata hai ye shortcut Excel ke tamam versions me smooth tariqe se kaam karta hai chahay aap Excel 2010 use kar rahe hon 2013 2016 2019 ya Microsoft 365 ye Excel shortcut har version me barabar chalne wala feature hai Excel me border lagate waqt aksar users is baat se confuse hote hain ke unhe konsi border lagani chahiye kabi kisi ko all borders chahiye hoti hain kabi kisi ko sirf outside border chahiye hoti hai kabi kisi ko thick border chahiye hoti hai lekin one click border trick Excel me automatically simple and clean border apply kart

Category

📚
Learning
Transcript
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
Be the first to comment
Add your comment

Recommended