Moving data within a worksheet can be tricky at first if there is a lot of information on the worksheet. If data is minimal, it is easier to move about within the worksheet. Data such as text, numbers, formulas and functions, and charts can be moved from one location to another. The nice thing about Excel is that a formula or function will recalculate with the new set of cells after the move.

There are two methods to choose from:

• Click in a cell and once it is highlighted, click the Cut button on the toolbar. A moving, perforated border will be seen on the selected cell to be moved. Click on the desired cell, and click the Paste button on the toolbar. The data is moved from the original location to its new location.

• Right mouse click on a cell and select the Cut option. The selected cell(s) is highlighted. Right mouse click on the new location and choose Paste. The information is moved to its new location.