USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
New comment
|
|
|
Protect Sheet
|
|
|
Protect Cells
|
|
|
Protect Workbook
|
Detailed explanation-1: -On the Review tab, click Protect Sheet. In the Allow all users of this worksheet to list, select the elements you want people to be able to change.
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: -On the Review tab, in the Changes group, click the Protect and Share Workbook button. The Protect Shared Workbook dialog window will show up, and you select the Sharing with track changes check box.
Detailed explanation-4: -On the worksheet, select just the cells that you want to lock. Bring up the Format Cells popup window again (Ctrl+Shift+F). This time, on the Protection tab, check the Locked box and then click OK. On the Review tab, click Protect Sheet.