Allow Excel ‘Paste Special’ to operate on ‘Cut’ data as well as ‘Copied’ data
When entering one of a few columns of data into a spreadsheet, I missed one number, so entered the others one row too high. To avoid re-entering all of the latter numbers, I tried to ‘Cut’ and use ‘Paste Special’ to move all the values down one row. (A simple ‘Cut’ and ‘Paste’ would have moved the references as well, achieving nothing except misaligning the rows.) After several frustrating attempts, I realized that I could only use ‘Paste Special’ if I ‘Copied’ the cells rather than ‘Cut’ them. Unlike cutting, this left the topmost incorrect cell with its value unchanged, so that I had to remember to overwrite it. Microsoft’s guidance doesn’t stress that data for ‘Paste Special’ must come from copying, not cutting, and I suspected a problem with my installation rather than a limitation of Excel. But I think it would be far better to make it possible to cut misplaced data cleanly and position it correctly with ‘Paste Special’ than to clarify the guidance.
Janet Coker commented
I work in a large database (no formulas) and set the filter to only "MI" addresses. I then tried to cut them out of my original database and move to another tab in the database. It kept cutting most of my database down to 20 addresses (from 1975 addresses with only 30 being MI). I kept having to undo what I was doing. I then had to "copy" the MI addresses to another tab, then use the "find" feature, search for "MI" and delete them one at a time.
Erik Nelson commented
yes, please, very frustrating right now
paste special options are not clear
Adding onto this, I would like to be able to "cut" without physically cutting those cells, just the content. Eg - I want to take data from one place and put it in another, but without affecting any formulas that are dependent on either the original or the destination cells. Currently to get this to work I would copy, paste then go and clear all from the original location.
Corey Becker commented
This always seemed like a no brainer to me. Cutting is often times easier because it doesn't update the formulas, but then you have to reformat the pasted cells to match the formatting of their new home.
Kenneth Barber commented
Usually, cut & paste is used to move stuff around, so you would want every property of your cut cells to be moved over. I suppose that more options for pasting after cutting wouldn't hurt, though.
One can paste special when you copy things, but one can not paste special when you cut things. Paste special should be an option after a cut.