Excel® 2013 On Demand

Understanding How Excel Pastes Data

If you want to use data that has already been entered on your worksheet, you can cut or copy it, and then paste it in another location. When you cut or copy data, the data is stored in an area of memory called the Clipboard. When pasting a range of cells from the Clipboard, you only need to specify the first cell in the new location. After you select the first cell in the new location and then click the Paste button, Excel automatically places all the selected cells in the correct order. Depending on the number of cells you select before you cut or copy, Excel pastes data in one of the following ways:

• One to one. A single cell in the Clipboard is pasted to one cell location.

• One to many. A single cell in ...