USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Opening a file
|
|
Formatting cells, columns, and rows on a worksheet
|
|
inserting a new worksheet, deleting a worksheet
|
|
Deleting a file
|
Detailed explanation-1: -Remove a workbook password Open the workbook that you want to remove the password from. On the Review tab, under Protection, click Passwords. Select all contents in the Password to open box or the Password to modify box, and then press DELETE.
Detailed explanation-2: -Require a password to open a workbook Open the workbook that you want to protect. On the Review tab, under Protection, click Passwords. In the Password to open box, type a password, and then click OK. In the Confirm Password dialog box, type the password again, and then click OK.
Detailed explanation-3: -One of the main reasons why you can’t delete a sheet on Microsoft Excel is if your workbook is protected. To confirm this, try checking if your workbook is protected and unprotect it in the meantime to delete your sheets.