Navigation in an Excel spreadsheet need not be relegated to tabbing and pressing the "Enter" key or even scrolling to move from cell to cell. Inserting hyperlinks into an Excel spreadsheet offers users a way to jump from spreadsheet to website, spreadsheet to spreadsheet or launching place to landing spot within the same spreadsheet. To ensure accuracy, add multiple hyperlinks individually to the spreadsheet, selecting each destination and letting Excel take care of the linking.
Open Microsoft Excel. Click the "File" tab. Click "Open." Browse to the spreadsheet to add hyperlinks into and double-click its file name. The spreadsheet opens in the Excel workspace.
Scroll to or click the cell with the first set of data to hyperlink. Right-click the cell and click "Hyperlink" to open the "Insert Hyperlink" window.
Type the Web address to launch when clicking the hyperlink into the "Address" box at the bottom of the "Insert Hyperlink" window. Click the "OK" button. The cell text becomes blue with an underline signifying a hyperlink.
Scroll to or click the next cell to hyperlink and repeat the "Insert Hyperlink" process.
Create multiple hyperlinks going to the same destination by highlighting a cell, right-clicking and clicking "Insert Hyperlink." After typing in the website in the "Address" box, highlight the typed address, right-click it and click "Copy." Click the "OK" button to close the "Insert Hyperlink" window and add the hyperlink.
Click the next set of data to hyperlink with the same address. Repeat the "Insert Hyperlink" process, but instead of typing into the "Address" box, right-click the box and click "Paste" to paste in the address. Click "OK."
Excel doesn't permit assigning multiple hyperlinks in a batch at one time; each must be created individually.
Tips and warnings
- Excel doesn't permit assigning multiple hyperlinks in a batch at one time; each must be created individually.