Pasting Multiple Copied Ranges Using the Clipboard in Microsoft Excel 2010

 

The Clipboard in Excel is an extension of the Windows clipboard. It holds only the last item copied. Excel clipboard can hold up-to 24 different entries.

If you want to enter data, the entry is easy if you use the clipboard to paste data into a worksheet. Let’s see how we can do this.

 

Copying multiple entries to the clipboard:-

 

o Go to the home tab on the ribbon.

 

image1

 

1. Click on the clipboard dialog box launcher to open the clipboard viewer.
2. The clipboard viewer must be open in order to use it.
3. Go to options on the clipboard viewer.

 

image4

 

1. Now check “show office clipboard when Ctrl + C pressed twice”.
2. Go to any of the cells and press Ctrl + C + C.
3. Go to the target cell and just click on the clipboard on the clipboard viewer.



Example:


Leave a Reply

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

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>