Niste registriran korisnik
Izaberite jednu od opcija
1. Lajkajte stranicu na linku ispod ili kliknite zatvori ako ste već lajkali.
2. Registrirajte se.
Registracija
Post će se otvoriti nakon što izvršite opciju.

Lapan

Loading...

Lapan

Register
Learn more about computers, laptops, and phones, find out news from the world of technology, watch videos and listen to music, and much more!
Join now, click here!

- Premium - Computers - Desktops - Excel - Laptops - Microsoft Office - Software - Word - November 9, 2022

How to password-protect documents created in Microsoft Word and Excel

Users might wish to password-protect a Microsoft Word or Excel spreadsheet to stop others from opening it, adding to it, editing it, deleting data, or engaging in any other unlawful activity.
The document may be password-protected, requiring the user to input the password in order to open, view, or alter the document.
Additionally, a password can be established to block users from making changes to certain areas of the Excel document.
For instructions on how to add password security to a Word or Excel document, choose from the options below.

Protect Word & Excel document fully

Users of Microsoft Word and Excel may learn how to password-protect each page of their documents by following the steps below.
The fact that you should typically back up your file without the password in case you forget it cannot be overstated.
If you do, it is recommended to keep the unencrypted file on a USB stick rather than locally.

Word & Excel 2010 and newer

  1. The spreadsheet or document you want to password-protect should be opened in Microsoft Word or Excel.
  2. Click the File tab.
  3. Select the Info link.
  4. Select Protect Document from the menu.
  5. To demand a password to open the document, click Encrypt with Password, or Restrict Editing to prevent other users from making changes to the document.
  6. Click Ok after entering the password in the area designated for it.
  7. Re-enter the password in the text box labeled Reenter Password, then click Ok.
  8. To save the new password, save the file.
See  How to create an email account?

Word & Excel 2007

  1. The spreadsheet or document you want to password-protect should be opened in Microsoft Word or Excel.
  2. Click the Microsoft Office button in the top left corner of the screen.
  3. Move the mouse pointer over Prepare in the pop-up menu and select Encrypt Document.
  4. Enter the password in the password input form after making your choice, then click Ok.
  5. In the Reenter Password text box, enter the password once more, then click Ok.
  6. To save the new password, save the file.

Password to open – Only those who know the password will be able to access the file.

Password to modify – This option allows people to view the file, but only those who have the password may change and save it.
However, take note that a user has the option to open a file and then copy its information into another document.

Removing a password – To remove a password on a document that is password-protected, follow the instructions in the preceding section, but erase the characters you put in the Password field.

Protect certain areas of an Excel document

To stop alterations, protection may be set up in an Excel spreadsheet for specific cells, a single worksheet, or the entire workbook.
It is impossible to add, modify, or remove data from protected cells, worksheets, or workbooks. Additionally, it is possible to prevent the deletion or modification of macros in a worksheet.

To protect a worksheet or particular cells in a worksheet, follow the instructions below for your version of Excel.

Excel 2007 and newer

  1. Choose the cells you wish to keep safe.
  2. Select Protect Sheet from the Review tab by clicking it.
  3. Make sure the Select Unlocked Cells checkbox is selected in the Protection Sheet window.
    Ensure that the Select Locked Cells checkbox is not selected.
  4. Click Ok after entering a password to secure the worksheet.
  5. When asked, enter the same password again to confirm security.
See  Case fan and 3-pin fan connectors

You can stop users from changing the values in the cells you’ve chosen to protect by following the aforementioned procedures.
Only the cells you haven’t chosen will be left open to users’ additions and deletions of values.

Excel 2003 and older

  1. Choose the cells you wish to keep safe.
  2. Format Cells can be chosen by right-clicking the cells.
  3. Click the Protection tab in the Format Cells box.
  4. Select the Locked checkbox, then click Ok.
  5. Select Protect Sheet under Tools -> Protection from the Excel main menu.
  6. Enter a password in the Protect Sheet window to secure the worksheet, then click Ok.
  7. When asked, enter the same password again to confirm security.

Share this with your friends...