Create Cell Reference in Excel  Step by Step Guide ▷ 2020

Excel is one of the computer programs of the Office package most complete there is. If you learn to use it correctly, you will discover that offers endless benefits and that you can execute all kinds of tasks in the spreadsheets.

However, learning to use the program is not as simple as it seems. In this particular post we want to talk in depth about what is a cell reference in Excel, what it is for and how to create one without major inconveniences.

With the help of cell references, the user can know exactly how to access the values ​​stored in each cell of the spreadsheet. In this way, if you want to learn everything about the subject, keep reading.

What is a cell reference in Microsoft Excel and what is it for?

What is a cell reference in Microsoft Excel and what is it for?

First of all, if you are new to using Excel, you should know that spreadsheets are divided into columns and rows. In the case of columns the headings are represented by letters, while in the rows it is by numbers. In this sense, cell references consist of two parts: the first that indicates the column in which a value is found and the second part that is the row number of the same.

This means that they are one of the fundamental parts of spreadsheets, because by means of a reference it is possible to identify each of the cells, in order to access the value they contain. So that you can identify much easier the reference of which is the active cell, it is shown highlighted in a different color and apart from that, in the Name box you can see the reference of the active cell.

Regarding its uses, you should know that you can use a cell reference in one or more formulas to refer to different aspects such as:

  • Data from a cell within a spreadsheet.
  • Data that are located in different areas of the spreadsheet.
  • Data found in cells, but from other worksheets within the same workbook.

Learn step by step how to create a cell reference in Excel

When it comes to how to create cell reference in excelYou should know that there are different mechanisms to achieve it. For example, you can create one in the same spreadsheet, on another sheet different or even through the Link Cells command.

Therefore, we will explain how to do it in each case:

In the same spreadsheet

How to create cell reference in Excel on the same sheet?

  • Click on the cell where you want to write the formula.
  • In the formula bar write the equal sign “=”.

Follow any of the procedures below:

  • To create a reference to one or more cells: selects a cell or range of cells on the same sheet. You can drag the border of the selection to move or drag the corner of the border to enlarge it.
  • To create a reference to a defined name: write the name. You can also do it by pressing F3, selecting the name in the box Paste name and clicking on To accept.

Finally, follow any of the following steps:

  • To create a reference in a single cell, tap on Get in.
  • To create a reference in an array formula, touch Ctrl + Shift + Enter.

Keep in mind that the reference can be a single cell or range of cells, while the array formula can be a formula that calculates a certain result or several of them.

Cell reference to another worksheet

How to create a cell reference to another worksheet?

it’s possible create references to cells that are located in other worksheetsas long as the name of the worksheet is appended followed by an exclamation point (!) at the beginning of the reference.

Once this is clarified, you can proceed to create a cell reference to another sheet as follows:

  • Click on the cell where you want to write the formula.
  • In the formula bar, type “=” along with the formula to use.
  • Click on the spreadsheet label in which you are going to make the reference.
  • Select cell range or the cell where you are going to make the reference and that’s it.

One thing to consider is that if the name of the other sheet has non-alphabetic characters you need to write the name (or path) between quotation marks simple, that is, .

Using the Link Cells command

How to create cell reference using Link Cells command?

Finally, there is an option that you can use and it consists of create a cell reference using the Link Cells command. To do this, you must copy and paste a cell reference, to later use the command Link cells and thus create the reference.

The use of this command is recommended to:

  • Show more easily important information in a more prominent position.
  • Facilitate the creation of references between spreadsheets and workbooks. This command automatically pastes the correct syntax.

Once this is clarified, the procedure to follow to create references with the Link Cells command is:

  • Tap on the cell that contains the data that you are going to link.
  • Press Ctrl + C or go to Home / Clipboard / Copy.
  • Then press Ctrl + V or in Home / Clipboard / Paste.
  • Click the button Paste Options and click Paste link.

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

You may be interested:

Rate this post

Leave a Comment