Introduction to Biological Sciences lab, first semester

There are several differences between Cut and Copy. The most obvious is that when you use cut, the values disappear from the source cells. However, there is also another important but less obvious difference. Let's say that cell C1 contains the formula =A1+B1 . If cell C1 is copied and pasted into cell C5, cell C5 will contain the formula =A5+B5 . However, if cell C1 is cut and pasted into cell C5, cell C5 will contain the formula =A1+B1 . In other words, when a cell is cut, the original cell references remain the same and are not adjusted relative to the position into which the paste occurs.

There is a similar effect if one cuts a cell that is used as an argument in a formula. In the previous example, if cell A1 were copied and pasted elsewhere on the spreadsheet, it would have no effect on the value of cell C1. However, if cell A1 were cut and pasted into cell Z27, the formula in cell C1 would change to =Z27+B1 . Again, cutting a cell maintains the original cell reference.

Empty cells may or may not be treated as a zero in formulas depending on what the formulas do. Excel usually does a good job of guessing what will do the least damage under the circumstances, but in some cases (e.g. dividing by an empty cell) there is no hope for you. So be careful.

If you want to delete the contents of a cell or cells, highlight those cells and press the delete key. The highlighted cells will be empty as they are after a cut operation, with the important difference that they are not available in the clipboard for pasting.

If you want to actually eliminate cells entirely, highlight those cells. On the Home ribbon, click on the drop-down arrow by Delete in the Cells group. You will have a choice about how you want Excel to move cells around to fill in the vacuum that you are going to create when you delete the cells.

See section 2.3.1 regarding whether Excel treats an empty cell as zero or not.

Imagine that you have numbers in cells A1:A5 and in cell A6 you have the formula =MAX(A1:A5). What happens if you cut or delete cell contents within that range or delete cells or rows within the range? Even though Excel maintains references to particular cells during a cut and paste operation (see 2.3.1), if cell A2 is cut and pasted into cell B5, Excel will not consider cell B5 when evaluating the function over a range containing the cut cell.

For additional practice, see the Biointeractive tutorials on Autofill Data, Cell References, and Standard Deviation.