# How To Make An Absolute Reference In Excel: A Beginner's Guide

Saturday, July 1st 2023. | Excel Templates

## Introduction

Excel is one of the most popular spreadsheet software used in the business industry. It is used for various purposes like accounting, data analysis, and financial modeling. Excel has numerous features that make it a powerful tool for data manipulation. One of those features is absolute reference. Absolute reference is a technique that allows you to lock a cell reference to prevent it from changing when you copy the formula to another cell. In this article, we will learn how to make an absolute reference in excel.

## What is an Absolute Reference?

An absolute reference is a cell reference that remains constant when a formula is copied to another cell. It is used when you want to keep a specific cell reference constant in a formula. Absolute references are represented by a dollar sign (\$).

## How to Make an Absolute Reference?

There are two ways to make an absolute reference in excel. You can either use the F4 key or manually add the dollar sign.

### Method 1: Using the F4 Key

Step 1: Select the cell that contains the formula you want to copy. Step 2: Click on the cell reference in the formula bar. Step 3: Press the F4 key on your keyboard. This will add the dollar sign to the cell reference. Step 4: Press Enter to save the changes.

### Method 2: Manually Adding the Dollar Sign

Step 1: Select the cell that contains the formula you want to copy. Step 2: Click on the cell reference in the formula bar. Step 3: Manually add the dollar sign before the column letter and row number. For example, if the cell reference is A1, change it to \$A\$1. Step 4: Press Enter to save the changes.

## Sample Absolute Reference Formulas

Here are three sample absolute reference formulas that you can use in excel: Formula 1: =SUM(\$A\$1:\$A\$5) This formula adds the values in cells A1 to A5. The dollar sign locks the cell references, so when you copy the formula to another cell, the cell references remain the same. Formula 2: =A1*\$B\$1 This formula multiplies the value in cell A1 with the value in cell B1. The dollar sign locks the cell reference of cell B1, so when you copy the formula to another cell, the reference to cell B1 remains the same. Formula 3: =\$D\$1/\$E\$1 This formula divides the value in cell D1 by the value in cell E1. The dollar sign locks the cell references of cells D1 and E1, so when you copy the formula to another cell, the cell references remain the same.

## Tips for Using Absolute Reference

Here are some tips for using absolute reference in excel: Tip 1: Use absolute reference when you want to keep a specific cell reference constant in a formula. Tip 2: You can use the F4 key to toggle between relative and absolute reference. Tip 3: You can use a combination of relative and absolute reference in a formula.