Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
Through review tab we can protect of worksheet in Excel.
NOTE Protect Sheet changes to Unprotect Sheet when a worksheet is protected.
Keyboard shortcut You can also press CTRL+SHIFT+F or CTRL+1.
NOTE This unlocks all the cells on the worksheet when you protect the worksheet.
Keyboard shortcut You can also press CTRL+SHIFT+F or CTRL+1.
More information about worksheet elements
NOTES
IMPORTANT To give specific users permission to edit ranges in a protected worksheet, your computer must be running Microsoft Windows XP or later, and your computer must be on a domain. Instead of using permissions that require a domain, you can also specify a password for a range.
NOTE This command is available only when the worksheet is not protected.
TIP You can also click the Collapse Dialog button, select the range in the worksheet, and then click theCollapse Dialog button again to return to the dialog box.
NOTE Specifying a password is optional when you plan to use access permissions. Using a password allows you to see user credentials of any authorized person who edits the range.
TIP To see how user names should be entered, click examples. To verify that the names are correct, click Check Names.
TIP If prompted for a password, type the password that you specified.
NOTES
NOTES
if we wand to protect work sheet take protect sheet then creat password. protect click then creat password and re entere the pass word.
review tab > click protect of worksheet > choose opitions > write pass word > ok > rewrite pass word > ok
Open Excel Sheet ----> Go To Tool ---> Protection -----> Protect Sheet ..
Although there are also other option for protection.
go to review tab and click protection
Password protect worksheet or workbook elements
To prevent a user from accidentally or deliberately changing, moving, or deleting important data from a worksheet or workbook, you can protect certain worksheet or workbook elements, with or without a password. You can remove the protection from a worksheet as needed.
IMPORTANT Worksheet and workbook element protection should not be confused with workbook-level password security. Element protection cannot protect a workbook from users who have malicious intent. For optimal security, you should help protect your whole workbook file by using a password. This allows only authorized users to view or modify data in the workbook.
This displays the Picture Tools or Drawing Tools, adding the Format tab.
Tip You can also use the Go To command to quickly select all the graphic objects in a worksheet. On the Home tab, in the Editing group, click Find & Select, and then click Go To. Click Special, and then click Objects.
Note You do not need to unlock buttons or controls for users to be able to click and use them. You can unlock embedded charts, text boxes, and other objects created with the drawing tools that you want users to be able to modify.