How to open link in "sheet name" column of a report in new tab?

Here is a situation that I need help with. I have a row report that includes the default "Sheet name" column. The automatically generated link in that column is great for taking the user to the correct row in the source sheet. However, I am unable to find a way to open that link in a new tab - so that both the report and the source sheet can be open at the same time (and not replace each other every time a link is clicked). Right Clicking and selecting "open in new Tab" doesn't work in this scenario.

Similar question - how do I open a hyperlink that I inserted into a cell in a new tab? (right clicking only gives me the cell menu, but no option to open the hyperlink in a new tab.)

Best Answer