title: In Google Sheets, Is there a way to use hyperlinks in a data validated range?
body: <p>In Google Sheets, a cell using a data validated range consisting of hyperlinks will only display the link text and is not an actual link.</p>
  
  <p>Example, I have a google spreadsheet consisting of 2 sheets.  Sheet 1 has a cell with data validation getting it's values from a range on sheet 2, like so <code>Sheet2!B2:B50</code></p>
  
  <p>Sheet 2 cell B2 contains a hyperlink like this: </p>
  
  <p><code>=hyperlink("https://docs.google.com", "LINK TEXT")</code></p>
  
  <p>When you select that item back in Sheet 1 in the validated cell, the cell only displays <code>LINK TEXT</code> and is not a hyperlink.</p>
  
  <p>Is there a way to use hyperlinks in a data validated range?</p>