By default, you need to double click to open a link in a Google Sheets spreadsheet. Using a workaround, you can get the link to open with a single click. We’ll show you how to do this.
How this works
This workaround will publish your Google Sheets spreadsheet as a web page. You then click once on the links on this webpage 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 web. Make sure you only share this URL with those you want to access your spreadsheet data.
Open links in a Google Sheets spreadsheet with a single click
To get started, open Google Sheets in your web browser and open your spreadsheet.
When the spreadsheet opens, click File > Publish to Web in the Google Sheets menu bar.
In the “Publish to Web” pop-up window that opens, click the “Link” tab. Then click on “Full Document” and choose whether to publish your entire spreadsheet or a specific sheet. Select “Web page” from the second drop-down menu.
Then click on “Published Content and Settings” to see more options.
In the expanded pop-up, activate the option “Automatically republish when changes are made” and then click “Start publishing”.
Select “OK” from the prompt that appears on your screen.
You will 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 into the address bar and press “Enter”.
Now you can click once on a link in your spreadsheet (published as a web page) to open the link.
And this makes it easier to open links in your spreadsheets!
Once you’re done with your links, it’s probably best to unpublish the webpage for privacy reasons. To do this, open your Google Sheets spreadsheet, click File > Publish to Web in the menu bar, and select “Stop Publishing.”
That is it!
RELATED: The Beginner’s Guide to Google Sheets