When writing a formula, you can press the F4 key on your keyboard to switch between relative and absolutecell references. This is an easy way to quickly insert an absolutereference.
There may be times when you do not want a cellreference to change when copying or filling cells. You can use an absolute referenceto keep a row and/or column constant in the formula.