Forum Discussion
Solved
copying worksheet
I used to be able to right click on a tab and select copy and it would duplicate the exact same information onto a new tab. Now I'm unable to do it - what
Please check File->Info of your workbook, sheets and workbook structure are protected. To unprotect click on
and enter password with which the workbook was protected
Hi, Sandra. Please try the following:
right-click on the tab that you want to copy,
choose "Move or Copy,"
put a checkmark on "create a copy,"
click OK.
If the option to copy is greyed out, maybe your workbook is Protected to avoid changes in the structure of the workbook. You can check that by going to the tab "Review" on the top ribbon and verifying if the button "Protect Workbook" is highlighted, or going to the tab "File" and checking the information there.
These instructions are based on Excel in Office 365. Other versions may require different steps.