What is a Relative Cell Reference in Excel ?Ī relative cell reference is Excel is a Cell address without the dollar sign in the row and column as we copy down the formula. Left-click your mouse and drag down the + sign. *** To copy down a formula, click on the cell with the formula, at the bottom right, you will see a small box. This tutorial will guide all levels of Excel users on how to manipulate absolute and relative references in Excel and Mac.įigure 1: Absolute and Relative Reference in Excel and Google Sheets on Mac The dollar sign ($) in Excel tells Excel to change or not to change a cell reference when a formula is copied to another cell. How to Use Absolute and Relative Reference in Excel and Google Sheets on Mac
