MS EXCEL ALIGNMENT GROUP (MS EXCEL MEIN ALIGNMENT GROUP KYA HAI?)
Excel mein sirf numbers enter karna kaafi nahi hota. agar aapka data cell ke bahar jaa raha hai ya sahi alignment me nahi hai , toh wo dekhne mein bahut messy lagta hai. Or yahan hum alignment group ka istemal karte hain. aaj ke blog mein hum seekhenge ki Excel ke Alignment tools ka use karke aap apni report ko professional look kaise de sakte hain.
1. Text Alignment (Top, Middle, Bottom ,Left Center Right Align)
i)Vertical Alignment:
Isse aap text ko cell ke Top,Middle ya Bottom mein rakh sakte hain.
ii) Horizontal Alignment:
Isse text Left ,Center, Ya Right side shift hota hain.
2. ORIENTATION :-
Ms Excel mein yeh option tab kaam aata hai jab aapka data bahut zayada ho aur columns ki width kam karni ho, ya phir apni report ko ek "Creative Dashboard" look dena ho.
i)Anti Counterclockwise:
Isse aapka text niche se upar ki taraf rorate ho jata hai. yeh sabse zayada use hone wala option hai kyunki isse lambe headeres chhote columns mein bhi fit aa jaate hain aur dekhne mein bhi "professional " lagte hain.
ii)Angle Clockwise:
Yeh text ko upar se niche ki taraf hojata hai .Agar aapka layout thoda alag hai, toh aap iska use karke ek unique look de sakta hain.
iii)Vertical Text:
Isme aapka text sidha khada rahta hai. iska use tab kare jab column ki width bahut hi kam ho aur row ki hight zayada ho.
iv) Rotate Text Up :
Ismein pura word 90 degree ghoom jata hai aur niche se upar ki taraf padha jata hai. yeh narrow vertical borders ya binders ke side lables ke liye perfect hai.
v)Rotate Text Down :
Yeh "Rorate text up" ka ulta hai. Ismein text upar se niche ki taraf 90 degrees par flip ho jata hai.
vi) Format Cell Alignment:
Agar aapko in presets ke alawa kisi specific angle (jaise 45 degree ya 30 degree) par text kar sakte hain aur text ki spacing ko bhi control kar sakte hain.
3. DECREASE INDENT :-
Is button ka kaam hai text ko call ke border ke pass wapas lana.
i)Agar aapne pehle se zayada gap de rakha hai aur aap ise kam karna chahte hai, toh is par click karein.
ii)Yeh tabhi kaam karega agar aapka text pehle se indented ho.
4. INCREASE INDENT :-
Iska kaam hai text ko cell ke border se thoda door karna
i) Jab aap chahte hain ki text bilkul left border se juda hua na dikhe or gap ke sath start ho.
5.WRAP TEXT :
Jab aap kisi cell mein lamba sentence likhte hain, toh wo sath wali cell ke upr chla jata hai. Wrap text iska best solution hai. iska use adress, remarks likhte samay karein.
6.MERGE & CENTER
Yeh aapke select kiye hue saare cells ko ek kar deta hai aur jo bhi text aapne likha hai, use bilkul beech mein la deta hai.
ii) Merge across
Agar aapne multiple rows aur columns select kiye hain, toh yeh column ko to merge kar dega sath me rows ko bhi alag alag rakhega. 
iii) Merge cells
isse cells merge ho jate hai or text center mein nahi aate . text waise he rahta hai jaise pehle tha
iv)Unmerge cells
agar aapne galti se cell merge kar diye hai or waps se normal cells mein lane hai to toh is par click karein .
CONCLUSION :-
Aaj ke blog mein humne sikha ki MS excek mein alignment group ka use kaise kare . Agar aap ms excel mein kaam karte hain. To ye post aapke liye kaafi useful hai alignment he hmare data ko ya hamre kisi bhi workbook ko shi alignment me dikhata hai . To agar aapko post useful lagi ho to comment karke jarur btaye . Or hamre channel ko subscribe karna na bhoolen.
0 Comments