The concept of protection available in the Review Tab of ribbon is used to apply the security to the workbook. The protected related features fall into three catagories.
Choose Review » Changes group » Protect Sheet to protect the worksheet.The Protect Sheet dialog box is displayed
Providing a password is optional but once a password is entered, then that password will be required to unprotect the worksheet.
Various options can be selected in which the sheet should be protected. Format Cells option is checked then Excel will not allow to format cells.
When somebody tries to format the cells, an error is generated as shown in the screenshot below.
To unprotect a protected sheet, choose Review » Changes group » Unprotect Sheet.
A prompt box appears to enter that password, if the sheet is protected with a password.
Three ways are provided to protect a workbook.
A workbook can be saved with a password. If any one tries to open the workbook, enter the password.
To add a password to a workbook, the bellow steps need to be followed.
To remove a password from a workbook, the same procedure is repeated Delete the existing password symbols in step 2.
To prevent others from performing certain actions in a workbook, protect the workbook’s structure and windows.
When a workbook’s structure and windows are protected, the user may not Add a sheet, Delete a sheet, Hide a sheet, unhide a sheet, etc., and may not be allowed to change the size or position of a workbook’s windows respectively.
To protect a worksheet’s structure and windows, follow the below mentioned steps.
Microsoft Excel Related Interview Questions
|Microsoft Excel Interview Questions||Microsoft Word Interview Questions|
|Microsoft Powerpoint Interview Questions||Microsoft Dynamics CRM Interview Questions|
|Microsoft Silverlight Interview Questions||Microsoft Outlook Interview Questions|
|Microsoft Entity Framework Interview Questions||Microsoft Azure Interview Questions|
|Microsoft Project Interview Questions||Microsoft Interview Questions|
|Microsoft Office 365 Interview Questions||Microsoft Sharepoint 2013 Interview Questions|
|Microsoft Power Bi Interview Questions|
Microsoft Excel Related Practice Tests
|Microsoft Excel Practice Tests||Microsoft Word Practice Tests|
|Microsoft Powerpoint Practice Tests||Microsoft Dynamics CRM Practice Tests|
|Microsoft Silverlight Practice Tests||Microsoft Outlook Practice Tests|
|Microsoft Entity Framework Practice Tests||Microsoft Azure Practice Tests|
Microsoft Excel Tutorial
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.