Pogwira ntchito ku Excel, nthawi zina mumatha kukumana ndi kufunika kosinthana. Pali njira zingapo zotsimikiziridwa za izi. Ena mwa iwo amasuntha kwenikweni, pomwe ena amafuna nthawi yayitali kuti achite izi. Tsoka ilo, si onse omwe amagwiritsa ntchito njira zonsezi, chifukwa chake nthawi zambiri amakhala nthawi yambiri pamagwiritsidwe omwe amatha kuchitidwa mwachangu m'njira zina. Tiyeni tiwone zosankha zingapo zakusinthira mizere mu Excel.
Phunziro: Momwe mungasinthire masamba mu Microsoft Mawu
Sinthani mawonekedwe a mizere
Mutha kusinthana mizere ndi njira zingapo. Ena mwa iwo ndi opita patsogolo, koma ma algorithm a ena ndiachilengedwe.
Njira 1: ndondomeko yotsatsira
Njira yodziwikiratu yosinthira mizere ndikupanga mzere wopanda kanthu ndi zomwe wina wawonjezerapo, ndikuchotsa gwero lake. Koma, monga momwe timakhazikitsira pambuyo pake, ngakhale kuti njirayi imadziwunikira yokha, ndiyotali kwambiri osatiothamanga.
- Sankhani khungu lililonse mu mzere, pamwambapa lomwe tikwezani mzere wina. Chitani mbewa kumanja. Menyu yazakudya iyamba. Sankhani zomwe zili mmenemo "Patani ...".
- Pa zenera laling'ono lomwe limatsegulira, lomwe limalimbikitsa kusankha zomwe mungayike, sinthani kusintha kwa udindo "Mzere". Dinani batani "Zabwino".
- Pambuyo pa izi, mzere wopanda kanthu umawonjezeredwa. Tsopano sankhani mzere wa tebulo womwe tikufuna kukweza. Ndipo nthawi ino, muyenera kusankha kwathunthu. Dinani batani Copyili pa tabu "Pofikira" pa lamba wazida Clipboard. M'malo mwake, mutha kujambula kuphatikiza kwa hotkey Ctrl + C.
- Timayika cholozera mu foni yakumanzere kwa mzere wopanda kanthu womwe udawonjezeredwapo poyambilira, ndikudina batani Ikaniili pa tabu "Pofikira" m'magulu azokonda Clipboard. Mwinanso, mutha kuylemba kuphatikiza kiyi Ctrl + V.
- Mzere utayikidwa, kuti mumalize njira yomwe muyenera kuchotsa mzere woyamba. Timadina foni iliyonse yamtunduwu ndi batani la mbewa yoyenera. Pazosankha zomwe zikuwonekera zitatha, sankhani Chotsani ... ".
- Monga momwe mukuwonjezera mzere, zenera laling'ono limatsegulira lomwe limapereka kusankha zomwe zikufunika kuchotsedwa. Timasinthana kusinthaku moyang'ana chinthucho "Mzere". Dinani batani "Zabwino".
Pambuyo pa izi, chinthu chosafunikira chimachotsedwa. Chifukwa chake, kusinthana kwa mzere kudzachitika.
Njira 2: ikani njira
Monga mukuwonera, njira yosinthira zingwe ndi malo m'njira yomwe tafotokozazi ndi yovuta kwambiri. Kukhazikitsa kwake kudzafunika nthawi yayitali. Theka zovuta, ngati mukufuna kusinthana mizere iwiri, koma ngati mukufuna kusinthana mizere ingapo kapena mizere ingapo? Poterepa, njira yosavuta komanso yolumikizira mwachangu ingathandize.
- Dinani kumanzere pa nambala ya mzere pagawo lofananira. Pambuyo pa izi, mzere wonse umatsimikizika. Kenako dinani batani Dulani, yomwe imasanjidwa pachifuwa "Pofikira" mu bokosi la zida Clipboard. Imayimiridwa ndi chithunzi cha lumo.
- Ndikudina batani lakumanja pazogwirizanitsa, sankhani mzere pamwamba womwe mzere womwe udadulidwenso kale. Kupita ku menyu yazonse, siyani kusankha pa chinthucho Patani Maselo.
- Pambuyo pa izi, chingwe chodulidwacho chidzakonzedwanso kumalo omwe adanenedwa.
Monga mukuwonera, njirayi imaphatikizapo kuchita zinthu zochepa kuposa zomwe zidachitika, zomwe zikutanthauza kuti mutha kupulumutsa nthawi ndi thandizo lake.
Njira 3: kusuntha mbewa
Komanso pali njira yofulumira yosuntha kuposa njira yakale. Zimaphatikizapo kukokera ndi kuponyera zingwe pogwiritsa ntchito mbewa ndi kiyibodi, koma osagwiritsa ntchito menyu kapena zida pa riboni.
- Sankhani gawo lomwe lili ndi batani lakumanzere pa tsamba logwirizanitsa lomwe tikufuna kusuntha.
- Timasunthira cholozera mpaka kumtunda kwa mzerewu mpaka chimangidwe cha muvi, kumapeto kwake komwe kuli mizere inayi yolunjikitsidwa mbali zosiyanasiyana. Timagwira batani la Shift pa kiyibodi ndikungokoka mzerewu kupita komwe timafuna kuti ikapezekeko.
Monga mukuwonera, kusunthaku ndikosavuta ndipo mzerewu uli pamalo pomwe wosuta akufuna kuyikapo. Kuti muchite izi, mukungofunika kuchitapo kanthu ndi mbewa.
Pali njira zingapo zosinthira mizere mu Excel. Ndi ziti mwazosankha zomwe zingagwiritse ntchito zomwe zimatengera zomwe munthu angafune. Imodzi ndi yosavuta kwambiri komanso yodziwika bwino munjira yakale yosunthira, kuchititsa kukopa ndikuchotsa mizere, pomwe ena amakonda njira zapamwamba kwambiri. Aliyense amasankha yekha zomwe akufuna, koma, titha kunena kuti njira yachangu kwambiri yosinthira mizere ndi njira yosakira ndi mbewa.
