Cut and delete/remove cells
When cutting & pasting information (rows or columns) from the middle of one sheet to another sheet or workbook I always think it's a real pain to have to go back to the first sheet to delete the empty rows or columns.
I'm no Excel expert, but I've never found a way around this?
So my idea is to have a (right click) "cut & delete" or "cut & remove" option?
Yeah. Cut a row on a worksheet to insert it somewhere else on the worksheet and it's really CUT. Gone from the original place.
Insert or paste it anywhere else in the world and it is still there. So you chose CUT but really got COPY. What's up with that?
Related: Highlight and copy a row. Paste or Insert it somewhere on the worksheet. Do it somewhere else too. Oh no... didn't work. Oh... it's still got the dancing ants but now somehow it is no longer a highlighted ROW that is copied, but rather a highlighted selection of a whole row's set of CELLS. And pasting or inserting is rather different then. Be nice to see that straightened out along with this.
But this one is super annoying. Having to go back and delete the material after CUTTING!