Anchoring Cells in Excel

Writing many formulas in Excel can get tedious and time-consuming. Anchoring cells is a technique that you can use to make the process faster and easier.
Anchoring Cells:
Pasting formulas works well when you want the inputs to adjust automatically. However, if you want to hold a cell reference constant while pasting a formula, then you should anchor cells. For example, if we’re converting several months of revenue from dollars to euro, we want the exchange rate that we use to be constant. Anchoring stops a cell reference from changing when we copy and paste the formula.
When writing a formula, we anchor a cell using the F4 key. The anchoring is indicated by the $ symbol. There are three types of anchoring, as shown below:
$A$1: The cell reference will be unchanged when pasting anywhere
$A1: The cell reference will be unchanged when pasting horizontally
A$1: The cell reference will be unchanged when pasting vertically