To be able to move your data effectively, you must know how cut, copy, and paste cells. To cut and paste a cell, right click on the cell and select Cut from the drop down edit menu.

The cell will be surrounded by a dark and light flashing border. When you see this flashing border, move your mouse pointer to one of the borders edges and when it turns into a cross arrow, you can drag the cell to another location.

You will notice that the data has been removed (cut) from its original location and relocated in the place where you dropped it. You can also right click on a cell, select the Cut option, and then point and click or use the arrow keys to move to your destination. When you select a destination cell right click it and select Paste from the drop down menu. The data will be relocated in the destination cell and removed from its original location.

Often, data needs to be duplicated in another area of the worksheet without disturbing the original cells. To achieve this goal, use the Copy feature. To use Copy, once again right click on a data cell, but this time select Copy from the drop down menu instead of cut. The cell will once again have a dark and light flashing border. Now move to a new location as before, by dragging, pointing and clicking, or by using the arrow buttons. When you find a destination cell, right click on it and select Paste from the drop down menu.

The data will be pasted to its new location, and the original cell and data will remain unchanged.

Notice, that as long as the flashing dark and light border is around the source cell, you will be able to paste data that you copied from it. It is also important to remember that cutting and copying moves formatting information to the destination as well as the data.