www.gcflearnfree.org/excel2010 In 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 at www.gcflearnfree.org/excel2010 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. We also have instructor supported online classes that are completely free and will earn you accredited Continuing Education Units and a Certificate of Completion. Register today! www.gcflearnfree.org/classes/excel2010

Be the first to comment