Pasting Multiple Copied Ranges Using the Clipboard in Microsoft Excel 2010

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/excel-keyboard-shortcuts/pasting-multiple-copied-ranges-using-the-clipboard.html
SHARE




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.

Please follow and like us:
0


Leave a Reply

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

To avoid automated spam,Please enter the value *

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>