{"id":6054,"date":"2017-10-30T17:01:24","date_gmt":"2017-10-30T16:01:24","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=6054"},"modified":"2017-10-30T17:01:24","modified_gmt":"2017-10-30T16:01:24","slug":"google-sheets-insert-link-to-external-destinations","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-features\/google-sheets-insert-link-to-external-destinations\/","title":{"rendered":"Criar links no Planilhas Google para destinos externos"},"content":{"rendered":"\n[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; module_class=&#8221;sheetgo-post&#8221; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;54px|0px|123px|0px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.20.2&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>We know that<span>\u00a0<\/span><a href=\"https:\/\/www.google.com\/sheets\/about\/\" target=\"_blank\" rel=\"noopener noreferrer\">Google Sheets<\/a><span>\u00a0<\/span>supports text and numbers in its cells. But, at times we may need to navigate to beyond the spreadsheet application. In this article, we explain how,\u00a0in Google Sheets, insert link to external destinations. There are two ways to accomplish this task.<\/p>\n<h3>Use HYPERLINK formula<\/h3>\n<p>Google Sheets comes with an inbuilt formula that lets us create links to destinations probably on the internet. Here\u2019s the syntax:<\/p>\n<p><span><strong>HYPERLINK(url, [link_label])<\/strong><\/span><\/p>\n<ul>\n<li><span><strong>url<\/strong><\/span><span>\u00a0<\/span>\u2013 the link or URL of the image.\n<ul>\n<li>This must be enclosed in double quotes if entered as text. It can also be a reference to a cell that holds the URL.<\/li>\n<li>The URL protocols that this formula supports are\u00a0http:\/\/, https:\/\/, mailto:, aim:, ftp:\/\/, gopher:\/\/, telnet:\/\/, and news:\/\/. Anything else is not allowed.<\/li>\n<li>If we do not provide any protocol, it defaults to http:\/\/, and accordingly prepends it to the URL.<\/li>\n<\/ul>\n<\/li>\n<li><span><strong>link_label<\/strong><\/span><span>\u00a0<\/span>\u2013 is an optional parameter. This is what the users see as a display text to the URL. If we ignore this, the formula displays the URL itself, but with a clickable link.<\/li>\n<\/ul>\n<p>Let us consider various use cases of this formula. Please see the snapshot below.<\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/google-sheets-insert-link-1.png&#8221; alt=&#8221;google sheets insert link 1&#8243; title_text=&#8221;google sheets insert link 1&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>Clicking on these generated links takes us to the Google home page, outside the scope of the Google Sheets spreadsheet.<\/p>\n<p>The first three examples are self-explanatory. The last one is a little peculiar. Please note that we have given an empty string (as opposed to nothing) for a<span>\u00a0<\/span><span><strong>link_label<\/strong><\/span>parameter. Despite the result not having any display text, the HYPERLINK formula still returns a working link. We can see that by hovering the mouse hover onto the cell B7.<\/p>\n<h3>Use menu option Google Sheets insert link to external destinations<\/h3>\n<p>For those who are not very keen on using the HYPERLINK formulas, we have an alternative option in the graphical user interface. To insert a link in a particular cell, select it, then navigate to<span>\u00a0<\/span><strong>Insert &gt; Link<\/strong><span>\u00a0<\/span>[or press Ctrl + K (Cmd + K for mac)].<\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h3>Use menu option Google Sheets insert link to external destinations<\/h3>\n<p>For those who are not very keen on using the HYPERLINK formulas, we have an alternative option in the graphical user interface. To insert a link in a particular cell, select it, then navigate to<span>\u00a0<\/span><strong>Insert &gt; Link<\/strong><span>\u00a0<\/span>[or press Ctrl + K (Cmd + K for mac)].<\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/google-sheets-insert-link-2.png&#8221; alt=&#8221;google sheets insert link 2&#8243; title_text=&#8221;google sheets insert link 2&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>We will then see a pop-up window that has more options than the HYPERLINK. Incidentally, this menu option can accommodate the URLs as well. We just have to key in the URL in the link field as shown in the image below.<\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/google-sheets-insert-link-3.png&#8221; alt=&#8221;google sheets insert link 3&#8243; title_text=&#8221;google sheets insert link 3&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>We then click on the Apply button, which will essentially insert a link using the HYPERLINK formula.<\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/google-sheets-insert-link-4.png&#8221; alt=&#8221;google sheets insert link 4&#8243; title_text=&#8221;google sheets insert link 4&#8243; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><span>Congratulations! We just successfully learned how to\u00a0<\/span>insert a link in Google Sheets to external destinations<span>\u00a0using both HYPERLINK formula and also the menu option:\u00a0<\/span>Insert &gt; Links<span>. Read through the following blog post to learn how to\u00a0<\/span><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/import-html-table-to-google-sheets\/\" target=\"_blank\" rel=\"noopener noreferrer\">import tables from the web to Google Sheets<\/a><span>.<\/span><\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"<p>We know that\u00a0Google Sheets\u00a0supports text and numbers in its cells. But, at times we may need to navigate to beyond the spreadsheet application. In this article, we explain how,\u00a0in Google Sheets, insert link to external destinations. There are two ways to accomplish this task. Use HYPERLINK formula Google Sheets comes with an inbuilt formula that [&hellip;]<\/p>\n","protected":false},"author":40,"featured_media":6055,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"We know that Google Sheets supports text and numbers in its cells. But, at times we may need to navigate to beyond the spreadsheet application. In this article, we explain how to create links in Google Sheets to external destinations. There are two ways to accomplish this task.\n<h3>Use HYPERLINK formula<\/h3>\nGoogle Sheets comes with an inbuilt formula that lets us create links to destinations probably on the internet. Here's the syntax:\n\n<span style=\"font-family: 'courier new', courier, monospace; font-size: 14pt;\"><strong>HYPERLINK(url, [link_label])<\/strong><\/span>\n<ul>\n \t<li><span style=\"font-size: 12pt; font-family: 'courier new', courier, monospace;\"><strong>url<\/strong><\/span> - the link or URL of the image.\n<ul>\n \t<li>This must be enclosed in double quotes if entered as text. It can also be a reference to a cell that holds the URL.<\/li>\n \t<li>The URL protocols that this formula supports are\u00a0http:\/\/, https:\/\/, mailto:, aim:, ftp:\/\/, gopher:\/\/, telnet:\/\/, and news:\/\/. Anything else is not allowed.<\/li>\n \t<li>If we do not provide any protocol, it defaults to http:\/\/, and accordingly prepends it to the URL.<\/li>\n<\/ul>\n<\/li>\n \t<li><span style=\"font-size: 12pt;\"><strong><span style=\"font-family: 'courier new', courier, monospace;\">link_label<\/span><\/strong><\/span> - is an optional parameter. This is what the users see as a display text to the URL. If we ignore this, the formula displays the URL itself, but with a clickable link.<\/li>\n<\/ul>\nLet us consider various use cases of this formula. Please see the snapshot below.\n\n[panel type=\"default\"] <strong>Example<\/strong> <img class=\"aligncenter wp-image-6102 size-full\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/links1.png\" alt=\"links in Google Sheets to external destinations - Illustration 1.0\" width=\"590\" height=\"223\" \/>[\/panel]\n\nClicking on these generated links takes us to the Google home page, outside the scope of the Google Sheets spreadsheet.\n\nThe first three examples are self-explanatory. The last one is a little peculiar. Please note that we have given an empty string (as opposed to nothing) for a <span style=\"font-size: 12pt; font-family: 'courier new', courier, monospace;\"><strong>link_label<\/strong><\/span> parameter. Despite the result not having any display text, the HYPERLINK formula still returns a working link. We can see that by hovering the mouse hover onto the cell B7.\n<h3>Use menu option to create links to Google Sheets to external destinations<\/h3>\nFor those who are not very keen on using the HYPERLINK formulas, we have an alternative option in the graphical user interface. To insert a link in a particular cell, select it, then navigate to <strong>Insert &gt; Link<\/strong> [or press Ctrl + K (Cmd + K for mac)].\n\n[panel type=\"default\"] <strong>Example<\/strong> <img class=\"aligncenter size-full wp-image-6104\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/links2.png\" alt=\"links in Google Sheets to external destinations - Illustration 2\" width=\"553\" height=\"545\" \/>[\/panel]\n\nWe will then see a pop-up window that has more options than the HYPERLINK. Incidentally, this menu option can accommodate the URLs as well. We just have to key in the URL in the link field as shown in the image below.\n\n[panel type=\"default\"] <strong>Example<\/strong> <img class=\"aligncenter size-full wp-image-6106\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/links3.png\" alt=\"links in Google Sheets to external destinations - Illustration 3\" width=\"552\" height=\"178\" \/>[\/panel]\n\nWe then click on the Apply button, which will essentially insert a link using the HYPERLINK formula.\n\n[panel type=\"default\"] <strong>Example<\/strong> <img class=\"aligncenter size-full wp-image-6107\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/links4.png\" alt=\"links in Google Sheets to external destinations - Illustration 4\" width=\"552\" height=\"178\" \/>[\/panel]\n\nCongratulations! We just successfully created links in Google Sheets to external destinations using both HYPERLINK formula and also the menu option: <strong>Insert &gt; Links<\/strong>.","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[55,39,28],"class_list":["post-6054","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features","tag-ben-collins","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/6054","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=6054"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/6054\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/6055"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=6054"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=6054"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=6054"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}