By default, you need to make two clicks to open a link in a Google Sheets spreadsheet. Using a workaround, you can make it so that the link opens with a single click. Weāll show you how to do this.
How This Works
This workaround publishes your Google Sheets spreadsheet as a web page. You then single-click the links on this web page to open them.
Google gives you a unique URL for your published web page. You use this URL to access your spreadsheet as a web page on the internet. Make sure that you only share this URL with those who you want to give access to your spreadsheetās data.
Open Links in a Google Sheets Spreadsheet with a Single Click
To begin, open Google SheetsĀ in your web browser and access your spreadsheet.
When the spreadsheet opens, click File> Publish to the web in the Google Sheets menu bar.
On the āPublish to the webā pop-up that opens, click the āLinkā tab. Then, click āEntire Documentā and choose whether to publish your entire spreadsheet or a specific sheet. Select āWeb Pageā from the second drop-down menu.
Then, click āPublished content & settingsā to view more options.
In the expanded pop-up, activate the āAutomatically republish when changes are madeā option, and then click āStart publishing.ā
Select āOKā in the prompt that appears on your screen.
You can now see a link in the āPublish to the webā pop-up. Click this link box and press Ctrl+c on Windows or Command+c on Mac to copy the link.
Open a new tab in your browser, paste the copied link in the address bar, and press āEnter.ā
Now, you can single-click any link in your spreadsheet (which has been published as a web page) to open the link.
And thatās how you make opening links easier in your spreadsheets!
When youāre finished working with your links, itās probably best to unpublish the web page for privacy reasons.Ā To do this, open your spreadsheet with Google Sheets, click File> Publish to the web in the menu bar, and select āStop publishing.ā
Thatās it!