{"id":1515,"date":"2022-05-14T20:12:59","date_gmt":"2022-05-14T14:42:59","guid":{"rendered":"https:\/\/sheetstips.com\/?p=1515"},"modified":"2022-05-23T10:07:10","modified_gmt":"2022-05-23T04:37:10","slug":"how-to-open-links-in-google-sheets-with-a-single-click","status":"publish","type":"post","link":"https:\/\/sheetstips.com\/how-to-open-links-in-google-sheets-with-a-single-click\/","title":{"rendered":"How to Open Links in Google Sheets with Single Click &#8211; Google Sheets Clickable Cell"},"content":{"rendered":"<p>By default, the links provided in Google Sheets will open only after double-clicking them. Although, double-clicking on a hyperlink will be quite annoying if you have multiple links to open at the same time.<\/p>\n<p>However, with the help of <strong><a href=\"https:\/\/sheetstips.com\/google-sheets-tips\/\" target=\"_blank\" rel=\"noopener\">Google Sheets Tips<\/a><\/strong> provided on this page, you can open the hyperlinks in Spreadsheet with just a single click. Read further to find more.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"601\">\n<p style=\"text-align: center;\"><strong>Table of Contents<\/strong><\/p>\n<ul>\n<li><a href=\"#How-to-Create-a-Single-Click-Link-in-Google-Sheets?\">How to Create a Single Click Link in Google Sheets?<\/a><\/li>\n<li><a href=\"#How-to-Unpublish-Google-Sheets-from-Web-Formatting?\">How to Unpublish Google Sheets from Web Formatting?<\/a><\/li>\n<\/ul>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2 id=\"How-to-Create-a-Single-Click-Link-in-Google-Sheets?\">How to Create a Single Click Link in Google Sheets?<\/h2>\n<p>The steps to create a single one click hyperlink in Google Spreadsheet are given below:<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Open Google Spreadsheet on your device where you want the hyperlink to open in a new tab.<\/li>\n<li><strong>Step 2:<\/strong> Now click on the \u201c<strong>File<\/strong>\u201d tab in the menubar and choose \u201c<strong>Publish to the web<\/strong>\u201d from the drop down menu.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1522 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-create-a-single-click-hyperlink-in-google-sheets.png\" alt=\"how-to-open-links-in-google-sheets-with-a-single-click\" width=\"471\" height=\"500\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-create-a-single-click-hyperlink-in-google-sheets.png 471w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-create-a-single-click-hyperlink-in-google-sheets-283x300.png 283w\" sizes=\"(max-width: 471px) 100vw, 471px\" \/><\/p>\n<ul>\n<li><strong>Step 3:<\/strong> Here the \u201c<strong>Publish to the web<\/strong>\u201d window will open on the screen with various options.<\/li>\n<li><strong>Step 4:<\/strong> Under the \u201c<strong>Link<\/strong>\u201d section, choose \u201c<strong>Entire Document<\/strong>\u201d from the drop down menu.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1531 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-22.png\" alt=\"how-to-open-links-in-google-sheets-with-a-single-click\" width=\"512\" height=\"474\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-22.png 512w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-22-300x278.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<ul>\n<li><strong>Step 5:<\/strong> In the second drop down menu, choose \u201c<strong>Web Page<\/strong>\u201d from the options list.<\/li>\n<li><strong>Step 6:<\/strong> Now move to the \u201c<strong>Published Content and Settings<\/strong>\u201d section and click on it.<\/li>\n<li><strong>Step 7:<\/strong> The extended pop-up section will open on the screen. Now choose the \u201c<strong>Automatically republish when changes are made<\/strong>\u201d option and then click on \u201c<strong>Start Publishing<\/strong>\u201d.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1530 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-23.png\" alt=\"how-to-open-links-in-google-sheets-with-a-single-click\" width=\"512\" height=\"607\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-23.png 512w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-23-253x300.png 253w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<ul>\n<li><strong>Step 8:<\/strong> Now a prompt window will appear on the screen. Read the message and click on the \u201c<strong>Ok<\/strong>\u201d button.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1529 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-24.png\" alt=\"how-to-open-links-in-google-sheets-with-a-single-click\" width=\"512\" height=\"649\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-24.png 512w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-24-237x300.png 237w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<ul>\n<li><strong>Step 9:<\/strong> Here you will see a pop up \u201c<strong>Publish to the web<\/strong>\u201d. Now move to this link box and copy the link. Use Ctrl+C to copy the link.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1528 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-25.png\" alt=\"how-to-open-links-in-google-sheets-with-a-single-click\" width=\"512\" height=\"664\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-25.png 512w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-25-231x300.png 231w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<ul>\n<li><strong>Step 10:<\/strong> Now open a new browser window in your device and paste the copied link in the address bar.<\/li>\n<li><strong>Step 11:<\/strong> This will open the Google Spreadsheet in the new window. Now you can start clicking on the hyperlinks and this will start opening the hyperlinks in the new tab.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1526 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-27.png\" alt=\"how-to-open-links-in-google-sheets-with-a-single-click\" width=\"512\" height=\"230\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-27.png 512w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-27-300x135.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<p>That is how you make it easier to open links in your spreadsheets!<\/p>\n<ul>\n<li><a href=\"https:\/\/sheetstips.com\/hyperlinks-in-google-sheets\/\">How to Create Hyperlinks in Google Sheets (Step-by-Step Guide)<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/table-of-contents-google-sheets\/\">How to Create a Table of Contents in Google Sheets (Add\/Update TOC)<\/a><\/li>\n<li><a href=\"https:\/\/sheetstips.com\/how-to-insert-a-google-sheets-spreadsheet-into-google-docs\/\">How to Insert a Google Sheets Into Google Docs (Merge Google Sheets with Docs)<\/a><\/li>\n<\/ul>\n<h3 id=\"How-to-Unpublish-Google-Sheets-from-Web-Formatting?\">How to Unpublish Google Sheets from Web Formatting?<\/h3>\n<p>For privacy reasons, it is usually better to unpublish the web page once you have finished working with your links. To do so, open your spreadsheet in Google Sheets and follow the steps given below:<\/p>\n<ul>\n<li><strong>Step 1:<\/strong> Click on the File tab.<\/li>\n<li><strong>Step 2:<\/strong> Choose the \u201c<strong>Publish to the web<\/strong>\u201d from the menubar.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1522 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-create-a-single-click-hyperlink-in-google-sheets.png\" alt=\"how-to-open-links-in-google-sheets-with-a-single-click\" width=\"471\" height=\"500\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-create-a-single-click-hyperlink-in-google-sheets.png 471w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-create-a-single-click-hyperlink-in-google-sheets-283x300.png 283w\" sizes=\"(max-width: 471px) 100vw, 471px\" \/><\/p>\n<ul>\n<li><strong>Step 3:<\/strong> Now a window will open on the screen. Choose \u201c<strong>Stop Publishing<\/strong>\u201d\u00a0 under &#8220;<strong>Published Content &amp; Settings<\/strong>&#8220;.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1525 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-28.png\" alt=\"how-to-open-links-in-google-sheets-with-a-single-click\" width=\"512\" height=\"667\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-28.png 512w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-28-230x300.png 230w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n<ul>\n<li><strong>Step 4:<\/strong> Now a window will prompt on your screen which says &#8220;<strong>Are you sure you want to stop publishing this document<\/strong>&#8220;.<\/li>\n<li><strong>Step 5:<\/strong> Click on the &#8220;<strong>Ok<\/strong>&#8221; button.<\/li>\n<\/ul>\n<p>This will stop publishing the file to the web.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1524 aligncenter\" src=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-29.png\" alt=\"how-to-open-links-in-google-sheets-with-a-single-click\" width=\"512\" height=\"586\" srcset=\"https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-29.png 512w, https:\/\/sheetstips.com\/wp-content\/uploads\/2021\/10\/image-29-262x300.png 262w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>By default, the links provided in Google Sheets will open only after double-clicking them. Although, double-clicking on a hyperlink will be quite annoying if you have multiple links to open at the same time. However, with the help of Google Sheets Tips provided on this page, you can open the hyperlinks in Spreadsheet with just &#8230; <a title=\"How to Open Links in Google Sheets with Single Click &#8211; Google Sheets Clickable Cell\" class=\"read-more\" href=\"https:\/\/sheetstips.com\/how-to-open-links-in-google-sheets-with-a-single-click\/\" aria-label=\"More on How to Open Links in Google Sheets with Single Click &#8211; Google Sheets Clickable Cell\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":446,"url":"https:\/\/sheetstips.com\/hyperlinks-in-google-sheets\/","url_meta":{"origin":1515,"position":0},"title":"How to Create Hyperlinks in Google Sheets (Step-by-Step Guide)","author":"Varsha","date":"May 19, 2022","format":false,"excerpt":"Hyperlinks in Google Sheet Cells: Hyperlinks help us to navigate the user from one to another page. Usually, the hyperlinks are commonly seen on Web pages. However, Google Sheets also allows using the text with hyperlinks with the help of which users can navigate from page to page. Let's understand\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"hyperlinks-in-google-sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/08\/hyperlink-in-google-sheets6.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1533,"url":"https:\/\/sheetstips.com\/how-to-share-a-google-sheets-as-web-page\/","url_meta":{"origin":1515,"position":1},"title":"How to Publish Google Sheets as Web Page: Share Google Sheets to Public","author":"Varsha","date":"December 5, 2022","format":false,"excerpt":"Google Sheets webpages are one of the most significant ways to share information with a large number of users and publish it. Publishing Google Sheets into a webpage will come in handy since it is a lightweight webpage and any user can access it. Also, if one uses the right\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"how-to-open-links-in-google-sheets-with-a-single-click","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/10\/how-to-create-a-single-click-hyperlink-in-google-sheets.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":680,"url":"https:\/\/sheetstips.com\/table-of-contents-google-sheets\/","url_meta":{"origin":1515,"position":2},"title":"How to Create a Table of Contents in Google Sheets (Add\/Update TOC)","author":"Varsha","date":"May 18, 2022","format":false,"excerpt":"Table of contents is one most useful features which we often use in Google Docs and other editing software. However, we don't have the Table of Contents feature in Google Sheets. But still, you are working on the huge data set and want to insert the table of contents inside\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"table-of-contents-google-sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/08\/table-of-contents-in-google-sheets4-1.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":1165,"url":"https:\/\/sheetstips.com\/slicer-google-sheets\/","url_meta":{"origin":1515,"position":3},"title":"How to Use Slicer in Pivot Tables in Google Sheets (Add\/Delete\/Customize Slicers)","author":"Varsha","date":"May 16, 2022","format":false,"excerpt":"Slicers in Google Sheets are an effective tool for filtering data in Pivot Tables. With a single click, they make it simple to change values in Pivot Tables and Charts. Slicers come in handy when creating dashboards in Google Sheets. In this article, let us understand how to use Slicer\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"slicer-google-sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/09\/slicer-in-google-sheets7.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":3686,"url":"https:\/\/sheetstips.com\/extract-hyperlink-url\/","url_meta":{"origin":1515,"position":4},"title":"How To Get A Hyperlink From A URL &#8211; Formula To Extract URL From Hyperlink In Google Sheets","author":"Varsha","date":"June 27, 2022","format":false,"excerpt":"Anchor text is more recognizable to most people than URLs. Users, on the other hand, would want to know the URL address for a number of reasons. In Google Sheets, URLs may be readily extracted from a given text. Google Sheets users may extract hyperlinks from the text in a\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"extract-hyperlink-url","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2022\/06\/extract-hyperlink-url.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":802,"url":"https:\/\/sheetstips.com\/heat-map-google-sheets\/","url_meta":{"origin":1515,"position":5},"title":"How to Create and Use Heat Map in Google Sheets With Examples","author":"Varsha","date":"May 17, 2022","format":false,"excerpt":"Google Sheets Heatmaps are a quick and easy way to display and discover anomalies in data, and Google Sheets makes it simple to do so. We can change the color of a cell based on its value using the Google Sheets Conditional Formatting function. In this article, let's understand everything\u2026","rel":"","context":"In &quot;Google Sheets&quot;","block_context":{"text":"Google Sheets","link":"https:\/\/sheetstips.com\/category\/google-sheets\/"},"img":{"alt_text":"heatmaps in google sheets","src":"https:\/\/i0.wp.com\/sheetstips.com\/wp-content\/uploads\/2021\/09\/heatmap-in-google-sheets2-1.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]}],"_links":{"self":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/1515"}],"collection":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/comments?post=1515"}],"version-history":[{"count":4,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/1515\/revisions"}],"predecessor-version":[{"id":2547,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/posts\/1515\/revisions\/2547"}],"wp:attachment":[{"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/media?parent=1515"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/categories?post=1515"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sheetstips.com\/wp-json\/wp\/v2\/tags?post=1515"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}