Copy/Paste - Running out of Memory

[Cheval]

I friend of mine keeps having windows 2000 tell him/her that the copy/paste
operation cannot complete due to low memory.

I'm informed that they do the same thing all the time, but some times
Windows complains.

Steps to reproduce.
1) Open a Excel workbook with data in it. (Any actually)
2) Select a range. (make it a decent size)
3) Open a new worksheet
4) Left click the cell above the 1 and left of the A.
5) Left click edit->Paste.

So if anyone can offer any advice on how to help a user paste into the cell
A1 and not every cell, that would be great. Thanks.

PS. Also any advice on how to teach users that the DVD drive tray isn't a
coin scanner, that also would help.

 

[Bernie Deitrick]

4) Left click the cell above the 1 and left of the A.

Left click cell A1 - otherwise, you are selecting all the cells in the worksheet, and Excel will
try to fill them if it can.

HTH,
Bernie
MS Excel MVP