How do I multi-paste?

J

Julie P.

Hi, for Microsoft Word, all I have to do is copy something, and then I can
keep pasting that forever by just clicking "paste" repeatedly.

But for Microsoft Excel, this does not work. You can paste only one time,
and that is it.

Is there any way I can lift this restriction?

Thanks!
 
E

Earl Kiosterud

Julie,

You can paste as many times as you want. The unusual thing about Excel is
that if you do other stuff, like type something into a cell, delete a cell,
etc., the clipboard is lost. No one knows why this is. At least I don't.
 
J

Julie P.

Earl Kiosterud said:
Julie,

You can paste as many times as you want. The unusual thing about Excel is
that if you do other stuff, like type something into a cell, delete a
cell, etc., the clipboard is lost. No one knows why this is. At least I
don't.
Click to expand...

thanks Earl. You are right. So once you do something else, the clipboard is
lost. Sorry about the cross-posting. I am not sure of the difference
between:
Microsoft.public.excel.misc and microsoft.public.excel
 
J

Jim May

I use Control+C to get my Copy Range, then (select another range) Control+V,
(select another range) Control+V,
(select another range) Control+V,
(select another range) Control+V,
to multipaste;
works like a charm.
 
J

Julie P.

Jim May said:
I use Control+C to get my Copy Range, then (select another range)
Control+V,
(select another range) Control+V,
(select another range) Control+V,
(select another range) Control+V,
to multipaste;
works like a charm.
Click to expand...

Thanks Jim. You are right, but the problem is as soon as you do something
else, the contents of your clipboard disappear, unlike with MS Word!

J.
 
D

Dana DeLouis

Hi July. The issue with Excel for Windows is that I don't think Excel
actually copies anything to the clipboard. All Excel does during a copy
operation (more than one cell), it just establishes a link, called "CutCopy"
mode. If you do anything that might break the integrity of that link, or if
Excel thinks that you "could have" broken the integrity of that link, then
Excel will remove itself from cutcopy mode. Excel considers anything over
100 cells to be "a lot of cells."
HTH
 
Top