Forum Discussion

elizabethsimard's avatar
elizabethsimard
Copper Contributor
Oct 17, 2023

Basic Excel questions

Hi, I will have ongoing questions regarding Excel sheets so will use this thread to commence this ongoing dialogue.

 

Basic question #1 - the "delete" workbook is not available to me while working with the excel sheet online Microsoft 365.

#2 I wish to duplicate a sheet into a seperate workbook. The option to 'move or copy' is also not available to me. 

 

Thanks

1 Reply

  • elizabethsimard

    #1: Do you really mean delete workbook? This option is not available from within Excel. You'll have to do that in OneDrive.

    If you want to delete a worksheet:

    • Right-click the sheet tab.
    • Select 'Delete' from the context menu.
    • This option is only available if the workbook has more than one visible worksheet.

    #2: In Excel Online, you can only duplicate a worksheet within the same workbook. It does not have an option to move or copy a sheet to another workbook. You'll have to copy/paste all data from the source sheet to the target sheet in another workbook. Or edit the workbook in the desktop version of Excel.

Resources