# What is the Address Function in Excel? Learn the Best in 3 Steps

## + share

Address Function in Excel formula has a single purpose in life. This is find a cell or range of cell. If you are new to this topic, you should consider it as it helps you find a specific cell by using its row and column numbers.

The address function calculates the numerical address of a cell or range of cells with a single function call. Firstly, the function returns that number if the return address is on a row or column axis. If the return address is a Location equation, the function returns the value in that cell referenced by the location. Finally, if the return address is a function, the function is called. And as a result, cells address will be here.

This function returns the text address of the cell where the row and column number you entered intersect. The cell address can be created as an absolute, relative or mixed reference. That is why they make a nice duo with the INDIRECT function.

Let’s have a look at the software now:

1. row_num: The row number of the cell whose address will be here.
2. column_num: The column number of the cell whose address come here.
3. absolute_num: These are integer values ​to ensure the address created is in the form of an absolute, relative or mixed reference. First, it is a parameter. But it is not mandatory to enter. If it is not entered, the value 1 is taken by default. Secondly, values ​​1, 2, 3 and 4 can be possible to give. Hence, it is for the function to return absolute, row absolute-column relative, column absolute-row relative, and relative address respectively.
4. a1: It is a parameter but you may not enter it. First, it can create of the cell address with column letter row numbers. Such as A1 or row and column numbers such as R1C1. You can enter 0 and 1 values ​. If no value is present, 1 will be the value and it returns an A1-style address.
5. page_text: If you want to add the worksheet name to the beginning of the returned address, you must enter the page name as text in this field.

## 2. Usage of How to define cell address in excel

Here we have few examples below for the use of the function. In formulas, the row, column and absolute parameters will be B-C-D column respectively. But here, the value given instead of the absolute number. And its effect on the formula result.

## 3. Considerations

So, this function gives you the address of a cell as text. And it does not really work on its own. It becomes helpful with a formula like INDIRECT. This can make your formulas a bit more complex tough.

Here, row and column numbers of formula will be fixed. If you change the cell address, such as adding or deleting rows or columns, you will get an incorrect cell reference. Because the values ​​in the formula will stay same and same problem applies to the page name. If you change the page name, you will receive a reference from wrong page. As the old page name will remain in the formula.

## How can I use the Address Function?

The address function evaluates the address or calculated address of a range of cells. When you use it to find formulas, it helps you find the coordinates of a cell. For instance, you could get the coordinates for the top row of cells you are working with.

## How do I Display the Address of a Range of Cells?

When you read this first, Address function might seem not necessary. As we use it for many years, it actuall comes with some benefits. One of the coolest ways to use it by getting the address for a range of cells. For example, if you have a list of addresses, you can use this function to pull up the right cell address. Also it works not just in the current worksheet but also in new tabs and even across the entire workbook. It’s a neat little tool for some flexibility.

## How do I move a Range of Cells by Address?

If you have cell range in an Excel and you want to find out the address of each cell, the Address function is your go-to.

Moving a range of cells by address in Excel can be a handy way. To do this, you need to know the address of the range you want to move.

First, you can select the range by typing in the address in the Name Box. You can click and hold on the border of the selected range and then drag it to the new spot.

If you prefer using cut and paste, you can right-click on the selected range and choose Cut. Then, you can go to desired place and select Paste.  And with address function, we can easily figure out when to divide a range of cells evenly.

## Where can I find the Address Function in Excel?

The address function finds the address of a range of cells. Because it is a number to identify a cell.

## What does the Address Function in Excel do?

Address function in Excel checks a range of cells for a specific number we know it by now. If it finds the number, it copies the address of that cell. If it doesn’t find the number, it will skip. And if there is no number in any of the cells, it assumes the starting cell is the address.

Basically, calls the address of a specific cell like the one you are currently on. And it either puts it in another cell or gives it back as part of cell range.