Asked in Microsoft Excel
Microsoft Excel

What does SHIFT 4 do in Excel?

012

Answer

User Avatar
Wiki User
09/07/2008

IT GIVES YOU $ BUT WHAT DOES IT DO IN EXCEL? The dollar signs $ can make the cell reference absolute =$A$1 is absolute reference, if you dragged the formula it will always be A1 =A1 is relative reference if you drag the formula the reference will change accordingly