Ever want or need to create a hyperlink from one workbook to another in MS Excel? There are many reasons why you may want to do this and it is a quick and easy way to link your data together. Fortunately there is a wonderful feature in Excel that allows you to accomplish this very easily.
Follow the steps below to learn how:
- Be certain that you have the two workbooks open – the one in which you would like the hyperlink to appear and the one that will be the target of the hyperlink. You should have both of them visible on your screen simultaneously.
- Select the range of cells in the target workbook that you would like to use as the target of your hyperlink.
- Move your cursor so that it is over the thick box surrounding your cell or range of cells. It will change into an arrow.
- Right-click and hold down your mouse button as you drag the selection to the cell in which your hyperlink will appear.
When you release your mouse button, MS Excel will display a Context menu.
- Select the Create Hyperlink Here option from the Context menu.
Excel will immediately create a hyperlink in that cell.
You must pay strict attention to the very first step above. The drag and drop method will only work if you are using two instances of Excel open at the same time. You cannot simply display two workbooks using Arrange from the Window menu. You must open Excel to open one workbook and then open Excel a second time with the second Workbook.