1) So when it says in the lower left corner of excel *'copying comments' , it
is not really just copying the cell comments only and does not relate to
copying the cell formulas? *

Seems to do the 2 as separate tasks. So it does refer just to the
comments. If you hit Escape, you should see the formulas already
pasted.

2) There are a very small amount of cells that have comments and maybe it is
taking so long is because excel is hunting for comment cell? *Never had the
slowness or 'copying comments' notifcation before.

I'm guessing your spreadsheet has gotten big enough that it is now an
issue.

3)Not all my cells have comments. *How can I select all my numerous cell and
ask excel to delete the cells that have comments? *I don't have time to hunt
for them.

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.