What does $ mean in Excel formulas?

The dollar sign locks part of a cell reference. $A$1 locks both the column and row when the formula is copied.

What is the shortcut for absolute reference in Excel?

Press F4 while editing a cell reference to toggle between relative, absolute, and mixed references.

Why does my formula show an error?

Open the linked error pages (#N/A, #VALUE!, #REF!) from our directory. Most formula posts fail because of data type mismatches, deleted references, or wrong match modes — not because the function name is wrong.

Should I copy formulas down or use a Table?

Copying down is fine for one-off models. Convert the range to an Excel Table when you add rows often — structured references stay readable and break less.

Formulas - 2026-05-12

Absolute Reference in Excel: When to Use Dollar Signs

Learn absolute, relative, and mixed references in Excel, including when to use dollar signs, F4 shortcuts, and common formula copy mistakes.

What Is an Absolute Reference?

An absolute reference keeps a cell reference fixed when you copy a formula. In Excel, dollar signs lock the column, row, or both. Example: \\\ $A$1 \\\ This locks both column A and row 1.

Relative vs Absolute References

Relative reference: \\\ A1 \\\ This changes when copied. Absolute reference: \\\ $A$1 \\\ This stays fixed when copied.

Mixed References

Lock only the column: \\\ $A1 \\\ Lock only the row: \\\ A$1 \\\ Mixed references are useful in multiplication tables, pricing grids, and formulas copied across rows and columns.

Use F4 to Toggle References

After selecting a reference in a formula, press F4 to cycle through: A1 $A$1 A$1 $A1 This is one of the fastest Excel formula shortcuts to learn.

Example: Fixed Tax Rate

If the tax rate is in F1 and prices are in column A: \\\ =A2*$F$1 \\\ When copied down, A2 changes to A3, A4, and so on. $F$1 stays fixed.

Common Mistakes

Forgetting to lock a fixed input cell Locking the wrong part of a mixed reference Hardcoding values instead of referencing input cells Copying formulas across columns without checking references

Related Guides

Excel Formulas for Beginners Excel Formula Audit Checklist SUMIF Not Working?

Formula debugging workflow

Step Action 1 Select the cell and read the formula in the formula bar 2 Use Formulas → Evaluate Formula for nested functions 3 Check for text stored as numbers (green triangle) 4 Fix errors using our formula error guide Go deeper: Compare similar functions · Fix common problems

Frequently asked questions

What does $ mean in Excel formulas? The dollar sign locks part of a cell reference. $A$1 locks both the column and row when the formula is copied.
What is the shortcut for absolute reference in Excel? Press F4 while editing a cell reference to toggle between relative, absolute, and mixed references.
Why does my formula show an error? Open the linked error pages (#N/A, #VALUE!, #REF!) from our directory. Most formula posts fail because of data type mismatches, deleted references, or wrong match modes — not because the function name is wrong.
Should I copy formulas down or use a Table? Copying down is fine for one-off models. Convert the range to an Excel Table when you add rows often — structured references stay readable and break less.