How To Use Clipboard To Copy And Paste Multiple Items In Excel

Date:2021-8-20 Author:Sandra

If your superior asks you to copy from one worksheet to a specific location on another worksheet. What would you do? Will you choose to copy and paste one by one? Come on, that’s just a waste of time. There is a choice called Clipboard, I’ll show you how to use it.

If we need to copy the content in the yellow box and paste it into the blue cells. Of course, they are in different sheets.

How To Use Clipboard To Copy And Paste Multiple Items In Excel
How To Use Clipboard To Copy And Paste Multiple Items In Excel

Just go to the Home tab and click on the arrow to open Clipboard.

How To Use Clipboard To Copy And Paste Multiple Items In Excel

Now you can select the cells and press Ctrl and C to add to the clipboard.

How To Use Clipboard To Copy And Paste Multiple Items In Excel
How To Use Clipboard To Copy And Paste Multiple Items In Excel

Go to another worksheet and click the cell to add the item to paste.

How To Use Clipboard To Copy And Paste Multiple Items In Excel
How To Use Clipboard To Copy And Paste Multiple Items In Excel

In addition to text and data, pictures can also be copied into the clipboard. You can even copy the things out of Excel.

Ok, that’s all for today’s tutorial, hope this can be helpful.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *