Hyperlinks

 

Entering Hyperlinks:

 

  1. Open up an Excel spreadsheet
  2. In cell A1, type in ‘Information on the University of Maryland’
  3. Size the column to fit the text by double clicking on the upper right hand boundary of column A
  4. Now click on cell B1
  5. Use the pull down menu, and click on ‘Insert’ then ‘Hyperlink’
  6. In the ‘Type the file or web page name’ box, type in ‘http://www.umd.edu/’
  7. Click on ‘OK’
  8. Remember to resize column B to fit the text – double click on the upper right hand boundary of column B
  9. Now, in cell A3, type in ‘Information on the weather’
  10. Click on cell B3
  11. Right click in the cell, and then click on ‘Hyperlink’ in the shortcut menu that appears
  12. In the ‘Type the file or web page name’ box, type in ‘http://www.weather.com/’
  13. Click on ‘OK’
  14. Once again, you’ll have to resize column B – double click on the upper right hand boundary of column B
  15. In cell A5, type in ‘Search Engine’
  16. Now click on B5
  17. Right click in the cell, and then once the shortcut menu appears, click on ‘Hyperlink’
  18. In the ‘Type the file or web page name’ box, type in ‘http://www.altavista.com/’
  19. Click on ‘OK’

 

Editing Hyperlinks:

 

  1. Right click on cell B1 (this allows you to use the cell without accessing the hyperlink) – the shortcut menu should appear
  2. Click on ‘Hyperlink’ and then ‘Edit Hyperlink’
  3. In the ‘Text to display’ box, delete the text that is already there, and type in ‘UMD Website’
  4. Click on ‘OK’
  5. Right click on cell B5
  6. In the shortcut menu that appears, click on ‘Hyperlink’ and then ‘Edit Hyperlink’
  7. In the ‘Type the file or web page name’ box, delete the text that is already there, and type in ‘http://www.google.com/’
  8. Now, in the ‘Text to display box’, type ‘Google’
  9. Click ‘OK’

 

Your final worksheet should look like this: