Relative Referencing is the default option with Excel formulas. Now that statement might not be too helpful but to understand what I mean there are two ways you can reference a cell location, either using a Relative Reference (no Dollar signs) or some form of Absolute Reference (Dollar signs involved). The Dollar signs are used for indicating Absolute References.
This is an example of using Dollar signs in Excel formula. If you see a formula that looks something like:
Many Excel users starting out will often skip this learning but honestly if you want to progress as an Excel analyst or use Excel to create amazing tools you must understand what the Dollars signs are for and how to use them, it’s simple and I will show you everything you need to know in this post. When some Excel users see Dollar signs in an Excel formula it generally brings about a fair amount of confusion.