In spreadsheet programs, labels and constant values are always copied exactly to the new location; what happens to formulas when they are copied depends on whether they use relative cell referencing or .

absolute cell referencing

Explanation:

Excel has an A1 reference style, which means that the columns are called letters A to XFD and the rows have numbers, 1 to 1,048,576. The total number of columns in Excel 2007 is 16384.

A cell can contain a value, formula or constants. A formula begins with a sign = (equal). You can use values from other cells in your formula. To use another value, create a reference to the cell that contains the value you want to use in your formula.

When you copy a cell that contains a relative reference and paste it into another cell, the relative reference changes

When you copy a formula that contains relative references, the reference changes when you paste it into another cell.

How much the reference changes in relation to the position of the copied cell and the position of the new cell in which the formula is pasted. Excel uses relative references by default.

Instead, an absolute reference in a formula remains the same if it is copied to another cell.