Forum Discussion

Brian Lambert's avatar
Brian Lambert
Copper Contributor
Oct 02, 2018

Insert Rows command missing on my right click menu after I copy cells

Before the latest update of excel in Office 365, I could copy a range of cells, and then right click on my mouse and it would give me an option to insert copied cells or insert rows.  I could insert rows, and then paste my information.   Now this is missing.  When I copy now, I only get the insert copied cells option.  And if I try to insert rows, it empties the clipboard.  This was a really nice command for me.  Does anyone know why this has been removed?

6 Replies

  • Bobert00752's avatar
    Bobert00752
    Copper Contributor

    This has been a pain for a couple of weeks now.  I’m having the problem when copying a block of rows and then inserting the copied rows into the same place IN THE SAME SPREADSHEET.  For example if I have 20 rows for the same date but for different stocks, copy rows and insert duplicates the data and you can then (or could) change the date and add the new data for that date.  It is so much simpler than now as I have to insert the same number of blank rows and then doing a copy and paste - twice as long in fact. 

    Microsoft ought to consider refunding the cost of the product (pro rata) for each time this clearly clumsy developer removal of functionality continues.  If it is due to AI then it is intelligence, but not as we on earth know it!

  • rosskelleway's avatar
    rosskelleway
    Copper Contributor

    I have the same in o365 Excel (Microsoft® Excel® for Microsoft 365 MSO (16.0.13929.20406) 64-bit)

     

    This is a really annoying miss.  Just because I copy/cut cells to paste, does not mean this is exactly my next move.  Really want the insert rows/columns on right click no matter what is in the "clipboard"

  • Deleted's avatar
    Deleted
    Not applicable

    I have the exact opposite. Suddenly I am missing insert/delete cells from Excel. I can only add or delete rows! 

    Anyone have this happen and know of a fix for it?

    • djbillyd's avatar
      djbillyd
      Copper Contributor

      Deleted wrote:

      I have the exact opposite. Suddenly I am missing insert/delete cells from Excel. I can only add or delete rows! 

      Anyone have this happen and know of a fix for it?


      I only get the "Insert Copied Cells" as well. There is such a nice video that applies to something else entirely.