How to Use Absolute Cell References in Excel on Dell

How-to basics · Updated November 18, 2026

To make an Excel cell reference stay fixed while you copy a formula on a Dell Windows laptop, edit the formula, select the cell reference, and press F4. Excel adds dollar signs to lock the reference—for example, a fully locked reference looks like $C$1. If your Dell keyboard uses its function keys for hardware controls, try Fn+F4.

What You’ll Need

  • A Dell laptop or desktop running Windows, with Microsoft Excel for Microsoft 365.
  • A workbook containing a formula you want to copy, or a worksheet where you can create a small practice example.
  • Access to the F4 key. Depending on your Dell keyboard settings, you may need to hold Fn as well.

Step-by-Step

  1. Open your worksheet and identify the value that must stay fixed. Absolute references are useful when a formula should keep pointing to the same cell as you copy it elsewhere. A common case is a tax rate, discount percentage, exchange rate, or other shared input kept in one cell. The cell you want to lock can be in the same worksheet or another worksheet; start by identifying its address.
  2. Start or edit a formula. Click the cell where the calculation should appear, type an equals sign, and enter the parts of the calculation up to the reference you want to lock. If the formula already exists, double-click the formula cell or select it and press F2 to edit it. You can also click the formula bar and place the insertion point in the reference there.
  3. Select the specific cell reference in the formula. Click or drag across the reference text, or put the insertion point immediately within that reference. For the keyboard shortcut to change the right part of the formula, Excel needs to know which reference you mean. If you have several references in one formula, handle each one separately.
  4. Press F4 to make the reference absolute. With the reference selected or active in edit mode, press F4. Excel adds a dollar sign before both the column letter and row number. If pressing F4 changes a Dell hardware setting instead, hold Fn and press F4. On some Dell models, the function-key behavior depends on the keyboard’s Fn Lock or BIOS setting, so the Fn key may be needed consistently or not at all.
  5. Check which reference style Excel inserted. Pressing F4 repeatedly cycles through four forms: $A$1 locks both the column and row; A$1 locks only the row; $A1 locks only the column; and A1 is relative, so both can adjust when copied. Stop when the dollar signs match what you need. The shortcut cycles the reference under the insertion point; it does not lock every reference in the formula at once.
  6. Finish and confirm the formula. Press Enter to calculate it. If you are entering the example below, the worksheet has a price of 20 in B2 and a tax rate of 8% in C1; the result is a tax amount of 1.60. In this layout, enter the calculation in C2 and use the fixed tax-rate cell as shown: =B2*$C$1. The price reference is allowed to change by row, while the tax-rate reference stays at C1.
  7. Copy the formula and verify it. Select the completed formula cell and drag its fill handle—the small square at the lower-right corner of the selection—down or across. You can also copy and paste it. In the example, copying the formula from C2 to C3 changes the price reference to B3 but keeps the rate reference at $C$1. Check a copied cell before relying on a long range of results, especially if you filled the formula both down and across.
  8. Use the manual method if the shortcut is awkward. While editing the formula, type a dollar sign before the column letter and another before the row number of the reference you want to fix. For a reference to C1, add the signs to make $C$1. This works with a laptop keyboard, an external keyboard, and in situations where a browser or keyboard setting intercepts F4. Press Enter after editing and confirm that the formula calculates.

Common Mistakes

Pressing F4 when you are not editing a formula. The reference must be part of an active formula edit. If a cell is merely selected, F4 may repeat a previous action or trigger a keyboard function instead of changing a reference. Press F2 or click the formula bar first, then select the reference and try again.

Locking the wrong part of the reference. A dollar sign before the column letter fixes the column; one before the row number fixes the row. When a value must remain at exactly one address, use both dollar signs. If you lock only the row or only the column, that may be intentional for a table filled across or down, but it will not keep the entire cell address fixed.

Assuming the first F4 press always gives the desired form. F4 cycles through the relative, absolute, and mixed reference forms. Check the displayed reference after using the shortcut and continue pressing it if necessary. Avoid repeatedly tapping F4 without looking: you could cycle past the form you intended.

