Turn off Automatic Hyperlinks
Does it annoy you when Excel automatically turns an email or web address into a hyperlink when you want it entered as text? In Excel 2007 you can prevent this from happening by clicking on the Office button and going to Excel Options -> Proofing -> Deselect the option titled "Ignore Internet and file addresses".
The The Spreadsheet Page has a tip titled Removing or Avoiding Automatic Hyperlinks that covers this very topic. The tip provides the following macro which will allow you to instantly turn all of your hyperlinks into text. The macro really helped me as I had a sheet with over 100 links to zap.
Sub ZapHyperlinks()
Cells.Hyperlinks.Delete
End Sub
As I'm just making the switch from Excel 2003 to 2007 it made me think . . . what features do Excel users automatically turn on or off when moving to a different version? Understanding that everyone has their own preferences, I'd like to hear about those features that are a "must have" or that you immediately shut off.
Another trick is to hit Ctrl-Y (Undo) immediately after the hyperlink is created. The text is retained, but the link is removed.