Formula hide in excel in 2010 in Hindi
Hii Dosto, Aj hum sikhne ja rhe hai kuch interesting jisme apko bhot acha lgega sikh kar, agar hum apne formulae ko kisi ko bhi nhi dikhana chahte matlab apne formulae ki jankari nhi dena chahte, to ese me hume kya krna chahiye yhi aj hum janne ja rhe to chaliye start krte hai.
Aj hum janenge ki excel me kisi bhi formulae ko kese hide krte hai , hum chahte hai ki koi bhi person humare formulae ko na dekh sake, Lekin kisi bhi tarah ki changing kr sake
Formulae ko hide kese kre
Sabse pehle poori SHEET ko SELECT kre (Ctrl + A) 2-3 bar dabakar select ho jayegi nhi to fir A1 cell ke corner pr click krna hoha , Us pr RIGHT CLICK kre, Format cells pr jaye, uske bad Protection tab pr jaye or fir Locked ko unlock kre, Hidden pr click kre
Locked ko unlock krne ka mtlab hai koi bhi type kr payega, agar lock nhi hatata hai to type nhi kr payega.
Ok ka button pr click kre
Fir uske bad SHEET pr RIGHT CLICK kre,
Protect Sheet me jaye or Password fill kr de or Password ko confirm kr de or uske bad ise ok kr de
Ab aap check kijiye jaha bhi formulae lgaye hue hai wo formulae ab nhi dikhai denge mtlab formulae hide kiye ja chuke hai
Agar hum koi bhi changes apne data me krke dekhte hai to humara formula kaam kr rha hai lekin formula dikhai nhi de rha hai
Ummed karte hai apko humare dwara samjhaya gya asani se samaj aa chuka hai. Apko ye 4-5 bar khud se alag alag sheet me laga kr practice kr leni chahiye taki apko ye aap samaj jao or kisi ko bhi samajha pao.
No comments:
Post a Comment