Excel Sheet ko lock kaise karte hai?

Hi friends, Aaj hum aapko excel sheet/excel file ko lock kaise karte hai yeh batane vale hai. Dosto agar aap computer me koi bhi list ya bank account detail, student list ya koi bhi data ki list banate hai to ye sari list aapko Microsoft excel me hi banana hoti hai, Kyonki excel ek most powerful software hai jo aapko aasani data ko enter, delete, mange karne ki permission deta hai. Excel me formula and data validation ki help se apni chahi gayi valu ko find kar sakte hai aur jab aap itni mehnat karke ek bahut jaruri list banate hai to oose secure karna bhi bahut hi jaruri hai.

Kyonki agar usme kuch jaruri jankari hai jaise: bank account detail, payment detail other information. Jise aap kisi dusre ke sath share nahi karna chahte hai to aapko apni excel file par password lock jarur lagana chahiye. Excel sheet ko lock karne ke baad koi bhi unknown person jiske pas excel file ke password nahi hai vo vyakti file open nahi kar payega aur na hi oose edit kar payega to es tarike se hum excel file ko dusro ke liye open karne se rok sakte hai.


Excel list ko lock karne ke liye 2 tarike hote hai ek to Encrypt document aur dusra cells ko lock karke. Par mai aapko document encrypt ko use karne ki salah dunga kyonki isse bina password ke vyakti file ke data ko dekh bhi nahi payega jabki cells lock me vyakti data ko dekh to pata hai par edit nahi kar sakta hai phir bhi vo aapke sare database ko dekh sakta hai aur cells lock ko edit karne ke liye ek bar unlock karne par aapko phir se cells ko lock karna hota hai jabki encryption me aapko file ko open karte time par hi password dena hota hai uske baad phir se password lock nahi karna hota hai aur agali bar file kholne par dena hota hai isliye aap document encryption se hi excel file ko lock kare.

excel-sheet-lock-kaise-karte-hai
To chaliye dosto jyada time na lete hue jante hai ki excel file ko lock kaise karte hai ya excel file par open hote time password lock kaise kare? Iske liye aapko kisi third party software ki koi jarurat nahi hai excel ne sheet protetct karne ke liye yeh dono feature software ke andar hi diye hai.

Excel file Password se lock kaise kare?

Step1: Jis kisi bhi excel file ko lock karna chahte hai use open kar lijiye.
Step2: Ab aapko left side me upar ki side me dikh rahe office button par click kare.
Step4: ab aapko excel file ke liye password dalna hai aur ok karna hai.
Step5: Ok karne par aapko phir se excel file password confirm karna hai aur OK kare.
Ab aapki file successfully lock ho chuki hai ab excel file ko open kare aur check kare password protection work kar raha hai ya nahi. Ab jab kabhi excel file karenge to password enter karna hoga. Dusra koi bhi vyakti jo password nahi janta hai es file ko open nahi kar payega. Agar aapko excel file ko lock karne me koi problem hai to hume comment kar bataye hum aapki help jarur karenge.
Thank You

No comments:

Post a Comment

Apna Comment Kare