Absolute references ensure that your formula does not change when copied of filled. You can use absolute references when you want to keep certain cells constant. The dollar sign ($) is used before a row or column reference Continue reading “Why We Need To Use Absolute References? | Excel | Tutorial”