Co-Authored By:

##### Asked by: Benita Wynends

technology and computing shareware and freeware# How do you fix a cell in Excel?

**Using Absolute Cell References**

- Click a
**cell**where you want to entera**formula**. - Type = (an equal sign) to begin the
**formula**. - Select a
**cell**, and then type an arithmetic operator(+,-, *, or /). - Select another
**cell**, and then press the F4 key tomakethat**cell**reference absolute.

Besides, how do you fix a cell in an Excel formula?

In the **Formula** Bar, put the cursor inthe**cell** which you want to make it constant, then press theF4key. In this case, I don't want the **cell** reference A1 tobeadjusted with the **formula** moving, so I put the cursor onA1in the **formula**, and then press F4.

**Excel**–

**Mac**keyboardshortcut for absolute

**cell**references. If you areusing a PCor Windows based laptop, you can make an

**Excelcell**reference absolute (or

**fixed**) by pressing the F4functionkey on the keyboard after the

**cell**reference. Theequivalentif you are using a

**Mac**is to press?T.

In respect to this, how do you reference a cell in Excel?

**How to create a reference in Excel**

- Click the cell in which you want to enter the formula.
- Type the equal sign (=).
- Do one of the following: Type the reference directly in thecellor in the formula bar, or. Click the cell you want to referto.
- Type the rest of the formula and press the Enter key tocompleteit.

Select the **formula cell** to displaythe**formula** in the **Formula** Bar. Click on thereference**cell** you want to always **use** in the**formula**,and then press the F4 key. Then you can see thespecified reference**cell** is changed to absolute.