How to link worksheets in Excel

How to link worksheets in Excel
How to link worksheets in Excel
Anonim

Microsoft Excel is the spreadsheet for the Microsoft Office office suite. It is possible to follow or create a lot of things. For example, you can create a workbook that will allow you to track data from different sources that will be on separate worksheets, but end up linked to another sheet in the workbook that summarizes the information from those worksheets. As you build this workbook step by step, you will see how easy it is to create this type of file.

Steps

Link Sheets in Excel Step 1

Step 1. Open a workbook

Click on the Microsoft Excel icon, a white or green "X" in a green or white square depending on the version.

Link Sheets in Excel Step 2

Step 2. Go to the main sheet

Once the workbook is open, you can see that you have at least 3 tabs, which is 3 worksheets. Click the tab of the sheet you want to use as the main sheet. It will present the data from the other sheets.

Link Sheets in Excel Step 3

Step 3. Choose a cell

Click in an empty cell on your worksheet. This cell will be the one that will present the information coming from another sheet, the source sheet, via a link that you are going to create. Note that each time the data in the source sheet changes, the information in that cell will automatically change.

Link Sheets in Excel Step 4

Step 4. Write in cell =

Enter "=" in the cell to inform the Excel software that you are going to write a formula. Be aware that whenever you want to put a formula in a cell, it should always start with the equal sign.

Link Sheets in Excel Step 5

Step 5. Select the source sheet tab

At the bottom of your workbook, click on the tab of the source sheet in which the data will be saved.

Link Sheets in Excel Step 6

Step 6. Check the formula bar

In the formula bar, you can see the contents of the cell you have chosen. You will therefore see that after the equal sign is written the name of the source worksheet that you have just selected followed by an exclamation point.

You can also write the name of the sheet yourself. It will be a question of entering = name of the sheet !, knowing that "name of the sheet" must be replaced by the name which is written on the tab you have selected

Link Sheets in Excel Step 7

Step 7. Choose a cell

On your source sheet, click in a cell. The cell you just selected will be the source cell which can be empty or contain data. Note that by linking the two sheets, the cell that is on the main sheet will automatically update according to the contents of the cell in the source sheet.

You can have, for example, in a source sheet called “Sheet2” a data in cell “B12” which will automatically be transferred to the cell you have chosen in the main sheet with the formula = Sheet2! B12 entered. in the latter

Link Sheets in Excel Step 8

Step 8. Press the Enter key

Press the key Entrance on your keyboard to activate the formula and return to the main sheet. You now have a cell on the main sheet that is linked by a formula to a cell on the source sheet. Each time the data in the source cell changes, the content of the main cell updates automatically.

Link Sheets in Excel Step 9

Step 9. Select the cell of the main sheet

Click in the cell on the main sheet that contains the formula to highlight it.

Link Sheets in Excel Step 10

Step 10. Duplicate the formula

The highlighted cell has a small square at the bottom right, click on it, then drag to the cells you want. By doing so, you increase the number of cells in the main sheet linked to a cell in the source sheet. Note that this operation links the cells adjacent to the first cell of the main sheet to the same adjacent cells of the cell of the source sheet.

Popular by topic