Momwe Mungachotsere Mafayilo Abwino

Anonim

Kuchotsa Microsoft Excel

Mafayilo okhala ndi minda yomwe ili kumtunda ndi m'munsi mwa pepala labwino. Amalemba zolemba ndi zina mwanzeru za wogwiritsa ntchito. Nthawi yomweyo, zolembedwazo zidzachitika, ndiko kuti, pakujambulira patsamba limodzi, liwonetsedwa patsamba lina la chikalatacho pamalo omwewo. Koma, nthawi zina ogwiritsa ntchito amapezeka ndi vutoli pomwe sangathe kuletsa kapena kuchotsa zonse zotsikirako. Makamaka nthawi zambiri zimachitika ngati aphatikizidwa molakwitsa. Tiyeni tiwone momwe mungachichotsere mamita.

Njira Zochotsera Ovesi

Pali njira zingapo zochotsera othandizira. Amatha kugawidwa m'magulu awiri: kubisalira mapazi ndi kuchotsa kwathunthu.

Woyenda mu Microsoft Excel

Njira 1: Kubisala Malire

Mukamabisala mafayilo ndi zomwe zili muzolemba, kwezani chikalatacho, koma sichikuwoneka kuchokera ku Screen. Nthawi zonse pamakhala mwayi wawo kuti awathandize ngati pangafunike.

Pofuna kubisa mafayilo, ndikokwanira bar kuti musinthe bwino kuchokera kuntchito mumayendedwe munthawi iliyonse. Kuti muchite izi, dinani chithunzi mu bar "yabwinobwino" kapena "Tsamba".

Kubisa zotsikira ku Microsoft Excel

Pambuyo pake, omaliza zibisika.

Wopumira amabisika mu Microsoft Excel

Njira 2: Kuchotsa kwamanja

Monga tafotokozera pamwambapa, mukamagwiritsa ntchito njira yapita, mamita atatu samachotsedwa, koma kungobisika. Pofuna kuchotsedwa kwathunthu ndi zolemba ndi zolemba zonse zomwe zilipo, muyenera kuchita zina m'njira ina.

  1. Pitani ku "kuyika" tabu.
  2. Kusintha ku Inc Towak ku Microsoft Excel

  3. Dinani pa batani la "wopatsa", lomwe limapezeka pa tepi mu chipangizo cha malembawo.
  4. Kusamukira kumayendedwe aku Microsoft Excel

  5. Chotsani zolemba zonse m'mapazi chilichonse cholembera pamanja pogwiritsa ntchito batani la Chotsani pa kiyibodi.
  6. Kuchotsa Microsoft Excel

  7. Pambuyo pa zonsezi zimachotsedwa, zimitsani chiwonetsero chamutu musanafotokozedwe.

Tsimikizirani oyenda mu Microsoft Excel

Tiyenera kudziwa kuti zolemba zimatsukidwa mwanjira iyi m'matumbo omwe amachotsedwa kwanthawi zonse, ndikungoyatsa chiwonetsero chawo sichingagwire ntchito. Ndikofunikira kukonzanso mbiri.

Njira 3: Kuchotsa Kokha kwa Otsitsimutsa

Ngati chikalatacho ndichochepa, njira yomwe yafotokozedwa pamwambapa yochotserani utsi sutenga nthawi yayitali. Koma choti ndichite ngati Bukuli lili ndi masamba ambiri, chifukwa pankhaniyi, ngakhale wotchi yonse ikhoza kukhala oyera? Pankhaniyi, zimamveka kugwiritsa ntchito njira yomwe ingachotsere mapazi mogwirizana ndi zomwe zili pa ma sheet onse.

  1. Tikuwonetsa masamba omwe mukufuna kuchotsa mapazi. Kenako, pitani ku tabu ya "chizindikiro".
  2. Pamwamba pa TOP TAB mu Microsoft Excel

  3. Pa tepiyo mu "masamba a masamba" podina chithunzi chaching'ono ngati muvi wopondera womwe ulipo pakona yakumanja ya bwaloli.
  4. Sinthani ku makonda a Tsamba mu Microsoft Excel

  5. Pazenera lomwe limatseguka, pitani ku tabu ya "Hyy".
  6. Kusintha kwa mutu wa mutu ku Microsoft Excel

  7. Pa "chapamwamba" ndi "othamanga", amatcha mndandanda wazopita. Pa mndandanda, sankhani chinthucho "(Ayi)". Dinani pa batani la "OK".

Kuchotsa mapazi kudutsa ma paraset pa Microsoft Excel

Monga tikuwonera, zitachitika izi, malembedwe onse mu masamba osankhidwa apangidwe adatsukidwa. Tsopano, ngati nthawi yotsiriza kudutsa chithunzi pa bar, muyenera kuyimitsa mutu.

Kutembenuza kictor store mu Microsoft Excel

Tsopano zotsirizizo zimachotsedwa kwathunthu, ndiye kuti, sizingowonetsedwa pazenera, komanso kutsukidwa kuchokera ku kukumbukira kwa fayilo.

Monga mukuwonera, ngati mukudziwa zovuta zina zogwira ntchito ndi pulogalamu ya Excel, kuchotsedwa kwa makalasi ochokera nthawi yayitali komanso osakhalitsa kumatha kukhala njira yofulumira. Komabe, ngati chikalatacho chili ndi masamba angapo angapo, mutha kugwiritsa ntchito kuchotsedwa pamanja. Chinthu chachikulu ndikusankha zomwe mukufuna kuchita: chotsani kwathunthu mamita kapena kungowabisalira kwakanthawi.

Werengani zambiri