While in the formula in cell C2 refers to A2 and B2, the one in C3 refers to A3 and B3. You can see that the formula adjusts the references when I copy and paste it. One of the things that make Excel such a powerful tool is the ability to refer to cells/ranges and use these in formulas.Īnd when you copy these formulas, these cell references can adjust automatically (or should I say automatically).īelow is an example where I copy the cell C2 (which has a formula) and paste it in C3. Shortcut to add $ Sign to Cell References.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |