Forum Discussion
Hyperlinking multiple filtered cells
I filter out a column to show only cells that have a certain value, and then I wish to add a simple hyperlink (right click, link) to a separate PDF document. When I do this, all of the filtered ...
One possible solution is to create a new column with the hyperlink and then use the FILTER function to only display the filtered cells in that column. Here are the steps you can follow:
- Insert a new column next to the column you want to filter and add hyperlinks to.
- In the first cell of the new column, enter the hyperlink formula using the IF function to only apply the hyperlink to the filtered cells. For example: =IF(A2="value",HYPERLINK("path/to/file.pdf","link text"),"") Replace "value" with the value you are filtering for, "path/to/file.pdf" with the path to your PDF document, and "link text" with the text you want to display for the hyperlink.
- Copy the formula down the entire column.
- Filter the original column as desired.
- Use the FILTER function to only display the hyperlinked cells in the new column. For example:
=FILTER(B:B,A:A="value")
This should allow you to add hyperlinks only to the cells that are visible after filtering, without affecting the hidden cells.
I have the same issue and thank you so much, so mine is a bit different, so where you wanted your hyperlink to a PDF document, I wanted mine to go to a defeated sheet in the same excel document.