LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 622
Default slow copying problem

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Any new developments in the Excel 2007 slow charting problem? [email protected] Excel Discussion (Misc queries) 6 October 24th 07 01:21 PM
Slow Excel Navigation with Up / Down Arrow and slow scrolling deddog Excel Discussion (Misc queries) 0 August 14th 07 09:56 PM
D-sum and Grouping slow down problem Ben Excel Worksheet Functions 2 April 26th 07 03:58 PM
Copying problem MartinW Excel Worksheet Functions 7 April 14th 06 06:12 PM
Problem with Slow ReCalculation of Dynamic Range Using OFFSET Kris_Wright_77 Excel Worksheet Functions 2 November 18th 05 10:18 AM


All times are GMT +1. The time now is 10:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"