When you say a reference is relative, you are telling excel to adjust that reference in formulas based on where you move or copy the formula. What is a reference?Ī reference in excel lingo “identifies a cell or a range of cells on a worksheet and tells Microsoft Excel where to look for the values or data you want to use in a formula.” So what is the difference between relative and absolute references? It was such a joyous feeling to find out that you can actually write one (or just a few) formulas and use the power of auto-fill to do the dirty work for you. I have used excel an year and half before I learned about the relative and absolute references. ![]() ![]() ![]() This is the first installment of the spreadcheats series.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |