Google sheets provide the option to insert external links into the sheet as much as required. But one of the major issues faced by the Google sheets users is that they will have to click twice on the inserted link to be taken to the concerned web page. Although it might seem like a minor flaw, millions of users have found it inconvenient and the Google sheets have come up with a perfect solution to help open links in Google sheets with a single click. Even though it takes several more steps to make it possible, it provides more convenience to the user who tries to open any link.
How to open the links in Google sheets with a single click?
Step 1. Open the Google sheets application on the user’s device.
Step 2. Get to the required sheet and open it.
Step 3. Click on the File option that appears on the top menu bar.
Step 4. From the drop-down menu that appears, click on the Share option.
Step 5. From the available options, choose the Publish to web option.
Step 6. A dialogue box appears.
Step 7. From the box, choose the Link section.
Step 8. Choose whether the entire document has to be published as a webpage or a specific sheet.
Step 9. Click on the Embed section that is present just right to the Link section.
Step 10. Click on the Webpage option under the Embed section.
Step 11. Click on the Published Content and Settings option to get hold of more customization options.
Step 12. An expanded pop-up appears and from it, activate the option that lets auto-publication possible according to the updates in the document.
Step 13. Now, click on the Publish option.
Step 14. A pop-up appears asking permission to publish the document. Click the OK option if the document is ready to be published online.
Step 15. Another pop-up appears on the screen with a link that has to be copied for further use.
Step 16. Once the link is copied or shared, open a new tab on the respective browser on your device.
Step 17. Paste the copied link to the address bar of the browser and press Enter.
Step 18. The published document appears on the screen.
Step 19. Move the mouse pointer to the required link and click on it.
Step 20. The link is opened with a single click.
Step 21. Due to privacy reasons, it is always better to unpublish the webpage after use and for that, go to the concerned sheet on Google Sheets and choose the Share with the web option by following the initial steps mentioned above. A dialogue box appears with the necessary information on the published webpage.
Step 22. From the box, click on the Stop Publishing option.
Step 23. A pop-up appears asking permission to stop publishing the sheet. Click OK on it.
Step 24. The publishing is now retracted properly.