How to Update Excel 2010 Links

Learning how to update excel links is a valuable skill as it will allow you to make the most of the useful external link feature found in MS Excel.


Step # 1 – Examining the Current Link

Start Excel. You will need a spreadsheet that has a link in it already. As you can see we have a link here called “Link out” and when we click on this link it takes us to the Google UK homepage, we want to change that.

Clicking the current link

Step # 2 – Opening the Link Properties

In order to change the destination that the link takes you to you need to navigate back to Excel and right click on the cell that contains the link, in this case “B2”. In the menu that appears click the “Edit Hyperlink…” button. A new window will appear.

Opening the link editing options

Step # 3 – Entering the New Destination

In the “Edit Hyperlink” window you will see an address option near the bottom. Here it reads “http://www.google.co.uk”. To learn how to update excel links you need to change this link to which ever site you desire. Here we are going to change it to the BBC site. Delete everything from “google” onwards and type “bbc.co.uk”. Click OK. The window will close and when you now click on the “Link out” link you will be directed to the BBC website instead.

Typing in a new link destination