ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Mohammad Awartani , Technical Support Specialist , Arab Bank PLC
تاريخ النشر: 2016/03/09
Emad Mohammed said abdalla
من قبل 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
من قبل 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
من قبل Abdelmonaam Kallali , Data application developer , DragonWave

By just hitting Esc, you can copy again and paste

manseer muhammed ali
من قبل 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
من قبل Avani Darji , Internal Auditor / QC Head (ISO) , Shrinivas Sugandhalaya LLP

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

Davinder Singh Davinder Singh
من قبل 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.   

المزيد من الأسئلة المماثلة

هل تحتاج لمساعدة في كتابة سيرة ذاتية تحتوي على الكلمات الدلالية التي يبحث عنها أصحاب العمل؟