USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Protected
|
|
|
Hidden
|
|
|
Read only
|
|
|
Shared
|
Detailed explanation-1: -Locking cells in Excel has no effect until you protect the worksheet. This can be confusing, but Microsoft designed it this way, and we have to play by their rules :) On the Review tab, in the Changes group, click the Protect Sheet button. Or, right click the sheet tab and select Protect Sheet… in the context menu.
Detailed explanation-2: -Go to the Protection tab and uncheck Locked option and click Ok. Now select only the cells or columns, rows that you want to protect. Right click and choose Format cells again. Go to the protection tab and check Locked option and click Ok.
Detailed explanation-3: -By default, when you protect cells in a sheet or workbook, all of the cells will be locked. This means they can’t be reformatted or deleted, and the content in them can’t be edited. By default, the locked cells can be selected, but you can change that in the protection options.
Detailed explanation-4: -Locked Cells But even though cells may be locked, the “locking” doesn’t go into effect until the user also protects the worksheet. In order for the contents of a cell to be safe from being accidentally deleted, the cell must be locked AND the worksheet or entire workbook protected.