Forum Discussion

Tony_Aneke's avatar
Tony_Aneke
Copper Contributor
Jul 24, 2023

My 2016 excel moves sheets instead of copying the sheet.

I'm using 2016 Microsoft office. Each time I want to copy an excel sheet, it will move the sheet instead of copying it.

 

How do I solve this problem, please.

 

Pernille-Eskebo 

10 Replies

  • tanayprasad's avatar
    tanayprasad
    Brass Contributor

    Tony_Aneke 

    • Click on the sheet tab that you want to copy.
    • Right-click on the sheet tab to open the context menu.
    • In the context menu, select "Move or Copy..."
    • In the "Move or Copy" dialog box, choose the destination workbook from the "To book" dropdown (if copying to a different workbook).
    • Check the box next to "Create a copy" at the bottom-left corner of the dialog box.
    • Click "OK" to copy the sheet.

     

    • Tony_Aneke's avatar
      Tony_Aneke
      Copper Contributor

      tanayprasad  

      Thanks for your reply.

      But I know of the process and judiciously follow it every time I want to copy a sheet in my excel but the sheet will be moved instead of copying.

       

      Any further help please?

Resources