Using Cut, Copy and Paste

Excel Tip. It s much better to select a single cell, then Paste, instead of selecting a destination range that is the same size as the copied or cut range. The selected cell will be the upper left corner of the pasted range of cells. 

You can also Copy or Cut text in the formula bar and Paste it in a worksheet cell. Select the text to be copied or cut, then press the Copy or Cut toolbutton or choose the appropriate command from the Edit menu. Complete the operation by clicking the Enter button in the formula bar. Then Paste in the desired cell. 

---