Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am having a problem with cut & paste, and copy & paste. I lose the formatting when I paste. Also, the cut does not cut but just works as "copy". And when I select the cell and do cut or copy, it does not highlight the cell. And paste special only has a couple of selections, that is, Unicode, etc.

Useful additions by new users:

Laila 02.04.12 - I can add some info to the problem: I've been trying to solve for weeks. I use Office 2007 and the software is fully updated. I have no macros on any excel sheets on my computer that could cause this. We have tried to reset the software with no luck. We have tried to re-install microsoft office where we also removed several regestry files, but with no luck. The problem appears also when you work with one single sheet. Paste special does not work at all.

share|improve this question
    
Please tell us which version of Excel you're using, as well as the underlying operating system, and whether you are on a domain or local network. Include whether this is a problem in an existing workbook, or all XLS files. Regarding a part of your question, Excel does not "cut" all the time (i.e. it will leave the cells intact in certain circumstances). –  user3463 Mar 27 '12 at 7:11
    
was years ago when I used excel but I found when I chose Cut, it looks a bit like a copy, but when you then do paste, the cell you clicked cut on becomes clear, so it does cut, but you only see it when you paste afterwards. that's what i saw anyway when I used excel. don't know much about the formatting. –  barlop Mar 27 '12 at 8:17
add comment

1 Answer

It sounds to me like you're trying to cut/copy and paste between two different instances of Excel (ie, you've opened Excel multiple times rather than opening new workbooks within the program).

You can only preserve formatting and have all the Paste Special options available when you're working between two workbooks in the same Excel instance.

Useful additions by new users:

02.04.2012 LM - Try removing the software Skype Click-to-Call. I've read that it causes problems for excel 2007 and 2010. I did this on my computer and it instantly worked after.

2012-04-03, smitil: I had the same experience, i.e. when trying to Cut in Excel it worked like Copy (did not delete the initial data). I confirm that I removed the Skype Click-to-Call and instantly fixed the problem.

01-04-2013 - Jim: I'm on Mac OS 10.8.3 and had the same issue. Uninstalled Skype and my keyboard shortcuts to copy, cut and paste came right back.

share|improve this answer
    
I have experienced the skype problem as well....just remove click to call....not entire skype.. –  tumchaaditya Jun 11 '12 at 11:38
    
01-04-2013 - Jim: I'm on Mac OS 10.8.3 and had the same issue. Uninstalled Skype and my keyboard shortcuts to copy, cut and paste came right back. –  Nifle Jan 4 '13 at 15:51
add comment

protected by Community Mar 30 '12 at 21:03

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.