Excel 2010: Cell References
http://www.gcflearnfree.org/excel2010In order to maintain accurate formulas, it is necessary to understand how cell references respond when you copy or fill them to new cells in the worksheet.Excel will interpret cell references as either relative or absolute. By default, cell references are relative references. When copied or filled, they change based on the relative position of rows and columns. If you copy formula (=A1+B1) into row 2, the formula will change to become (=A2+B2).Absolute references, on the other hand, do not change when they are copied or filled and are used when you want the values to stay the same.Watch the video to learn how to copy and fill relative and absolute references.If you are interested in learning more about this topic, please visit our site to view the entire tutorial on our website. It includes instructional text, informational graphics, examples, and even interactives for you to practice and apply what you've learned.