Microsoft Excel ndi chida champhamvu chokhala ndi magwiridwe antchito olemera, chomwe chili choyenera kuchita zinthu zosiyanasiyana ndi data yoperekedwa mu mawonekedwe a tabular. Mu Mawu, mutha kupanganso matebulo ndikugwira nawo ntchito, komabe, iyi si pulogalamu yambiri pankhaniyi, chifukwa idapangidwira ntchito ndi zolinga zina.
Koma nthawi zina wogwiritsa ntchito amayang'anizana ndi ntchito ya momwe angasamutsire tebulo lopangidwa mu Excel kukhala mkonzi wamawu. Ndipo si aliyense amene akudziwa momwe angachitire bwino. M'nkhaniyi, tisanthula mwatsatanetsatane njira zonse zomwe zilipo zosinthira tebulo kuchokera pa spreadsheet editor kupita ku text editor.
Zamkatimu: "Momwe mungasamutsire tebulo kuchokera ku Excel kupita ku Mawu"
Koperani nthawi zonse patebulo
Iyi ndi njira yosavuta yomaliza ntchitoyi. Kusamutsa kuchokera mkonzi wina kupita ku wina, mutha kungoyika zomwe mwakoperazo. Tiyeni tiwone momwe tingachitire.
- Choyamba, tsegulani fayiloyo ndi tebulo lomwe mukufuna ku Excel.
- Kenako, sankhani ndi mbewa tebulo (zonse kapena gawo lina lake) zomwe mukufuna kusamutsa ku Mawu.
- Pambuyo pake, dinani kumanja kulikonse komwe mwasankha ndikusankha "Koperani" kuchokera kumenyu yankhani. Mutha kugwiritsanso ntchito njira yachidule ya kiyibodi Ctrl + C (Cmd + C ya macOS).
- Zomwe mukufuna zitakopera pa clipboard, tsegulani Mawu omasulira.
- Pangani chikalata chatsopano kapena tsegulani chomwe chilipo kale.
- Ikani cholozera pomwe mukufuna kuyika chizindikirocho.
- Dinani kumanja pa malo osankhidwa ndikusankha "Matani" kuchokera pamenyu. Mutha kugwiritsanso ntchito njira yachidule ya kiyibodi Ctrl+V (Cmd+V ya macOS).
- Chirichonse chakonzeka, tebulo layikidwa mu Mawu. Samalani m'mphepete mwake m'munsi kumanja.
- Kudina chizindikiro chikwatu chikwatu kudzatsegula mndandanda wokhala ndi zosankha. Kwa ife, tiyeni tiyang'ane pa mapangidwe oyambirira. Komabe, mulinso ndi mwayi woyika deta ngati chithunzi, zolemba, kapena kugwiritsa ntchito kalembedwe ka tebulo lomwe mukufuna.
Zindikirani: Njirayi ili ndi vuto lalikulu. Kuchuluka kwa pepala kumakhala kochepa muzolemba zolemba, koma osati mu Excel. Choncho, tebulo liyenera kukhala lalikulu m'lifupi, makamaka lokhala ndi mizati ingapo, osati lalikulu kwambiri. Kupanda kutero, gawo la tebulo silingafanane ndi pepalalo ndipo lipitilira chikalatacho.
Koma, ndithudi, munthu sayenera kuiwala za mfundo yabwino, mwachitsanzo, kuthamanga kwa ntchito ya copy-paste.
Matani apadera
- Chinthu choyamba ndikuchita chimodzimodzi monga momwe tafotokozera pamwambapa, mwachitsanzo, kutsegula ndi kukopera kuchokera ku Excel kupita pa bolodi lojambula tebulo kapena gawo lake.
- Kenako, pitani ku cholembera ndikuyika cholozera pamalo oyika patebulo.
- Kenako dinani kumanja ndi kusankha "Special kubetcha ..." pa menyu.
- Zotsatira zake, zenera lomwe lili ndi zoikamo za zosankha za phala liyenera kuwoneka. Sankhani chinthucho "Ikani", ndipo kuchokera pamndandanda womwe uli pansipa - "Microsoft Excel Sheet (chinthu)". Tsimikizirani kuyikapo podina batani "Chabwino".
- Zotsatira zake, tebulo limasinthidwa kukhala chithunzi chazithunzi ndikuwonetsedwa mu mkonzi wa zolemba. Panthawi imodzimodziyo, tsopano, ngati sichikukwanira pa pepala, miyeso yake imatha kusinthidwa mosavuta, monga pogwira ntchito ndi zojambula, kukoka mafelemu.
- Komanso, podina kawiri patebulo, mutha kuyitsegula mumtundu wa Excel kuti musinthe. Koma zosintha zonse zitapangidwa, mawonedwe a tebulo amatha kutsekedwa ndipo zosintha zidzawonetsedwa nthawi yomweyo mumkonzi walemba.
Kuyika tebulo kuchokera mufayilo
Munjira ziwiri zam'mbuyomu, gawo loyamba linali kutsegula ndi kukopera spreadsheet kuchokera ku Excel. Mwanjira iyi, izi sizofunikira, kotero timatsegula nthawi yomweyo mkonzi wa zolemba.
- Pamwambamwamba, pitani ku tabu "Insert". Chotsatira - mu chipika cha zida "Text" ndi mndandanda womwe umatsegulidwa, dinani chinthucho "Chinthu".
- Pazenera lomwe likuwoneka, dinani "Kuchokera ku fayilo", sankhani fayilo yomwe ili ndi tebulo, kenako dinani "Ikani".
- Gome lidzasamutsidwa ngati chithunzi, monga mu njira yachiwiri yomwe tafotokozayi. Chifukwa chake, mutha kusintha kukula kwake, komanso kuwongolera deta ndikudina kawiri patebulo.
- Monga momwe mwawonera kale, sikuti gawo lodzaza patebulo limayikidwa, komanso zonse zomwe zili mufayiloyo. Chifukwa chake, musanayambe kuyikapo, chotsani chilichonse chosafunikira.
Kutsiliza
Chifukwa chake, mwaphunzira kusamutsa tebulo kuchokera ku Excel kupita ku Word text editor m'njira zingapo. Kutengera ndi njira yosankhidwa, zotsatira zomwe zapezedwa zimasiyananso. Choncho, musanasankhe njira yeniyeni, ganizirani zomwe mukufuna kupeza pamapeto pake.