Japanese version. There are two methods of cell referencing (specifying cells in formulas and functions): relative cell reference and absolute cell Reference. Two Cell Reference Relative cell reference When Auto Fill or Copy and Paste formulas with cell references, the position of the cell reference shifts one by one.This is a relative cell reference. If you specify a cell reference without being aware of it, it becomes a relative cell reference. Absolute Cell Reference This is a method of specifying that Auto Fill or Copy and Paste formulas with cell references does not change the position of the cell references. Absolute cell references are set by prefixing the reference you … Continue reading Relative cell reference and Absolute cell reference.(Microsoft Excel)