Skip to playerSkip to main content
  • 6 minutes ago
ye video excel ke un users ke liye banai gayi hai jo rozana bade data sheets par kaam karte hain aur jinhain bar bar borders lagane ki wajah se waqt zaya hota hai is video me aap ek bohot hi powerful aur unique one click trick sikhenge jiske zariye aap ek dafa me das hazaar se zyada cells ko select karke unpar instant border laga sakte hain is video ka maksad ye hai ke aap ko excel me speed productivity aur workflow ko bohot behtar banana sikhaya jaye khas tor par un logon ke liye jo daily basis par bohot heavy sheets jaise stock sheets attendance records finance accounts aur kisi bhi tarah ki listing banate hain aur har dafa unhe pure area par border lagane me mushkil hoti hai is video me bataya gaya tareeqa aap ke time ko bachata hai aur aap ko professional level ka kaam karne me madad deta hai excel me jab aap manually border lagate hain to aap ko pehle cells select karne padte hain phir border menu kholna padta hai phir all border option dhoondhna padta hai aur agar sheet bohot badi ho to selection bhi mushkil hoti hai lekin is one click trick me aap ek simple shortcut ya ek micro button ke zariye ye kaam instant kar sakte hain aap kitne bhi cells select karen chahe wo 5000 hon 10000 hon 20000 hon ya pure sheet ho sirf ek click par poora border ek saath lag jata hai iska sab se bada faida ye hai ke aap ko repeatedly border ke options me nahi jana padta aur na hi kisi menu ko dubara dubara open karna padta hai is video me aap sab se pehle ye seekhenge ke excel me selection ko professional tareeke se kaise control kiya jata hai jaise ctrl shift arrow keys ka istemal jisse aap seconds me bohot saare rows aur columns select kar sakte hain iske baad aap ko wo shortcut bataya jata hai jo instantly all border apply karta hai alt h b a aur agar aap isko ek micro button banakar quick access toolbar me add kar lete hain to phir ye trick aur bhi powerful ho jati hai kyun ke phir aap ek simple click se border laga sakte hain aap ke paas pura control hota hai ke aap sheet ke kis hisse par border lagana chahte hain aur kis hisse ko as it is rehne dena chahte hain ye trick un logon ke liye bohot zyada helpful hoti hai jo data entry karte hain ya phir forms banate hain jin me har cell ko border ki zaroorat hoti hai jaise admission forms salary sheets tables project records office registers aur bohot si aur spreadsheets jahan har cheez ko neat aur clean dikhana hota hai border lagane se sheet bohot professional lagti hai lekin manual border lagane me bohot time lagta hai isliye ye one click border trick har excel user ke liye ek game changer hai is video me aap ko ye bhi dikhaya jata hai ke border lagate waqt kaun si mistakes hoti hain aur un mistakes ko kaise avoid kiya jata hai jo log excel me naye hote hain wo aksar galti se half border laga dete hain ya double border kar dete hain ya kisi ek side border ko miss kar dete hain lekin is trick me aisa kabhi nahi hota kyun ke ye system pure area par ek hi type ka border lagata hai is video me aap ko practical
Transcript
00:01As-salamu alaykum, I hope you are all right.
00:04I hope you are all right.
00:05I will tell you in this video if you are going to interview you
00:10and you will tell you if you have A1
00:14F1 to 10,000 sales selects.
00:17This is a simple and easy way.
00:20If you are going to manually,
00:23it will be very difficult.
00:26This is a simple and easy way.
00:30This is a simple and easy way.
00:34This is a simple and easy way.
00:38This is a simple and easy way.
00:40This is a simple and easy way.
00:42If you are going to interview with F1 or G1
00:48or S1 or T1,
00:51you will see if you are going to sell.
00:55This is a simple and easy way.
00:57Now, I will tell you about 10,000 sales
01:00and that will apply.
01:03This is a simple way.
01:05This is a simple way.
01:07First of all, you will have a Excel sheet on.
01:10You will tell me if you are going to sell.
01:12This is the custom.
01:14This is the name box.
01:16This is the name box.
01:18I click on it.
01:19This is A1 to delete.
01:22Leave it.
01:23We will type take it.
01:25This is the F10,000.
01:27This is the name box.
01:29We will type.
01:30We will type.
01:33Then we will type it.
01:35shift ko hold рдХрд░рдХреЗ shift ko hold рдХрд░реЗрдВрдЧреЗ shift ko hold рдХрд░рдХреЗ
01:38рдФрд░ рдкрд┐рд░ enter рдкрд░ click рдХрд░реЗрдВрдЧреЗ рдЬреИрд╕реЗ enter рдкрд░ click рдХрд░реЗрдВрдЧреЗ
01:42рддреЛ рдпрд╣ рджреЗрдЦреЗ 10,000 sales рдЬреЛ рд╣реИрдВ рд╡реЛ select рд╣реЛ рдЧрдП
01:46automatically рддреЛ рдпрд╣ рдмрд╣реБрдд рд╣реА simple рддрд░реАрдХрд╛ рд╣реИ рдПрдХ рд╣реА
01:49click рдореЗрдВ рдпрд╣ рдХрд░ рд╕рдХрддреА рд╣реИ рдЖрдк рдФрд░ рдЕрднреА рдЖрдк рдпрд╣рд╛рдВ
01:52рдЗрд╕ рдкрд░ border рд▓рдЧрд╛рдирд╛ рдЪрд╛рд╣рддреЗ рд╣реИрдВ all sales рдкрд░ border
01:55select рдХрд░рдирд╛ рдЪрд╛рд╣рддреЗ рд╣реИрдВ рддреЛ рдпрд╣рд╛рдВ рд╕реЗ home рдкрд░ рдЬрд╛рдПрдВрдЧреЗ
01:58home рдкрд░ рдпрд╣ рдЖрдкрдХреЛ рдпрд╣ рдирдЬрд░ рдЖ рд░рд╣рд╛ рд╣реЛрдЧрд╛ all borders
02:02apply border to currently selected sales рддреЛ рдпрд╣рд╛рдВ рдкрд░ рдЗрд╕ рдкрд░ click
02:07рдХрд░реЗрдВрдЧреЗ рдЬреИрд╕реЗ рдЗрд╕ рдкрд░ click рдХрд░реЗрдВрдЧреЗ рддреЛ рдпрд╣ рдиреАрдЪрд╛ рддреЛрдбрд╝рд╛
02:11рддреЛрдбрд╝рд╛ рд╕реЗ рдиреАрдЪреЗ рд╣реИрдВрдЧреЗ рдпрд╣рд╛рдВ рдкрд░ all border рд▓рд┐рдХрд╛ рд╣реБрдП
02:14all border рдкрд░ select рдХрд░реЗрдВрдЧреЗ
02:15рддреЛ рдпреЗ рджреЗрдЦреЗрдВ рдпреЗ all border рдЬреЛ рд╣реИ
02:17рд╡реЛ 10,000 cell рдкрд░ select рд╣реЛ рдЧрдП
02:20рддреЛ рдпреЗ рдЗрд╕рдХрд╛ рдмрд╣реБрдд рд╣реА
02:22simple рдФрд░ рдЕрд╕рд╛рди рддрд░реАрдХ рд╣реИ рджреЛрд╕реНрддреЛрдВ
02:24рдЙрдореАрдж рд╣реИ рдЖрдкрдХреЛ рд╡реАрдбрд┐рдпреЛ рд╕рдордЭрд╛рдИ рд╣реЛрдЧреА
Be the first to comment
Add your comment

Recommended