Home

Hyperlinking multiple filtered cells

%3CLINGO-SUB%20id%3D%22lingo-sub-463396%22%20slang%3D%22en-US%22%3EHyperlinking%20multiple%20filtered%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-463396%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BI%20filter%20out%20a%20column%20to%20show%20only%20cells%20that%20have%20a%20certain%20value%2C%20and%20then%20I%20wish%20to%20add%20a%20simple%20hyperlink%20(right%20click%2C%20link)%20to%20a%20separate%20PDF%20document.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20do%20this%2C%20all%20of%20the%20filtered%20out%2C%20non%20visible%20cells%20in%20between%20the%20the%20cells%20that%20I%20wish%20to%20add%20links%20to%20also%20get%20linked.%26nbsp%3B%20They%20do%20NOT%20get%26nbsp%3B%20text%20added%20to%20them%20or%20modified%2C%20but%20they%20absolutely%20get%20a%20link%20added.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20avoid%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-463396%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EHYPERLINK%20FILTERED%20CELLS%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
landis1234
Occasional Visitor

 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 out, non visible cells in between the the cells that I wish to add links to also get linked.  They do NOT get  text added to them or modified, but they absolutely get a link added.

 

How can I avoid this?