Insert Copied Cells
When a data range is selected for copy (dancing ants around the cells), the options to Insert New Row or Insert New Column should be available. Currently you can only 'Insert Copied Cells'.
Perhaps this is difficult when working with a single worksheet (since inserting a new row/column changes the worksheet), but should be relatively easy when copying between sheets or books.
>Yeah, it's a pain. Just double click in a cell to kill the dancing ants and insert your row or column as you normally would.
Then you lose your clipboard. You lose either way.
Excel is just a mess. LibreOffice is a model of how excel should be. Fast, performant, and doesn't require 2-3x as many clicks when doing the same operation on 100's of spreadsheets.
I have several worksheets to update by adding one line. What I want to do is copy a cell and then go to another worksheet, insert a row, and paste the cell.
Instead I have to open the new worksheet, insert, go back to the original worksheet, select, copy, go back to the new worksheet, paste.
This is a huge productivity drain and it doesn't happen in direct competitors like OpenOffice.
Todd Hutchison commented
This was just a recent change that is a complete nightmare. They need to allow us the option of inserting blank cells again even when you have something currently copied. You used to always be able to do that, now it is completely gone.
Gary Middleton commented
There was once option previously where this issue was resolved and if I had copied cells, I could select to insert blank row or copied cells. Was incredibly handy feature. Now this creates a drop in productivity and a frustration considering it was available previously.
Chris Newman commented
I desperately what that option added!! I can't tell you how many times I still have something copied and want to just insert a blank row. Cue a frustrated sigh, hitting the Esc key to cancel the copy, and then trying again.......
Where has "insert copied cells" gone? I am trying to copy 5 rows from one excel spreadsheet into a seperate spreadsheet but the option for "insert copied cells" is not in the right-click drop down list any more... ??
Bill Johnson commented
This was available in earlier versions of excel using the Alt+i+e keystrokes, I MISS IT BAD!
Andrew Tonner commented
Cool, looks like the new "Insert" option does what we want. (This is from Office 365 June 7, 2017 Version 1705 - "Retain copy: Copy your cells, and before you paste, you can still do other tasks like typing or inserting cells.")
Al Claw commented
You can still insert; look closely at the right click menu; you will see a new item called "Insert" underneath "Insert Copied Cells".
Andrew Tonner commented
Could you give this suggestion a more obvious name, like "Don't hide Insert New Row/Column when there are copied cells"? The current name "Insert Copied Cells" is already something Excel can do. :)
Kenneth Barber commented
Yeah, it's a pain. Just double click in a cell to kill the dancing ants and insert your row or column as you normally would.