I have formatted the cells in a database I built in Excel 2013.
The problem is, I need other people to copy rows and redirect the hyperlink on the new row to a new page. But when you add a hyperlink Excel "helpfully" undoes the formatting I've inserted.
I know I can change the default hyperlink formatting in styles, and as a last resort I will change it to the most common formatting I need hyperlinked cells to use. But since I don't want to have to format all my hyperlinks the same, is there anyway I can make Excel stop being so helpful?
The problem is, I need other people to copy rows and redirect the hyperlink on the new row to a new page. But when you add a hyperlink Excel "helpfully" undoes the formatting I've inserted.
I know I can change the default hyperlink formatting in styles, and as a last resort I will change it to the most common formatting I need hyperlinked cells to use. But since I don't want to have to format all my hyperlinks the same, is there anyway I can make Excel stop being so helpful?
