## How do I reference a cell in Excel formula?

Use cell references in a formula

- Click the cell in which you want to enter the formula.
- In the formula bar. , type = (equal sign).
- Do one of the following, select the cell that contains the value you want or type its cell reference.
- Press Enter.

### How do you reference a cell text in a formula?

Usually you type =A1 for referring to the cell A1 in Excel. But instead, there is also another method: You could use the INDIRECT formula. The formula returns the reference given in a text. So instead of directly linking to =A1, you could say =INDIRECT(“A1”).

#### How do you make a cell an absolute reference?

There is a shortcut for placing absolute cell references in your formulas! When you are typing your formula, after you type a cell reference – press the F4 key. Excel automatically makes the cell reference absolute!

**What is Excel cell reference?**

A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.

**How do you make an absolute reference in Excel without F4?**

This is easily fixed! Just hold down the Fn key before you press F4 and it’ll work.

## What can I use instead of F4?

Laptop keyboards are smaller than stationary ones so typically, the F-keys (like F4) are used for something else. This is easily fixed! Just hold down the Fn key before you press F4 and it’ll work.

### What does F5 do in Excel?

F5 Displays the Go To dialog box. Ctrl+F5 restores the window size of the selected workbook window. F6 Switches between the worksheet, ribbon, task pane, and Zoom controls.

#### How do you press F4 in Excel?

How to use F4 in Excel. Using the F4 key in Excel is quite easy. Think of a situation where you have been working on an Excel worksheet and you want to repeat the last action multiple times. All you need to do is press and hold Fn and then press and release the F4 key.