Excel: Linking Worksheets

Hello Friends!

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.

Advertisements

Leave a comment

Filed under MS Excel

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s