I can't paste from one cell to multiple cells anymore.

**fdavis** · #1 May 24th 12, 05:04 PM

I need to paste the same text from one cell into multiple cells but when I click to copy it won't "highlight" the cell with the rotating dotted circle around it anymore and then when I select multiple cells to paste it will only paste to one cell. For example; if I have today's date in one cell and I need to paste it to 20 more cells it only allows me to do it one at a time now. Please help.

**Spencer101** · #2 May 24th 12, 07:23 PM

Quote:

Originally Posted by fdavis

I need to paste the same text from one cell into multiple cells but when I click to copy it won't "highlight" the cell with the rotating dotted circle around it anymore and then when I select multiple cells to paste it will only paste to one cell. For example; if I have today's date in one cell and I need to paste it to 20 more cells it only allows me to do it one at a time now. Please help.

Could you post an example workbook that this is happening in?

**fdavis** · #3 June 5th 12, 04:00 PM

Quote:

Originally Posted by Spencer101

Could you post an example workbook that this is happening in?

also, my cut doesn't work....the selected cell won't actually cut and disappear. attached is an example.

**fdavis** · #4 June 5th 12, 04:03 PM

Quote:

Originally Posted by fdavis

also, my cut doesn't work....the selected cell won't actually cut and disappear. attached is an example.

I can't upload an example because this site doesn't support xlsx files. How can I get this example to you?

**Mikiki** · #5 June 6th 12, 04:24 PM

I am also having this problem, it started on Thursday and is very frustrating as most of my work is based on Excel, please someone help, my IT department have looked and can't even work it out, just switch it off and restart your computer they advised.... it never works...

**Claus Busch** · June 6th 12, 08:45 PM posted to microsoft.public.excel.worksheet.functions

Hi,

Am Thu, 24 May 2012 16:04:42 +0000 schrieb fdavis:

> I need to paste the same text from one cell into multiple cells but when
> I click to copy it won't "highlight" the cell with the rotating dotted
> circle around it anymore and then when I select multiple cells to paste
> it will only paste to one cell. For example; if I have today's date in
> one cell and I need to paste it to 20 more cells it only allows me to do
> it one at a time now. Please help.

deaktivate or deinstall the Skype Click-to-call-AddIn

Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
In Excel 2007 I cannot Paste anymore?	jean	Excel Discussion (Misc queries)	2	June 7th 09 12:59 AM
While doing multiple cell copy paste the Selection.PasteSpecial overrides the protected formula cells	Sameet	Excel Programming	1	August 19th 08 06:00 AM
Can't Access Paste Special Anymore	Joe VW	Excel Worksheet Functions	5	November 4th 06 03:06 PM
macro copy/paste data from multiple cells to multiple cells	Diana	Excel Discussion (Misc queries)	0	July 10th 06 09:24 PM
How do I paste data from multiple cells into one cell	WiVikeFan	Excel Discussion (Misc queries)	1	November 18th 05 11:28 PM