slow copying problem

[yogart]

I have been working on a large sheet and copying/creating new column of
formulas,,and now it take forever for the copying to be completed, where as
before this same task was faster. In the lower left corner of excel it say
'copying comments' while it working to copy the cells. Not sure why it says
that. In the past when I had speed copying I don't think it did that.

How can I speed up copying of many column like it did in the past?

Thank you.

 

[Spiky]

I have been working on a large sheet and copying/creating new column of
formulas,,and now it take forever for the copying to be completed, where as
before this same task was faster.  In the lower left corner of excel itsay
'copying comments' while it working to copy the cells.  Not sure why itsays
that.  In the past when I had speed copying I don't think it did that.

How can I speed up copying of many column like it did in the past?

Thank you.

Try deleting the comments.

 

[yogart]

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?

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.

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.

 

[yogart]

1) When copying 500 formulas cells there may only be a few of them that have
(right click added) comments in, so this takes extra time to hunt for these
few comments and then copies them, and then copies the formulas in the cells?
Is that really thething slowing it down?

2)When excel give the small box saying 'copying comments', it also gives a
button to excape. If I would press the escape, would that also stop the
copying of the formulas in the cells?

 

[Spiky]

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 itis
taking so long is because excel is hunting for comment cell?  Never hadthe
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 tohunt
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.

 

[Spiky]

1) When copying 500 formulas cells there may only be a few of them that have

(right click added) comments in,  so this takes extra time to hunt for these
few comments and then copies them, and then copies the formulas in the cells?
Is that really thething slowing it down?  

See my other post about memory.

However, there may be some other options to just avoid the issue
altogether. For instance, you can choose Paste Formulas instead of a
standard Paste. This will not copy the comments. You can use Fill
commands either with the mouse (click on the lower right corner of a
cell and drag) or in the Edit menu. This will not copy comments,
either.

 

[Spiky]

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.