Today’s tip is about linking cells in Excel. This is pretty cool AND easy. All you have to do is type the = sign in the destination cell, then navigate to the location of the data you want linked. Click on the cell you want linked, and hit “Enter.” Presto! It’s done! Now any time you change the value of the linked cell, the destination cell will change with it.
You can link to cells in another workbook, but whenever you make changes in the original cell, the other workbook needs to be open as well. If it’s not, you’ll have to remember to refresh data when you do open the destination workbook next. It’s likely you will get an alert about links being disabled. Just click “enable” to update the data.
To link to a cell in another workbook, open that other workbook. When you type the = sign in the destination cell, navigate to the cell you want linked from the other workbook, click on it, and hit “enter.” Again, Presto! It’s DONE! Here’s a sample formula like the one you will see “just appear”:
Thanks for stopping by! Let me know if I can help you with this further.