Neicy Techno – $ excel function. In Microsoft Excel, there are many functions, symbols, and operators that are used to meet user needs. You can use all of that for the benefit of the project you are making.
$ function in excel is used to lock specific Cells. You can use this function to retrieve a reference from a specific cell or range without having to change the location of that cell or range. It can be said that the $ function can lock cells/ranges, so that when using the Fill Handle technique or duplicating Formulas on certain cells, the location or range of reference cells will not change.
$ excel function
Applying the $ function for columns and Rows
You can use the $ function to lock a specific part of a cell or column. In other words, this method does not lock the cell completely and only partially locks the row or column. For more details, let’s study together.
Using absolute ($) function for Columns
“You can only make columns absolute”. This method is used to lock or make certain columns absolute by using the ($) symbol. The trick is to put the $ symbol before the column name. As an example:
Using absolute ($) function for Row
“You can make excel rows absolute”. This method is used to lock or make certain rows absolute by using the ($) symbol. The trick is to put the $ symbol before the line name. For example, consider the formula below:
How to use the $ function in Excel
As previously explained, you can manually use the absolute ($) symbol and specify which rows or columns to make absolute. In addition, you can also use the F4 key on the keyboard. By using the F4 key you will get the Cell and column location to be absolute. As an example:
to use the F4 key, you must first write down the cell address. For example, write =E5 in one of the excel cells, then press the F4 key on the keyboard. Then the result will be like this:
Explanation of using the $ function in Excel
After learning a few ways to use the $ function in Excel, I think you understand how to write and explain it. However, I’ll rewrite the explanation of using the absolute ($) function here:
Relative Reference Example:
Absolute Reference Example:
Mixed Reference Example (Absolute Column and Relative Row):
Mixed Reference Example (Relative Column and Absolute Row):
With the examples and explanations above, I think you understand and are ready to use the absolute ($) function in excel. If you still don’t understand it, you can re-read the explanation above, or listen to the following short explanation:
- =D1, Columns and rows may change when you copy them to other cells or use the autofill function.
- =$D1, Column D address will not change (Absolute) but row 1 address may change.
- =D$1, The address of column D can change, but the address of row 1 will not change (Absolute).
- =$D$1, Columns and rows will not change (Absolute).
The Absolute ($) function is very important to use in retrieving references from other tables. Using the $ function, you can lock a specific cell and it won’t change even if you copy the formula to another cell or use the autofill function. In other words, your cell references will be safe and will not experience errors.
I hope you understand every step I explain. In addition, you can directly practice the tutorial above to better understand it. So, follow the steps and use them in the project you are working on. That way, you can understand it better.
- How to Create a dropdown in Excel - Excel Function List for Beginners (Complete) - How to add Google Maps and Website in Smart Apps Creator