Excel problems

  Wessie 16:19 14 Dec 2006
Locked

I am using Excel 2003 and I have a large-ish (700kb, 5 worksheet) spreadsheet with mostly fixed data (i.e. few formulas). When copying four cells pasting these takes 0.5 seconds which seems rather odd. As i have to do this hundreds of times, it's rather time consuming.

I have tried moving the relevant worksheet into a new document but the issue remains.

I also tend to use the autofilter function to find relevant rows which have to be modified (i.e. where i need to paste the relevant cells into). However, there is no convenient way to hightlight only the visible (ie. autofiltered) rows and hit 'paste' to fill all relevant cells at once. Do you know of a way?

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

What is ransomware and how do I protect my PC from Petya?

Microsoft Surface Studio – the artist's hands-on review

Original iPhone review

Comment mettre à jour Kodi ?