Kukopera tebulo mu Excel

Kukopera tebulo ndi imodzi mwamaluso ofunikira kwambiri omwe wogwiritsa ntchito aliyense wa Excel ayenera kukhala nawo kuti agwire bwino ntchito. Tiyeni tiwone momwe njirayi ingagwiritsire ntchito pulogalamuyo m'njira zosiyanasiyana, kutengera ntchitoyo.

Koperani ndi kumata tebulo

Choyamba, pokopera tebulo, muyenera kusankha zomwe mukufuna kubwereza (makhalidwe, mafomu, ndi zina). Zomwe zakopedwa zitha kuikidwa pamalo atsopano patsamba lomwelo, patsamba latsopano, kapena fayilo ina.

Njira 1: kukopera kosavuta

Njira imeneyi imagwiritsidwa ntchito kwambiri popanga matebulo. Zotsatira zake, mupeza kopi yeniyeni yamaselo omwe ali ndi mawonekedwe oyambira ndi ma formula (ngati alipo) osungidwa. Algorithm ya zochita ndi izi:

1. Mwanjira iliyonse yabwino (mwachitsanzo, pogwiritsa ntchito batani lakumanzere lokanikiza), sankhani kuchuluka kwa ma cell omwe tikufuna kuyika pa clipboard, mwa kuyankhula kwina, kukopera.
2. Kenako, dinani kumanja kulikonse mkati mwazosankha ndipo pamndandanda womwe ukutsegulidwa, imani pa lamulo "Koperani".Kuti mukopere, mutha kungodinanso kuphatikiza Ctrl + C pa kiyibodi (pambuyo posankha). Lamulo lofunikira litha kupezekanso pa riboni ya pulogalamu (tab "Pofikira", Gulu "Clipboard"). Muyenera kudina chizindikirocho, osati muvi wapansi pafupi ndi icho.
3. Timapita ku selo pa pepala lomwe tikufuna (m'bukuli kapena buku lina), kuyambira pomwe tikukonzekera kuyika zomwe zakopedwa. Selo iyi ikhala chapamwamba kumanzere kwa tebulo loyikidwa. Timadina pomwepa ndipo pamndandanda wotsitsa timafunikira lamulo "Ikani" (chizindikiro choyamba mu gulu "Paste Options"). Kwa ife, tasankha pepala lamakono.Mofanana ndi kukopera deta kuti muyike, mungagwiritse ntchito makiyi otentha - Ctrl + V. Kapena timadina pa lamulo lomwe mukufuna pa riboni ya pulogalamu (patsamba lomwelo "Pofikira", Gulu "Clipboard"). Muyenera dinani chizindikirocho, monga momwe tawonetsera pazithunzi pansipa, osati pazolembazo "Ikani".
4. Mosasamala kanthu za njira yosankhidwa yokopera ndi kuyika deta, kopi ya tebulo idzawonekera pamalo osankhidwa. Mapangidwe a ma cell ndi ma formula omwe ali mmenemo adzasungidwa.

Zindikirani: kwa ife, sitinayenera kusintha malire a selo pa tebulo lojambulidwa, chifukwa adayikidwa mkati mwa mizati yofanana ndi yoyamba. Nthawi zina, mutatha kubwereza deta, mumayenera kuthera nthawi pang'ono pa .

Njira 2: Koperani Zofunika Zokha

Pachifukwa ichi, tidzangotengera ma cell omwe asankhidwa okha, osasamutsa mafomu kupita kumalo atsopano (zotsatira zowonekera zidzakopedwa) kapena kupanga. Nazi zomwe timachita:

1. Pogwiritsa ntchito njira iliyonse yomwe yafotokozedwa pamwambapa, sankhani ndi kukopera zinthu zoyambirira.
2. Dinani kumanja pa selo lomwe tikukonzekera kuyikamo zomwe mwakopera, ndipo pamenyu yomwe imatsegulidwa, dinani kusankha. "Values" (chithunzi mu mawonekedwe a chikwatu ndi manambala 123).Zosankha zina za Paste Special zimaperekedwanso apa: mafomu okhawo, zikhalidwe ndi mawonekedwe a manambala, masanjidwe, ndi zina.
3. Zotsatira zake, tidzakhala ndi tebulo lomwelo, koma popanda kusunga mawonekedwe a maselo oyambilira, makulidwe ndi ma formula (zotsatira zomwe tikuwona pazenera zidzayikidwa m'malo mwake).

Zindikirani: Matani zosankha zapadera zimaperekedwanso mu riboni ya pulogalamu mu tabu yayikulu. Mutha kuwatsegula podina batani lolembapo "Ikani" ndi muvi wapansi.

Kutengera Makhalidwe Kusunga Mapangidwe Oyambirira

Mu menyu yankhani ya cell yomwe kuyikako kumakonzedwa, onjezerani zosankha "Special Paste" podina muvi womwe uli pafupi ndi lamuloli ndikusankha chinthucho "Values ​​ndi Source Formatting".

Zotsatira zake, tipeza tebulo lomwe silingafanane ndi loyambirira, komabe, m'malo mwa mafomula, lidzakhala ndi zikhalidwe zokhazokha.

Ngati tidina pazosankha za cell osati pa muvi womwe uli pafupi ndi iyo, koma pa lamulo lokha "Special Paste", zenera lidzatsegulidwa lomwe limaperekanso zosankha zosiyanasiyana. Sankhani ankafuna njira ndi kumadula OK.

Njira 3: koperani tebulo ndikusunga kukula kwa mizati

Monga tafotokozera kale, ngati mungakopere ndikuyika tebulo kumalo atsopano (osati mkati mwa mizati yomweyi) mwachizolowezi, ndiye kuti muyenera kusintha kukula kwa mizati, poganizira zomwe zili mu maselo. Koma kuthekera kwa Excel kumakupatsani mwayi woti muzichita nthawi yomweyo ndikusunga miyeso yoyambirira. Umu ndi momwe zimachitikira:

1. Poyamba, sankhani ndikutengera tebulo (timagwiritsa ntchito njira iliyonse yabwino).
2. Mukasankha selo kuti muyike deta, dinani kumanja kwake ndi muzosankha "Special Paste" sankhani chinthu “Sungani m’lifupi mwake”.
3. Kwa ife, tapeza izi (patsamba latsopano).

njira

1. Mu menyu yachidziwitso cha cell, dinani pa lamulo lokha "Special Paste" ndipo pa zenera limene limatsegula, sankhani njira "Column widths".
2. Kukula kwa mizati mu malo osankhidwa kudzasinthidwa kuti igwirizane ndi tebulo loyambirira.
3. Tsopano titha kukopera-kumata tebulo m'derali mwachizolowezi.

Njira 4: Ikani tebulo ngati chithunzi

Ngati mukufuna kumata tebulo lojambulidwa ngati chithunzi chabwinobwino, mutha kuchita izi motere:

1. Tebulo litakopedwa, mumenyu yankhani ya cell yomwe yasankhidwa kuti isungidwe, timayima pa chinthucho "Chithunzi" m'mitundu yosiyanasiyana "Special Paste".
2. Chifukwa chake, tipeza tebulo lobwerezedwa ngati chithunzi, chomwe chitha kusunthidwa, kuzunguliridwa, komanso kusinthidwanso. Koma kusintha deta ndi kusintha maonekedwe awo sikudzagwiranso ntchito.

Njira 5: koperani pepala lonse

Nthawi zina, zingakhale zofunikira kukopera osati chidutswa chimodzi, koma pepala lonse. Za ichi:

1. Sankhani zonse zomwe zili patsambalo podina chizindikirocho pamzere wa mipiringidzo yopingasa ndi yoyima.Kapena mungagwiritse ntchito hotkeys Ctrl+A: kanikizani kamodzi ngati cholozera chili mu cell yopanda kanthu kapena kawiri ngati chinthu chodzazidwa chasankhidwa (kupatula ma cell amodzi, pakadali pano, dinani kumodzi ndikokwanira).
2. Maselo onse pa pepala ayenera kuunikira. Ndipo tsopano akhoza kukopera m'njira iliyonse yabwino.
3. Pitani ku pepala lina / chikalata (pangani chatsopano kapena sinthani ku yomwe ilipo kale). Timadina chizindikirocho pamzere wa ma coordinates, ndikuyika deta, mwachitsanzo, pogwiritsa ntchito njira yachidule ya kiyibodi. Ctrl + V.
4. Zotsatira zake, timapeza pepala lokhala ndi kukula kwa maselo ndi maonekedwe oyambirira osungidwa.

Njira ina

Mutha kukopera pepala mwanjira ina:

1. Dinani kumanja pa pepala dzina pansi pa pulogalamu zenera. Mu menyu yankhani yomwe imatsegulidwa, sankhani chinthucho "Sunthani kapena koperani".
2. Iwindo laling'ono lidzawoneka momwe timakonzekera zomwe zikuyenera kuchitika pa pepala losankhidwa, ndikudina OK:
   • kusuntha / kukopera m'buku lamakono ndi kusankha malo;
   • kusuntha/kukopera ku bukhu latsopano;
   • kuti kukopera kuchitidwe, musaiwale kuyang'ana bokosi pafupi ndi parameter yofananira.
3. Kwa ife, tinasankha pepala latsopano ndikupeza zotsatirazi. Chonde dziwani kuti pamodzi ndi zomwe zili mu pepalalo, dzina lake linakopedwanso (ngati kuli kofunikira, likhoza kusinthidwa - komanso kudzera muzolemba za pepala).

Kutsiliza

Chifukwa chake, Excel imapatsa ogwiritsa ntchito njira zingapo zokopera tebulo, kutengera zomwe kwenikweni (ndi ndendende) akufuna kubwereza zomwezo. Kuthera nthawi yochepa kuphunzira njira zosiyanasiyana zochitira ntchitoyi kungakupulumutseni nthawi yambiri mu pulogalamuyo.