Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How to deal with "cannot paste data" issue in excel?

user-image
Question ajoutée par Mohammad Awartani , Technical Support Specialist , Arab Bank PLC
Date de publication: 2016/03/09
Emad Mohammed said abdalla
par Emad Mohammed said abdalla , ERP & IT Software, operation general manager . , AL DOHA Company

I fully agree with the answers been added by EXPERTS................Thanks.

Aeisha Abdul Kader
par Aeisha Abdul Kader , Accountant / Professional Assistant , VM Apparel CC

Depending on how you've copied the info. If you have copied an entire cell and wish to paste into the formula bar or by double clicking into another cell, it will give you this problem. Easiest thing to do is hit Esc and copy again and paste by only clicking once on the cell you want to paste into.

Abdelmonaam Kallali
par Abdelmonaam Kallali , Data application developer , DragonWave

By just hitting Esc, you can copy again and paste

manseer muhammed ali
par manseer muhammed ali , Accountant General , Royal Lighting L.L.C & Royal Furnishing LLC

I don’t have a proper solution but here’s a work-around for this issue – Paste to Word and then copy and paste back to Excel.

Even a reboot might resolve the problem.

See how it goes.

Avani Darji
par Avani Darji , Internal Auditor / QC Head (ISO) , Shrinivas Sugandhalaya LLP

We can solve this issue by using "Paste Special" function.

Davinder Singh Davinder Singh
par Davinder Singh Davinder Singh , Deputy Section Officer , Dayanand Medical College & Hospital, Ludhiana

Many of the times we copy any information from a cell which contains formulas and it gives errors some times if we simply press CTRL + V. To resolve this error use paste special command. Right Click on the destination cell and there shall be a window with many options like All, formulas, values, format and so on. Select any of them and paste it.   

More Questions Like This