Click URL in Google Sheets

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

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

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.

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.