Microsoft Excel ayaa weli ah codsiga xaashida faafinta ugu caansan adduunka. Xogta xaashida xaashida ee Excel^(Excel) inta badan waa xasaasi, oo ka kooban xog shaqsi ama maaliyadeed. Sida la fahmi karo, waxaa laga yaabaa inaad tixgeliso ilaalin dheeraad ah faylalkaaga Excel , sida erayga sirta ah.

Waxaad erayga sirta ah ku ilaalin kartaa fayl kasta oo Excel ah adigoo isticmaalaya dhawr ikhtiyaar, oo ay ku jiraan aaladda sirta ah ee Excel isku dhafan ama ikhtiyaarrada sirta ah ee ^(Excel)Excel qolo saddexaad .

1. Furaha sirta ah Ilaali xaashida Excel Adoo isticmaalaysa Qalab isku dhafan^{(1. Password Protect An Excel Sheet Using Integrated Tool)}

Doorashada ugu horreysa ee ilaalinta erayga sirta ah ee Excel waa qalab isku dhafan. Dhammaan qaybta Microsoft Office waxay leedahay qalab ilaalin sirta ah oo aad isticmaali karto si aad u ilaaliso xaashiyahaaga Excel , waraaqaha Word , bandhigyada PowerPoint , iyo wixii la mid ah.

Gudaha Excel, u File > Info. Dooro Ilaalinta Buug^{(Protect Workbook)} -hawleedka , ka dibna ku sir erayga sirta^{(Encrypt with Password)} ah ee liiska hoos-u-dhaca ah.

Hadda, geli erayga sirta ah ee sugan xaashidaada Excel . Hubi in eraygaaga sirta ah uu xoog badan yahay oo gaar ah, taabo OK , ka dibna dib u geli eraygaaga sirta ah si aad u xaqiijiso.

Marka xigta oo aad isku daydo inaad furto xaashida xaashida ee Excel , waxaad buuxin doontaa foomka gelitaanka erayga sirta ah.

Ku cusub Excel? Fiiri casharradayada aasaasiga ah ee Microsoft Excel^{(Microsoft Excel basics tutorial)} si aad u barato xadhkaha - dhaqso!

Sidee Ammaan U Yahay Ilaalinta Sirta Sirta ee Microsoft Office?^{(How Secure Is Microsoft Office Password Protection?)}

Microsoft Office 97-2003 waxay^{(Microsoft Office 97-2003)} adeegsatay heer sireed aad u liidata, oo loo yaqaan RC4 . Algorithm-ka hore ee qarsoodiga ah wuxuu leeyahay nuglaanta badan, taas oo ka dhigaysa dildilaaca erayga sirta ah dukumeenti Excel ka weyn si cajiib ah.

Microsoft Office 2007-2013 wuxuu arkay algorithm sir ah oo la cusboonaysiiyay, oo u beddelaya algorithm-ka AES-128 ee aadka u xooggan. Xafiiska^(Office) 2016-2019 wuxuu isticmaalaa AES-256 sirta algorithm, kaas oo aan la jabin karin waqti macquul ah gudahooda iyadoo la adeegsanayo tignoolajiyada jira.

Ilaalinta dheeraadka ah ee Excel^{(Extra Excel Protections)}

Microsoft Excel waxay leedahay dhowr astaamood oo ammaan oo dheeri ah, sidoo kale:

• Calaamadee inuu Dhamaystiran yahay:^{(Mark as Final:)} Wuxuu calaamadeeyaa faylka inuu dhammaystiran yahay, kaasoo ku wargelinaya isticmaaleyaasha kale ee xaashida faafinta in aanay ahayn inay wax isbeddel ah sameeyaan. Si kastaba ha ahaatee, ku calaamadaynta xaashida xisaabaadka inuu yahay kama dambays ma bixinayso ilaalin sirta ah oo dheeraad ah.
  
• Ilaali xaashida hadda:^{(Protect Current Sheet:)} Waxaad ku dari kartaa lakab yar oo dheeraad ah oo ilaalin ah xaashida gaarka ah ee ku dhex jirta buuga shaqada marka aad erayga sirta ah ilaaliso xaashida Excel . Dadka gelaya faylka Excel wali way arki karaan xaashida faafinta laakiin ma samayn karaan wax isbeddel ah iyaga oo aan lahayn erayga sirta ah ee saxda ah. Waxaad isticmaali kartaa furaha sirta ah ee ka duwan doorashadan, sidoo kale.

