The Quick Answer
- Enter the URL in desired cell
- Click the icon on the left to open in a new browser
- To make link into text, enter this hyperlink formula into the desired cell: =hyperlink("www.google.com";"search the web")
If you want to include a link to a URL in your spreadsheet, simply enter the chosen URL in the desired cell. From this point on, whenever this cell is selected, a small "pop-out" icon will appear to the left of the cell. Click on this icon to open a new browser window linking to the included URL.
If you'd like to include a link to a specific URL, but you want this link to be indicated by a bit of text (e.g. instead of "www.google.com" appearing in your cell, you want the viewer to be able to link to google.com from the phrase "search the web"), enter this hyperlink formula into the desired cell:
=hyperlink("www.google.com";"search the web")
![]()
if(document.getElementById('kb_other') != null)
showLayer('kb_other');
if(document.getElementById('kb_other_') != null)
showLayer('kb_other_');
if(document.getElementById('z_other') != null)
toggleZippy('z_other');
if(document.getElementById('z_other_') != null)
toggleZippy('z_other_');
if(document.getElementById('kb_'))
showLayer('kb_');
if(document.getElementById('z_'))
toggleZippy('z_');
if(document.getElementById('kb_other'))
showLayer('kb_other');
if(document.getElementById('z_other'))
toggleZippy('z_other');
if(document.getElementById('kb_US'))
showLayer('kb_US');
if(document.getElementById('z_US'))
toggleZippy('z_US');
