Issues with hyperlinks not moving with sorted text
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?
Excel spreadsheet data entry
Hello, I have had to re-type multiple spreadsheets in Excel due to when opening the spreadsheets I need they appear corrupt, jumbled, data is scattered. I'm trying to avoid re-typing as I've been forced to do. All the solutions I'm finding are very, very tedious. Any suggestions are helpful. I've tried converting it, copy/pasting different ways, formatting different ways. No luck. Even copy/pasting from PDF which I also have of the data & it pastes very incorrectly & unreadable. HELP!? Thank you!