• Xaddidaad Gelitaanka:^{(Restrict Access:)} Xulasho ururo waaweyn ayaa isticmaali kara si ay u xaddidaan gelitaanka shakhsiyaadka qaarkood iyaga oo isticmaalaya jaangooyooyin ammaan ama tilmaameyaal kale.
  
• Ku dar Saxiixa Dijital ah: Saxeexa^{(Add a Digital Signature:)} dhijitaalka ah ee ikhtiyaarka ah ayaa xaqiijiya in feylku uu yahay mid aan la hagaajin inta u dhaxaysa soo diraha iyo qaataha, iyada oo hubinaysa in nuxurku yahay isku mid.

Waxaad isticmaali kartaa isku darka sifooyin ammaan oo dheeri ah oo ay weheliso ikhtiyaarka ilaalinta sirta xaashida xaashida ee Excel , gaar ahaan haddii aad wadaagto xaashida xaashida ee Excel^{(especially if you’re sharing an Excel spreadsheet)} .

2. 7-Zip

Habka ugu fiican ee sirta faylal badan oo Excel isku mar ah ayaa ah in la isticmaalo qalabka kaydinta bilaashka ah, ^(Excel)7-Zip si erayga sirta ah loo ilaaliyo faylal badan oo Excel ah. ^(Excel)Waxaad isticmaali kartaa 7-Zip si aad u sirayso dhammaan galka Excel ee gaarka ah, erayga sirta ah ee ilaalinaya dhammaan xulashada xaashida xaashida ee Excel halkii aad hal mar ka ahaan lahayd.

Marka hore, soo deji oo ku rakib nooca ugu dambeeyay ee 7-Zip . Marka la^(Once) rakibo, u gudub faylka ay ku jiraan xaashiyahaaga Excel . Hadda, ku jiid cursorkaaga mouse-ka faylalka aad rabto inaad erayga sirta ah ilaaliso si aad u doorato dhamaantood. Haddii kale, hay CTRL oo guji bidix si aad u doorato faylasha gaarka ah ee jiirkaaga.

Kadib markaad dhamaystirto xulashadaada, midig-guji oo dooro 7-Zip > Add to Archive kaydka si aad u furto doorashooyinka 7-Zip archive. Ikhtiyaarada sirta^{(Encryption )} ayaa dhanka midig ku yaal Geli furaha sirta ah ee adag oo gaar ah, ka dib tabo OK^(OK) .

Hadda, waa inaad gelisaa erayga sirta ah ka hor inta aanad furin mid ka mid ah xaashiyaha Excel ee ^(Excel)gudaha^(inside) kaydka. Laakin xaashida faafinta ee ka baxsan kaydka lama ilaaliyo erayga sirta ah. Dooro xaashiyaha Excel^(Excel) ee aan sirta ahayn ee la ilaaliyo (ka baxsan kaydka) oo tirtir.

3. Windows Encrypting System File System^{(3. Windows Encrypting File System)}

The Windows Encrypting File System ( EFS ) waa nidaamka isku-dhafan ee Windows ee faylasha gaarka ah. EFS way ka duwan tahay Bitlocker , oo aad u isticmaasho sirta diskka buuxa. Taa baddalkeeda, EFS waxay ku shaqeysaa saldhig fayl-fayle ah, oo ku habboon lambarka sirta ah-ilaalinta xaashida Excel .

Si aad u isticmaasho EFS si aad u sirayso faylkaaga, midig-guji xaashida xaashida ee Excel oo dooro Properties . Hadda, door Advanced, ka dibna calaamadee sanduuqa si aad u xafiddo waxa ku jira si aad u xafiddo xogta^{(Encrypt contents to secure data)} . Riix OK , ka dibna Codso.^(Apply.)

Digniinta sirta^{(Encryption Warning)} ayaa soo bixi doonta. Waxay sharxaysaa in siraynta hal fayl ay sababi karto arrin xaalado gaar ah jira iyo in siraynta galka oo dhan ay bixiso ilaalin dheeraad ah. Haddii faylku ku jiro galka inta badan la galo, waa inaad furto galka mar kasta oo aad rabto inaad gasho fayl kasta. Hal dariiqo oo tan ah waa inaad geliso faylkaaga qoraal gal gaar ah oo aad tan u isticmaasho sidii galkaaga badbaadsan.

Kadib markaad xaqiijiso doorashadaada, Nidaamka Faylka Sireeynta^{(Encrypting File System)} ayaa ku weydiin doona haddii aad rabto inaad kaydiso furaha sirta. Waxaad isticmaali kartaa kaydinta furaha sirta ah haddii aad ilowdo eraygaaga sirta ah ee qarsoodiga ah.

