- Worldstart's Tech Tips And Computer Help - http://www.worldstart.com -
MS Excel: Insert and Paste In One Step
Posted By April On May 25, 2011 @ 8:25 PM In MS Excel,MS Office Help,Uncategorized | 2 Comments
Here’s a cool time-saving trick that I stumbled across the other day – I was moving around some rows in a worksheet, following the usual routine of adding the space needed then completing the copy / cut and paste into the new space.
Unfortunately, this means a lot of steps… add the needed blank rows / columns / cells, copy or cut the data, paste the data and then, if it was a cut situation, go back and remove the empty space that I had created.
Not a difficult task, and yet a bit of a pain.
At any rate, I was working on moving things around when I accidentally got ahead of myself and copied the rows before I inserted a new location into which I could place them.
Much to my surprise when I clicked the Insert button on the Home tab of the Ribbon…
…I found that my rows were pasted at the same time the space was inserted!
Of course I began to explore what I could do with this and found that it worked with cut material – the cut data was moved to it’s new location and the empty cells that the move created were removed at the same time.
As I continued to check things out I discovered that the process worked with rows, columns and cells… so pretty much anything you’d need to work with.
When I attempted this with cells that had officially been converted to table form I found that Excel didn’t always like what I was trying to do – but with plain old cells in a worksheet things went better than I ever could have hoped for.
All I can say for that little accidental find is WOW! Talk about making your work more efficient, I don’t think it could get any better than that.
Article printed from Worldstart's Tech Tips And Computer Help: http://www.worldstart.com
URL to article: http://www.worldstart.com/ms-excel-insert-and-paste-in-one-step/
URLs in this post:
 Image: http://www.worldstart.com/ms-excel-insert-and-paste-in-one-step/msex_insert_bttn_hometab/