قالب وردپرس درنا توس
Home / Tips and Tricks / How to open links in Google Sheets with one click

How to open links in Google Sheets with one click



Google Sheets logo on green background

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.

Click

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.

Configure publishing options for a spreadsheet in Google Sheets.

In the expanded pop-up, activate the option “Automatically republish when changes are made” and then click “Start publishing”.

Click

Select “OK” from the prompt that appears on your screen.

Select

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.

Copy link of the

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.

A Google Sheets spreadsheet published as a web page.

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.”

Select

That is it!

RELATED: The Beginner’s Guide to Google Sheets




Source link