Dhoofinta Keydkaga Furaha sirta^{(Exporting Your Encryption Key Backup)}

Haddii aad doorato inaad dhoofiso kaydka furahaaga sirta ah si aad u hesho ammaan dheeraad ah, Wizard Dhoofinta Shahaadada Microsoft^{(Microsoft Certificate Export Wizard)} wuu socon doonaa. Saaxirku wuxuu kugu hagi doonaa abuurista iyo dhoofinta furahaaga sirta ah ilaha warbaahinta dibadda, sida USB flash drive.

Ka dooro beddelka macluumaadka shakhsiyeed^{(Personal Information Exchange)} bogga koowaad, oo hubi Dhoofinta dhammaan guryaha la fidiyay^{(Export all extended properties)} . Bogga xiga, waa inaad gelisaa furaha sirta ah ee aaminka ah oo gaar ah^{( input a secure and unique password)} si eraygaaga sirta ah u ilaaliyo faylashaada. U beddel nooca sirta ah AES256 -SHA256^{(AES256-SHA256)} ( sirin extremely strong encryption!Riix dhame^(Finish) si aad u dhamaystirto hawsha

Marka hawshu dhammaato, waxa aad arki doontaa summada quful yar oo ku taal summada qoraalka Notepad , oo tusinaysa heerka sirta ah.

4. AxCrypt

Qalab kale oo anfacaya oo loogu talagalay ilaalinta erayga sirta ah xaashida Excel waa AxCrypt , qalab sir sir ah oo anfacaya haddana awood leh.

Soo deji oo rakib AxCrypt . Marka ugu horeysa ee aad socodsiiso AxCrypt , waa inaad dhex martaa habaynta. Muhiimad ahaan, waa inaad bixisa ciwaanka iimaylka dhabta ah inta lagu jiro nidaamka isdiiwaangelinta, haddii kale ma heli doontid shatiga AxCrypt ee bilaashka ah. Kadib markaad hesho koodka, koobiy oo ku dheji AxCrypt^(AxCrypt) ka hor intaadan sii wadin.

Waxaad sidoo kale u baahan tahay inaad abuurto erayga sirta ah ee AxCrypt^(AxCrypt) xoog leh oo gaar ah. Furaha sirta ah ee AxCrypt wuxuu^(AxCrypt) u shaqeeyaa furaha sirta iyo furaha furaha xaashida Excel . U fiirso digniinta AxCrypt . Soo celinta eraygaaga sirta ah waxay u oggolaanaysaa gelitaanka koontada la xidhiidha faylalka. Ma oggolaan doonto inaad furto faylasha lagu xafiday sirta hore.

Markaad diyaargarowdo, jiid oo ku rid feylka xaashida xaashida ee Excel daaqada ^(Excel)AxCrypt . Haddii aad gasho AxCrypt , waxay si toos ah u qarin doontaa faylashaada. Sidoo kale, haddii aad gasho AxCrypt oo aad isku daydo inaad furto fayl, ma soo bandhigi doonto sirta degdega ah. Haddii aad xirto AxCrypt (kaaso sidoo kale kaa saaraya), waxaad heli doontaa degdeg ah erayga sirta ah markaad isku daydo inaad furto xaashida.

AxCrypt waa qalab sir ah oo bilaash ah, waana sababta ay ugu muuqato liiskayada barnaamijyada bilaashka ah ee Windows^{( list of the best Windows freeware programs)} .

Waa maxay Habka ugu Wanaagsan ee Looga Ilaalin Karo Warqadda Faafinta ee Excel?^{(What’s The Best Way To Password Protect An Excel Spreadsheet?)}

Waagii hore, adeegsiga ilaalinta sirta isku dhafan ee Microsoft Office si erayga sirta ah loo ilaaliyo faylka ^{(Microsoft Office)}Excel ama xaashida waxay ahayd khatar. Algorithm-ka sireedku ma ahayn mid xooggan oo wuxuu lahaa nuglaanta badan, taasoo ka dhigtay mid aan la isticmaali karin. Sida Microsoft Office hadda u isticmaasho AES-256 , waxaad ku nasan kartaa in ilaalinta sirta ah ee xaashidaada Excel ay tahay mid la aamini karo oo aan macquul ahayn in la jebiyo iyadoo la adeegsanayo tignoolajiyada hadda jirta.

Sida ilaalinta erayga sirta ah ee isku-dhafan oo keliya ay gacanta ku hayso hal fayl markiiba, waxa kale oo aad tixgelin kartaa 7-Zip sirta doorashada. Haddii aad la macaamilayso mugga weyn ee xaashida Excel ee aad rabto inaad ilaaliso, erayga sirta ah ee ilaalinaya dhammaantood hal kayd (oo leh eray sir ah oo xooggan oo gaar ah!) Waa ikhtiyaar ku habboon oo sidoo kale adeegsada AES-256 .

Ma la yaabban tahay furaha sirta ah ee xooggan oo gaar ah? Fiiri siyaabahan fudud ee aad ku samaysan karto furaha sirta ah ee aad had iyo jeer xasuusan doonto^{( to create a password you’ll always remember)} .

How to Securely Password Protect an Excel File

Microѕoft Excel remains the most popular spreadsheet application in the world. Excel spreadsheet datа is often sensitive, containing perѕonal or financial datа. Understandably, you might consider additional рrotectiоn for your Excel files, such as a password.

You can password protect any Excel file using several options, including the integrated Excel password tool or third-party Excel password options.

1. Password Protect An Excel Sheet Using Integrated Tool

The first option for Excel password protection is an integrated tool. The entire Microsoft Office suite has a password protection tool you can use to secure your Excel spreadsheets, Word documents, PowerPoint presentations, and so on.

In Excel, head to File > Info. Select Protect Workbook, then Encrypt with Password from the dropdown menu.

Now, enter a secure password for your Excel spreadsheet. Ensure your password is strong and unique, press OK, then re-enter your password to confirm.

Next time you attempt to open the Excel spreadsheet, you’ll meet the password entry form.

New to Excel? Check out our Microsoft Excel basics tutorial to learn the ropes – fast!

How Secure Is Microsoft Office Password Protection?

Microsoft Office 97-2003 used a very poor encryption standard, known as RC4. The older encryption algorithm has numerous vulnerabilities, which makes cracking the password on an older Excel document incredibly easy.

Microsoft Office 2007-2013 saw an upgraded encryption algorithm, switching to the much stronger AES-128 algorithm. Office 2016-2019 uses the AES-256 encryption algorithm, which is unbreakable within a reasonable timeframe using existing technology.

Extra Excel Protections

Microsoft Excel has a few extra security features, too:

• Mark as Final: Marks the file as complete, which informs other users of the spreadsheet that they should not make any changes. However, marking a spreadsheet as final does not provide any additional password protection.
  
• Protect Current Sheet: You can add a small additional layer of protection to a specific spreadsheet within your workbook when you password protect an Excel sheet. People with access to the Excel file can still see the spreadsheet but cannot make any changes without the correct password. You can use a different password for this option, too.

• Restrict Access: An option large organizations can use to restrict access to certain individuals using security templates or other identifiers.
  
• Add a Digital Signature: The digital signature option verifies that the file remains untampered between the sender and recipient, ensuring the content is the same.

You might use a combination of additional security features alongside the Excel spreadsheet password protection option, especially if you’re sharing an Excel spreadsheet.

2. 7-Zip

A great method for encrypting multiple Excel files at the same time is to use the free archive tool, 7-Zip to password protect multiple Excel files. You can use 7-Zip to encrypt a whole folder of individual Excel files, password protecting an entire selection of Excel spreadsheets rather than one at a time.

First, download and install the latest version of 7-Zip. Once installed, head to the folder containing your Excel spreadsheets. Now, drag your mouse cursor over the files you want to password protect to select them all. Alternatively, hold CTRL and left click to select individual files with your mouse.

After finalizing your selection, right-click and select 7-Zip > Add to Archive to open the 7-Zip archive options. Encryption options are on the right. Enter a strong and unique password, then press OK.

Now, you must enter a password before opening any of the Excel spreadsheets inside the archive. But the spreadsheets outside the archive are not password protected. Select the non-password protected Excel spreadsheets (outside the archive) and delete them.

3. Windows Encrypting File System

The Windows Encrypting File System (EFS) is Windows integrated encryption system for individual files. EFS is unlike Bitlocker, which you use for full disk encryption. Instead, EFS works on a file-by-file basis, perfect for password-protecting an Excel spreadsheet.

To use EFS to encrypt your file, right-click the Excel spreadsheet and select Properties. Now, select Advanced, then check the box to Encrypt contents to secure data. Press OK, then Apply.

The Encryption Warning will appear. It explains that encrypting a single file can cause an issue under certain circumstances and that encrypting the entire folder offers more protection. If the file is in a frequently accessed folder, you’ll have to unlock the folder each time you want to access any other file. One way around this is to place your text file in a separate folder and use this as your secure folder.

After confirming your selection, the Encrypting File System will ask you if you want to take a backup of the encryption key. You can use the encryption key backup if you forget your decryption password.

Exporting Your Encryption Key Backup

If you choose to export your encryption key backup for additional security, the Microsoft Certificate Export Wizard will run. The wizard will guide you through the creation and export of your encryption key to an external media source, such as a USB flash drive.

Select Personal Information Exchange from the first page, and check Export all extended properties. On the next page, you must input a secure and unique password to password protect your files. Switch the encryption type to AES256-SHA256 (extremely strong encryption!), then give your encryption key backup a filename. Press Finish to complete the process.

Once the process is complete, you’ll see a small lock icon on the Notepad text file icon, indicating its encryption status.

4. AxCrypt

Another handy tool for password protecting Excel sheets is AxCrypt, a handy yet powerful encryption tool.

Download and install AxCrypt. The first time you run AxCrypt, you’ll have to run through the setup. Importantly, you must provide a real email address during the sign-up process, or else you won’t receive your free AxCrypt license. After receiving the code, copy and paste it into AxCrypt before continuing.

You also need to create a strong and unique AxCrypt password. The AxCrypt password acts as the encryption and decryption key for your Excel spreadsheets. Take heed of the AxCrypt warning. Restoring your password will only allow access to the account associated with the files. It will not allow you to decrypt files secured with an old password.

When you’re ready, drag and drop an Excel spreadsheet file into the AxCrypt window. If you are signed into AxCrypt, it will encrypt your files automatically. Similarly, if you are logged into AxCrypt and attempt to open a file, it will not present a password prompt. If you close AxCrypt (which also logs you out), you will receive a password prompt when you attempt to open the spreadsheet.

AxCrypt is a free encryption tool, which is why it features in our list of the best Windows freeware programs.

What’s The Best Way To Password Protect An Excel Spreadsheet?

In the old days, using Microsoft Office’s integrated password protection to password protect an Excel file or sheet was risky. The encryption algorithm was not strong enough and had multiple vulnerabilities, rendering it unusable. As Microsoft Office now uses AES-256, you can rest assured that the password protection on your Excel spreadsheet is trustworthy and impossible to break using current technology.

As the integrated password protection only handles one file at a time, you might also consider the 7-Zip encryption option. If you are dealing with a large volume of Excel spreadsheets that you want to protect, password protecting all of them in a single archive (with a strong and unique password!) is a handy option that also uses AES-256.

Wondering about a strong and unique password? Check out these easy ways to create a password you’ll always remember.

Related posts

• Sida loo saaro, loo jebiyo, ama loo jebiyo erayga sirta ah ee Excel XLS ee la iloobay

• 3 siyood oo erayga sirta ah loo ilaaliyo File Excel

• Kudar Khadka Dib-u-Celinta Toosan ee Qorshaha Kala firdhisan ee Excel

• Sida loo sameeyo Histogram gudaha Excel

• Sida Loo Sameeyo Jadwalka socodka gudaha Word iyo Excel

• Sida loo isticmaalo Excel AutoRecover iyo AutoBackup Features

• Sida Loo Isticmaalo Shaqada YEARFRAC gudaha Excel

• Geli xaashida shaqada ee Excel Word Doc

• Sida loo daro oo loo daabaco sawirada asalka ah ee Excel

• Sida loo Furo Tusaalooyin Badan oo Excel ah

• Casharrada Aasaasiga ah ee Microsoft Excel - Barashada Sida loo Isticmaalo Excel

• Sida loo Helo Qiimaha Iswaafajinta gudaha Excel

• Isku xidh Unugyada u dhexeeya Xaashiyaha iyo Buugaagta Shaqada ee Excel

• Sida Si Toos ah Loogu Soo Kabto Dukumeenti Word OneDrive

• Sida loo isticmaalo Sparklines gudaha Excel

• Sida loo kala saaro Magacyada Hore iyo Dambe ee Excel

• Sida Loo Fahmo Maxaa-Haddii Falanqaynta Microsoft Excel

• Sida Loo Sameeyo Calaamadaha Erayga laga bilaabo xaashida faafinta ee Excel

• Sida Loo Sameeyo Liiska hubinta gudaha Excel

• Sida loo Kooxeeyo Waraaqaha Shaqada ee Excel