Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / August 2007

Tip: Looking for answers? Try searching our database.

Copy/Insert rows

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Niniel - 31 Aug 2007 19:26 GMT
Hello,

I am copying rows and inserting them further down the sheet. Trouble is, I
can only select and copy 10 rows before Excel claims it's out of "resources".
That's a bit annoying since I need to copy 200 rows - repeatedly.
Is there a way to free up "resources" so that I could, copy, say, 20 rows at
a time?
Or are there better methods altogether? I am essentially replicating data,
although every 200 row chunk is slightly different; find/replace takes care
of that.

Thank you.
Niniel - 31 Aug 2007 19:56 GMT
Haha, never mind.
The "fix" is called "ignore the error message and pretend it never
happened", at least with the Office clipboard on.
Frank Pytel - 31 Aug 2007 22:28 GMT
Niniel;

I am glad you found a work around. That's great. But it could increase your
file size fairly significantly. You can keep the file size down by locating
the row you wish to use and keying the formula =A1 (whatever column) and then
draggin that formula down the row. I am not much for keyboard shortcuts, but
I am sure you can use a keyboard shortcut instead of mouse dragging.

Frank

> Haha, never mind.
> The "fix" is called "ignore the error message and pretend it never
> happened", at least with the Office clipboard on.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.