Click Edit-Find and in the options choose the format from a cell with a
hyperlink, click find All, select all cells by pressing ctrl+A then press
delete.

"Jane" wrote:

I have 280 hyperlinks in Excel 2007 worksheet which I want to delete without
having to do each one manually. Does anyone know a short cut that will
delete them all in a few key strokes? Many thanks in anticipation