Excel2007 use ribbon commands to copy cells or ranges

Excel2007 use ribbon commands to copy cells or ranges

Select Start-> clipboard-> Paste to move a copy of a selected cell or range to the Windows Clipboard and Office Clipboard. After you perform the above copy operation, select the cell you want to paste and select Start-> clipboard-> paste.

In addition to using the Start-> clipboard-> Paste, you can also activate only the target cell and press ENTER. If you use this technique, Excel deletes the copied information from the Clipboard and cannot paste it again.

Note: If you are picking the "paste" button more than once before the sheep click the "Duplicate and IJ" button, Excel automatically displays the Office Clipboard taskbar. To prevent this taskbar from appearing, click the Options button at the bottom and clear the check box in the Automatically show Office Clipboard.

Understanding Office Clipboard
Whenever you cut or duplicate and L information from a Windows program, Windows stores information on the Windows clipboard, which is an area of computer memory. Each time you cut or copy information, Windows Replaces the information originally stored on the clipboard with new information that is cut or copied. Windows Clipboard can store data in a variety of formats. Because Windows manages the information on the Clipboard, it can be pasted into other Windows programs regardless of where the information is created.

Office has its own clipboard one by one Office Clipboard, which is available only in Office programs. Whenever you cut or copy information in an Office program, such as Excel, the program places the information on the Windows Clipboard and Office Clipboard. However, the information that the program handles on the Office Clipboard differs from processing the information on the Windows Clipboard. Instead of replacing information on the Office Clipboard, the program appends information to the Office Clipboard, and after many items are stored on the Clipboard, you can paste items individually or in groups.

If you are copying an area, you do not need to select a range that is exactly the same size before you click the Paste button, just activate the cell at the top left of the target area.