Kuphatikiza mizati iwiri ndi deta

Zamkatimu

Ntchito yosavuta. Tili ndi mizati iwiri yokhala ndi data yosagwirizana m'maselo:

Muyenera kuphatikiza deta kuchokera pamizere iwiri kukhala imodzi (mwachitsanzo, kuwerengera kwina, etc.) Mukhoza kuyamba kuganizira za mafomu kapena macros, koma pali njira yosavuta komanso yokongola kwambiri.

Sankhani ma cell omwe ali mugawo lachiwiri ndipo, podina kumanja pa iwo, sankhani lamulo Koperani (Koperani) (kapena dinani njira yachidule ya kiyibodi Ctrl + C)

Sankhani ma cell omwe ali mgawo loyamba ndikudina kumanja pa iwo, sankhani lamulo Matani apadera (Paste Special). Mukhozanso kugwiritsa ntchito njira yachidule ya kiyibodi Ctrl + Alt + V. Pawindo la Paste Special Options lomwe limatsegulidwa, yambitsani bokosi loyang'anira Dumphani ma cell opanda kanthu (Dumphani zomwe zikusowekapo) ndipo dinani OK:

Zomwe zakopedwa kuchokera pagawo lachiwiri zidzayikidwa koyamba. Pamenepa, ma cell opanda kanthu kuchokera pamndandanda wachiwiri adzalumphidwa poyikapo ndipo sangalembenso zomwe zili pamndandanda woyamba. Zimatsalira kuchotsa gawo lachiwiri, lomwe silikufunikanso, ndipo ndizomwezo:

Zosavuta komanso zothandiza, sichoncho?

  • Gwirizanitsani milingo iwiri popanda kubwereza pogwiritsa ntchito chowonjezera cha PLEX

 

Siyani Mumakonda