Friday, September 28, 2012

How to Create Multiple Hyperlinks in Excel


1. 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.
2. 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.
3. 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.
4. Scroll to or click the next cell to hyperlink and repeat the 'Insert Hyperlink' process.
5. 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.
6. 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.'

Blogger news