Maintaining hyperlinks after adding data, or sorting a list

Question

I have a list of a few hundred titles, with a few columns per entry (i.e. name, date, and such). Among the names I added entries that just say "A", "B", "C", etc., since it makes it easier when scrolling through the document, looking for specific names, to know where - for example - "H" starts.

As the list grew, I added hyperlinks to the top of the document to be able to jump to the A/B/C/etc.-entries. However, when adding new data and sorting it in, or when sorting the list by date or anything else, the hyperlink "Go to: A" (as an example) keeps linking to the original cell - A1 - despite the data of that cell (the actual text "A") is now in A42.

Is there anyway to maintain the hyperlinks, through sorting and [mainly] adding new data?

Answer 1

• Save the Excel spreadsheet a "Web Page" (and NOT "Single File Web Page".)
• Open the "Web Page" version in Excel.
• Sort it.
• Save it as an Excel spreadsheet.

Each link will be preserved in the appropriate cell.