Click URL in Google Sheets

❓ Help and Questions
1

I have a series of links in Google sheets, how do I get it to click on the URL to open them?

2

Hi @antfernando9 ,

You can copy the text, open browser, paste it and then hit enter. You can copy and paste below steps.

SendKeys COPY
OpenBrowser Chrome -Incognito False
SendKeys PASTE
SendKeys ENTER

3

ok, I am very new to this, so I apologise in advance, how do I select the URL first? Then once completed, how do I get it to go to the next row and keep going down until it has reached an emply cell? I am still unable to find any comprehensive tutorials on how to use this tool.

4

You need to do manually highlight the text in the beginning or it will start from A1 when you open the sheet.

Please take a look at similar examples in knowledge base.