Sometimes you need to open several links in Google Sheets. But opening them separately one by one is a chore / bore.
Open them all with two clicks!
- Select cells containing links.
- Open them simultaneously by right clicking and selecting Open links option.
Pretty easy, right?
This doesn’t work anymore.
Thanks! There’s a shortcut for it…
1. Highlight the links you want to open.
2. Press Alt+Enter
Just make sure you don’t open too many links that your computer won’t be able to handle!
Love this trick! Worked really well for me to enable download multiple CSV files that had consistently formatted URLs.
FYI, as of this writing the right-click menu item now reads “Open links” instead of “Open all links”. On the Mac the keyboard shortcut is Option + Enter.
This is great, thank you!!
I’ve tested this on 2020-02-07 in Firefox 85, it DOES work. Only thing that’s changed is the label, it’s now called “Open links”.
THANK. YOU. I can’t believe I haven’t seen that before lol