Select the range to clean up (ctrl-a a few times will select all the cells)
hit alt-f11 (to get to the VBE)
hit ctrl-g (to see the immediate window)
type this and hit enter:

selection.hyperlinks.delete

Leon wrote:

I've had a hyperlink problem in my Excel files for ages: false hyperlinks had
been created (even in empty cells) and were multiplying regularly whenever I
inserted new lines. How can I delete all hyperlinks in a sheet at once and
not have to delete them cell by cell?

--

Dave Peterson