Relative References in Excel  What are they? + Advantages ▷ 2020

If you are new to spreadsheet management, surely you have wondered why the rows and columns are named by numbers and letters. If you think they are for sort the cells, you are not wrong, but also they play a very important role.

It is about locate references. These, uniquely identify one or more cells. That is, they work as addresses or links within a document Excel.

This allows formulas locate any box and get its value, in order to be able to carry out the calculations that we indicate. If you want to know more about relative references, we recommend this post.

What is a relative reference and what is it for in my Excel documents?

The relative references are those commands that link to a particular row and column location. But when copying and pasting them in another cell, they fit a different location.

These are always formed by the combination of a letter and a number. For example “A1” refers to the cell located in the column “TO” and the row “1”.

What are the main benefits of using relative references in my spreadsheets?

We can say that the main benefit of this type of reference is given at the time of copy paste. Making it unnecessary to rewrite a formula. This works relative to cell location, taking into account columns and rows alike.

What are the main benefits of using relative references in my spreadsheets?

For example, (observe image) if we write the operation in cell B2 “= A2 + B1” when A2 has a value of 2 and B1 of 3, the result, it is Of course 5.

But nevertheless, when we copy this formula and paste it in cell F8, the result is different. This is because it takes the relative reference of the position of the other cells regarding where the formula is placed. The same, in the example is “= E8 + F7”.

When is it more convenient to use a relative or an absolute reference in a document?

It is important to mention that relative references are the default way to copy and paste formulas between cells. This type of use is recommended in numerical tables.

It is also in wide use if we need to do the same operation in different cells from a spreadsheet. As we saw in the example.

When is it more convenient to use a relative or an absolute reference in a document?

In the case that we need the result of a function entered in a cell not to be modified when copying it to another, it is recommended to use an absolute reference. To do this, simply add a sign “$” before the column reference and another in the row reference. For example, the operation will be “= $ A $ 1 * 2” which means that we will multiply by 2 the content of cell A1.

Unlike the relative, when let’s copy and paste the box with the operation in another location on the spreadsheet, the value will remain the same.

Learn how to define relative references in your Excel spreadsheets

To understand more efficiently how relative references work in a document of Microsoft Excel, it is best to do it in a practical example.

Continue with these steps:

Learn how to define relative references in your Excel spreadsheets

  • Start the program.
  • Create a book in white.
  • Place in the first column, random figures.
  • Do the same with the next three columns, respecting the number of rows used in the first.
  • In the first available cell under the first initial column, put the formula “= SUM (A1: A5)” being A1 the beggining from column list TO Y TO 5 the end Of the same..
  • Select and press “Ctrl + C” on cell that gives the result of the operation.
  • Click main on the adjacent square and press “Ctrl + V”.
  • Repeat these steps successive times, until each column is completed.

If you have any questions, leave them in the comments, we will answer you as soon as possible, and it will also be of great help to more members of the community. Thank you! 😉

You may be interested:

Rate this post

Leave a Comment