Just enter the reference formula directly into the cell. Using this approach, you can create a link manually without leaving the original sheet at all. Now if you click on a cell in Sheet2, you will see that Excel is writing the path for you in the formula bar.įor example, = Sheet1! C3, where Sheet1 is the name of the sheet, C3 is the cell you are referencing, and an exclamation mark (!) Is used as the separator between them.
Switch to another tab (Sheet1) and click the cell you want to link to.On Sheet2, enter an equal symbol (=) in the cell.Let’s start by linking two cells located on different sheets (or tabs) but in the same Excel file.
How to link cells in excel 2013 how to#
In the next article, you will learn how to link individual cells in other sheets, link a range of cells, and how to link cells from different Excel documents. This will shorten your working time and reduce the likelihood of calculation errors. Secondly, this technique will avoid duplication of the same numbers in several tables. And all this without having to navigate between different tables. For example, you can use one sheet or workbook to collect raw data and then create a new tab or new workbook for reports and / or summaries.Īfter you link the cells between the two, you only need to change or enter new data in one of them, and the results will automatically change to the other. The ability to reference data on different sheets is a valuable skill for several reasons.įirst, it will make it easier to organize your tables. Knowing this will save you a lot of time and savings in the long run. A good example is the ability to link cells in Excel between sheets and workbooks. Knowing a few simple tricks can go a long way with Excel. But if you are someone who works with spreadsheets every day, you may need to know more than just the basics of working with Excel. Microsoft Excel is a very powerful multipurpose tool that anyone can use.
0 kommentar(er)
