Is there a way to check all songs with an "!" next to them at once on iTunes?

Okay, this has been bugging me for a while. I accidentally let iTunes import an old library from before I reformatted my hard drive, so literally half of all my songs have the little ”!” next to them, meaning the file cannot be found.

So far I’ve had to go through each individual song and delete it (or press ctrl-click to get multiples at once) but I would love to find an easier way.

Any suggestions?