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
I have a spreadsheet that everytime I sort the data it does the following: adds a blank line 1)erases the border around the last entry 2)changes the sort data from auto to one of the colors I have already specified to sort by ( I have to cut the header row & reinsert to get the information to sort correctly). 3)when I print the document it prints in small font (i am selecting several rows & telling the printer to only print the selection) Any help would be appreciated.