Locking every reference in a formula. In a calculation using a changing row value and one constant input, the changing reference usually needs to remain relative. Locking both can make every copied formula calculate from the original row. Conversely, leaving the constant input relative can make it shift to a blank or unrelated cell as you fill the formula.

Confusing an absolute reference with a fixed value. An absolute reference keeps the address fixed; it does not freeze the value stored there. If the contents of the referenced cell change, formulas pointing to it generally recalculate using the new value.

Tips

Use absolute references for inputs you maintain in one place, such as a percentage or conversion factor. That makes it easier to update the input later without editing every copied formula. Keep those inputs clearly labeled and, when practical, visually distinct from calculated cells so you can spot the cell the formula is meant to use.

Use mixed references when copying in two directions. For example, a reference written as $A1 keeps column A fixed but lets the row change; A$1 keeps row 1 fixed but lets the column change. These forms are useful for grids where a formula needs to draw its row and column inputs from different parts of a worksheet. Test the formula in one cell and copy it a short distance before filling a large area.

For a quicker edit, click the reference in the formula bar rather than trying to position the cursor precisely inside a long formula in the worksheet cell. If you use an external keyboard with your Dell, F4 usually works the same way, but the keyboard’s function-row settings can still affect whether Fn is needed. Save the workbook after checking that the copied results are sensible.

Absolute references also work across worksheets. When Excel inserts a sheet name as part of a reference, the dollar signs still control whether the row and column stay fixed as you copy the formula. Check the full reference after using F4; do not remove the worksheet name or punctuation while editing it.

Troubleshooting

F4 does nothing or controls brightness, volume, or another Dell feature: Put the formula into edit mode and try Fn+F4. If that works, your function row is set to use hardware actions as its default. Some Dell keyboards let you change Fn Lock with Fn+Esc, but behavior varies by model and configuration. You can also type the dollar signs into the reference yourself; there is no need to change your laptop settings just to use absolute references.

The dollar signs appear in the wrong place: Undo the edit if needed, re-enter formula-edit mode, and select the exact reference you meant to change. If there are several references in the formula, put the cursor in the one that needs fixing before pressing F4. Confirm that the result is a full reference such as $C$1 when both its row and column must stay fixed.

The formula changes to the wrong result after copying: Select a copied formula cell and inspect its references in the formula bar. If the constant input moved, lock both its row and column. If the row-specific input did not move, remove its dollar signs or adjust the reference style. Also confirm that the fixed cell contains the intended value and that the result is formatted appropriately; a displayed percentage or currency format can affect how a number looks without changing the reference.

F4 is intercepted in Excel for the web: Try editing the formula and using the shortcut again, but browser or keyboard behavior can differ. Type the dollar signs directly if the shortcut is unavailable. On a Mac, the keyboard shortcut differs from the Dell Windows instructions; Excel for Mac commonly uses Command+T to cycle reference types, and some keyboards may require Fn for function-key shortcuts. The manual dollar-sign method works there too.

Frequently Asked Questions

What does an absolute reference do in Excel?
It keeps a reference pointing to the same row and column when you copy a formula. Dollar signs before both the column and row indicate a fully absolute reference.

Is F4 the absolute-reference shortcut on a Dell laptop?
Yes, in Excel for Windows, F4 cycles the reference style while you edit a formula. Depending on the Dell keyboard’s function-key mode, use Fn+F4 instead.

Can I lock only a row or only a column?
Yes. A dollar sign before the row number locks the row, while one before the column letter locks the column. Press F4 until the reference shows the mixed form you need.

Why does F4 change something on my laptop instead of the formula?
The function row may be set to use hardware controls by default, or the formula may not be in edit mode. Try Fn+F4 after pressing F2 or clicking into the formula bar.

Does an absolute reference stop a cell’s value from changing?
No. It fixes which cell the formula points to. If that cell’s contents change, formulas referencing it can recalculate.

Can I enter an absolute reference without using F4?
Yes. While editing a formula, type a dollar sign before the column letter and before the row number you want fixed. Then press Enter and verify the formula before copying it.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.