Select all the cells where you want to delete comments. Probably just
by selecting entire columns, I would guess. Right-Click and select
Delete Comments in the menu. It will delete all of them in the
selected cells.

Actually, I just noticed that the Delete Comments option is not
available if you select an entire column. So you have to select the
area manually.