To make an Excel cell reference absolute rather than relative, you need to add a dollar sign before the column and/or row reference.
To do this automatically, click into the cell reference in the formula bar and press F4. If you select more than one cell reference in a formula, all selected parts will become absolute.
If you press F4 repeatedly, you will see that Excel toggles through the four stages of absolute/relative references.
Now one of the top on-line publishers in the world, LifeTips offers tips to millions of monthly visitors. Our mission mission is to make your life smarter, better, faster and wiser. Expert writers earn dough for what they know. And exclusive sponsors in each niche topic help us make-it-all happen.