Home

Issues with hyperlinks not moving with sorted text

%3CLINGO-SUB%20id%3D%22lingo-sub-813490%22%20slang%3D%22en-US%22%3EIssues%20with%20hyperlinks%20not%20moving%20with%20sorted%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-813490%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20created%20a%20hyperlink%20in%20excel%20and%20sorted%20the%20document%2C%20the%20data%20within%20the%20cells%20moved%20to%20accommodate%20the%20sorting%20but%20the%20hyperlinks%20did%20not.%20For%20example%2C%20my%20hyperlink%20for%20line%202%20stays%20the%20same%20(linking%20to%20document%201)%20even%20though%20the%20in-Excel%20text%20linked%20to%20the%20document%20has%20changed%20(with%20the%20blue%20text%20denoting%20document%202).%20How%20do%20I%20edit%20hyperlinks%20in%20Excel%20so%20they%20follow%20their%20assigned%20text%20when%20sorted%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-813490%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Hyperlink%20copying%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Issues%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Spreadsheet%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-814105%22%20slang%3D%22en-US%22%3ERe%3A%20Issues%20with%20hyperlinks%20not%20moving%20with%20sorted%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-814105%22%20slang%3D%22en-US%22%3EUse%20the%20HYPERLINK%20function%20and%20refer%20to%20a%20cell%20(or%20cells)%20as%20your%20link_location%20argument.%3C%2FLINGO-BODY%3E
Highlighted
Inforegallaw
Occasional Visitor

When I created a hyperlink in excel and sorted the document, the data within the cells moved to accommodate the sorting but the hyperlinks did not. For example, my hyperlink for line 2 stays the same (linking to document 1) even though the in-Excel text linked to the document has changed (with the blue text denoting document 2). How do I edit hyperlinks in Excel so they follow their assigned text when sorted?

1 Reply
Use the HYPERLINK function and refer to a cell (or cells) as your link_location argument.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
33 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies