Microsoft Excel Notes

Microsoft Excel Notes


Relative reference - when the "fill handle" is dragged and formulas change automatically adjusting for the new position.Absolute reference - when the "fill handle" is dragged the same cell reference is kept where a "$ " is added.3-D Reference - combines sheet reference and cell reference.
l For example: =SUM(Sheet1:Sheet3!B1:B3) adds all the values from B1 to B3 in all the sheets from Sheet1 to Sheet3.
l The "!" separates the

Read more ...