SOLVED

copying worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-976922%22%20slang%3D%22en-US%22%3Ecopying%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-976922%22%20slang%3D%22en-US%22%3E%3CP%3EI%20used%20to%20be%20able%20to%20right%20click%20on%20a%20tab%20and%20select%20copy%20and%20it%20would%20duplicate%20the%20exact%20same%20information%20onto%20a%20new%20tab.%26nbsp%3B%20Now%20I'm%20unable%20to%20do%20it%20-%20what%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-976922%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-977091%22%20slang%3D%22en-US%22%3ERe%3A%20copying%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-977091%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F439657%22%20target%3D%22_blank%22%3E%40sbates421%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20Sandra.%20Please%20try%20the%20following%3A%3C%2FP%3E%3CP%3Eright-click%20on%20the%20tab%20that%20you%20want%20to%20copy%2C%3C%2FP%3E%3CP%3Echoose%20%22Move%20or%20Copy%2C%22%3C%2FP%3E%3CP%3Eput%20a%20checkmark%20on%20%22create%20a%20copy%2C%22%3C%2FP%3E%3CP%3Eclick%20OK.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20option%20to%20copy%20is%20greyed%20out%2C%20maybe%20your%20workbook%20is%20Protected%20to%20avoid%20changes%20in%20the%20structure%20of%20the%20workbook.%20You%20can%20check%20that%20by%20going%20to%20the%20tab%20%22Review%22%20on%20the%20top%20ribbon%20and%20verifying%20if%20the%20button%20%22Protect%20Workbook%22%20is%20highlighted%2C%20or%20going%20to%20the%20tab%20%22File%22%20and%20checking%20the%20information%20there.%3C%2FP%3E%3CP%3EThese%20instructions%20are%20based%20on%20Excel%20in%20Office%20365.%20Other%20versions%20may%20require%20different%20steps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-977307%22%20slang%3D%22en-US%22%3ERe%3A%20copying%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-977307%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EKindly%20close%20the%20workbook%20and%20reopen%20and%20try%20to%20duplicate%20the%20sheet%20tab.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-977568%22%20slang%3D%22en-US%22%3ERe%3A%20copying%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-977568%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F439657%22%20target%3D%22_blank%22%3E%40sbates421%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%20File-%26gt%3BInfo%20of%20your%20workbook%2C%20sheets%20and%20workbook%20structure%20are%20protected.%20To%20unprotect%20click%20on%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20579px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F154539i0FB67952EAD92D67%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eand%20enter%20password%20with%20which%20the%20workbook%20was%20protected%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20269px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F154540iEF67BC1965682C8F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-981979%22%20slang%3D%22en-US%22%3ERe%3A%20copying%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-981979%22%20slang%3D%22en-US%22%3Ethank%20you%2C%20but%20it%20did%20not%20work%20-%20Sergei%20Baklin's%20response%20worked.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1550028%22%20slang%3D%22en-US%22%3ERe%3A%20copying%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1550028%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20the%20Review%26gt%3BUnprotect%20doc%20with%20no%20results.%20I%20then%20tried%20your%20technique%20of%20going%20to%20File%26gt%3BInfo%26gt%3BUnprotect...%20still%20didn't%20work%2C%20even%20after%20I%20saved%20it%2C%20closed%20it%2C%20and%20reopened%20it.%20Any%20other%20thoughts%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1551428%22%20slang%3D%22en-US%22%3ERe%3A%20copying%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1551428%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F742299%22%20target%3D%22_blank%22%3E%401441engraving%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20only%20structure%20is%20protected%20it%20shall%20work.%20Same%20from%20this%20menu%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20454px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F208563i61C6A1C9D1117D3A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIf%20workbook%20is%20encrypted%20with%20password%20protection%2C%20when%20Save%20As%20and%20here%20in%20Tools%2C%20General%20options%20remove%20password%20before%20saving%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20564px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F208564iE88D59350DC2A11D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1935968%22%20slang%3D%22en-US%22%3ERe%3A%20copying%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1935968%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20answer.%20That's%20exactly%20what%20I%20was%20looking%20for.%3C%2FP%3E%3CP%3EThere's%20one%20problem.%20I%20don't%20know%20the%20password%20because%20the%20person%20who%20made%20this%20document%20doesn't%20work%20at%20my%20office%20anymore.%3C%2FP%3E%3CP%3EDo%20you%20know%20how%20to%20fix%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1936343%22%20slang%3D%22en-US%22%3ERe%3A%20copying%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1936343%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F883579%22%20target%3D%22_blank%22%3E%40X-el_1972%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ENope%2C%20the%20only%20way%20I%20know%20is%20to%20find%20that%20person%20and%20ask%20him%2Fher%20password.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 

8 Replies

@sbates421 

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.

 

 

Hello,

Kindly close the workbook and reopen and try to duplicate the sheet tab.
best response confirmed by sbates421 (New Contributor)
Solution

@sbates421 

Please check File->Info of your workbook, sheets and workbook structure are protected. To unprotect click on

image.png

and enter password with which the workbook was protected

image.png

thank you, but it did not work - Sergei Baklin's response worked.

@Sergei Baklan 

I've tried the Review>Unprotect doc with no results. I then tried your technique of going to File>Info>Unprotect... still didn't work, even after I saved it, closed it, and reopened it. Any other thoughts? 

@1441engraving 

If only structure is protected it shall work. Same from this menu

image.png

If workbook is encrypted with password protection, when Save As and here in Tools, General options remove password before saving

image.png

@Sergei Baklan 

Thanks for your answer. That's exactly what I was looking for.

There's one problem. I don't know the password because the person who made this document doesn't work at my office anymore.

Do you know how to fix this?

 

@X-el_1972 

Nope, the only way I know is to find that person and ask him/her password.