Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
|
How To Use Collect And Paste In Excel?
Posted by - NA - on 30 March 2006 08:19 AM
|
|
|
Solution: Office 2000 programs have a new Collect and Paste feature. To see how this works, let's use an Excel worksheet as an example. Run Excel and enter some numbers into cells B1 through B5. Now, click cell B2 and press Ctrl + C to copy the cell's value to the Clipboard. Now, move to cell B4 and press Ctrl + C again. The Clipboard should now appear. If it doesn't, choose View/Toolbars/Clipboard. When the Clipboard appears it will show two Excel icons. Click in cell D1 and click the first icon on the left side of the Clipboard. This will paste the number from cell B2 into cell D1. Next, click cell E1 and then click the second Excel icon in the Clipboard to paste the contents of cell B4 into cell E1. You can click the X in the upper right corner of the Clipboard to close it. | |
 (113 vote(s)) This article was helpful This article was not helpful |
|
Comments (0)