Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I multi-paste?
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! |
#2
|
|||
|
|||
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. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Julie P." wrote in message ... 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! |
#3
|
|||
|
|||
Julie,
Best not to post a question to more than one group. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Julie P." wrote in message ... 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! |
#4
|
|||
|
|||
"Earl Kiosterud" wrote in message
... 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. 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 |
#5
|
|||
|
|||
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. "Julie P." wrote in message ... 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! |
#6
|
|||
|
|||
Julie,
The newsgroups are used quite randomly. There are many posts in ..worksheetfunctions that have nothing to do with worksheet functions (SUM(), IF(), etc). And macro questions that you'd expect to find in .programming are in other newsgroups. I have no idea of the intended difference between ..excel and .excel.misc. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Julie P." wrote in message ... "Earl Kiosterud" wrote in message ... 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. 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 |
#7
|
|||
|
|||
"Jim May" wrote in message
news:lLDVd.30290$7z6.26976@lakeread04... 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. 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. |
#8
|
|||
|
|||
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 -- Dana DeLouis Win XP & Office 2003 "Julie P." wrote in message ... "Jim May" wrote in message news:lLDVd.30290$7z6.26976@lakeread04... 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. 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lost my Paste | Excel Discussion (Misc queries) | |||
Not able to Paste cells | Excel Discussion (Misc queries) | |||
Paste without including cell borders | Excel Worksheet Functions | |||
Paste Special | Excel Discussion (Misc queries) | |||
Paste Special Question | Excel Discussion (Misc queries) |