Sungani mizere ku Microsoft Excel

Kugwira ntchito ku Excel, nthawi zina mungakumane ndi kufunikira kusinthana mizere m'malo. Pali njira zambiri zotsimikiziridwa za izi. Ena a iwo amayendetsa kayendetsedwe kake pamakani angapo, pamene ena amafunikira nthawi yochuluka ya njirayi. Tsoka ilo, si ogwiritsira ntchito onse omwe amadziwa zonsezi, choncho nthawi zina amathera nthawi yochuluka pa njira zomwe zikhoza kuchitidwa mofulumira kwambiri m'njira zina. Tiyeni tiwone njira zosiyanasiyana zowasinthira mizere ku Excel.

Phunziro: Momwe mungasinthire masamba mu Microsoft Word

Sinthani malo a mizere

Sinthani mizere ndi njira zingapo. Zina mwazo zimapitabe patsogolo, koma zowonjezereka za ena zimakhala zosavuta.

Njira 1: Konzani Ndondomeko

Njira yabwino kwambiri yosinthanitsa mizere ndiyo kupanga mzere watsopano popanda kuwonjezera zomwe zilipo, kenako kuchotsa chitsimezo. Koma, monga momwe tidzakhazikitsira patapita nthawi, ngakhale kuti njirayi idziwonetsera yokha, sikuti imakhala yofulumira kwambiri ndipo si yosavuta.

1. Sankhani selo lirilonse mu mzere, mwachindunji pamwamba pa zomwe tidzatenga mzere wina. Pangani chodindira. Menyu yotsatira ikuyambira. Sankhani chinthu mmenemo "Sakani ...".



2. Muwindo laling'ono lotseguka, lomwe limapereka kusankha chomwe chingaikidwe, sungani makinawo ku malo "Mzere". Dinani pa batani "Chabwino".



3. Pambuyo pazimenezi, mzere wopanda kanthu wawonjezedwa. Tsopano sankhani tebulo la mzere limene tikukhumba kuti tilitse. Ndipo nthawi ino ikuyenera kupatsidwa kwathunthu. Timakanikiza batani "Kopani"tabu "Kunyumba" pa tepi yothandizira "Zokongoletsera". M'malo mwake, mukhoza kulemba makina otentha Ctrl + C.



4. Ikani cholozera mu selo lakumanzere la mzera wopanda kanthu umene unayikidwa poyamba, ndipo dinani pa batani Sakanizanitabu "Kunyumba" mu gulu la zosankha "Zokongoletsera". Mwinanso, n'kotheka kufanizitsa kuphatikiza kwachinsinsi Ctrl + V.



5. Mzerewu utalowa, muyenera kuchotsa mzere woyamba kuti mutsirize. Dinani pa selo iliyonse ya mzerewu ndi batani lamanja la mouse. Mu menyu omwe akuwonekera pambuyo pa izi, sankhani chinthucho "Chotsani ...".



6. Monga momwe mukuonjezera mzere, mawindo ang'onoang'ono amatsegula zomwe zimakuchititsani kusankha zomwe mukufuna kuchotsa. Yambitsaninso kusinthana pa malo osiyana ndi chinthucho "Mzere". Timakanikiza batani "Chabwino".

Pambuyo pazitsulo izi, chinthu chosafunikira chidzachotsedwa. Choncho, kuloledwa kwa mizere kudzachitika.

Njira 2: ndondomeko yolowera

Monga momwe mukuonera, ndondomeko yothetsera zida ndi malo monga momwe tafotokozera pamwambapa ndi zovuta. Kukhazikitsidwa kwake kudzafuna nthawi yochuluka kwambiri. Gawo la vuto ngati mukusowa kusintha mizere iwiri, koma ngati mukufuna kusinthitsa khumi ndi awiri kapena mizere yambiri? Pachifukwa ichi, njira yosavuta ndi yofulumira kuika idzathandiza.

1. Dinani kumanzere pa nambala ya mndandanda pazowunikira zowonongeka. Pambuyo pachithunzi ichi, mndandanda wonse umatsindikizidwa. Kenaka dinani pa batani. "Dulani"yomwe ili m'banjamo mu tab "Kunyumba" mu chigawo cha zipangizo "Zokongoletsera". Imayimiridwa ndi pictogram ngati mawonekedwe.



2. Pogwiritsa ntchito botani lamanja la mbewa pamphaneli wotsogolera, sankhani mzere umene uli pamwambapa umene tiyenera kuika mzere wolembawo. Kupita ku menyu yachidule, lekani kusankha pa chinthucho "Yesani Maselo Odulidwa".



3. Pambuyo pazochitikazi, mzere wodulidwa udzasinthidwanso ku malo omwe atchulidwa.

Monga momwe mukuonera, njirayi ikuphatikizapo kuchita zochepa kuposa kale, zomwe zikutanthauza kuti mungathe kusunga nthawi.

Njira 3: kusuntha mbewa

Koma pali njira yosunthira mofulumira kuposa njira yapitayi. Zimaphatikizapo kukokera mizere pogwiritsa ntchito mbewa ndi kibokosi, koma popanda kugwiritsa ntchito mndandanda wamakono kapena zipangizo pa riboni.

1. Sankhani mwadinda batani lamanzere la segololo pambali pazowonjezera mzere umene tikufuna kusunthira.



2. Sungani chithunzithunzi ku malire apamwamba a mzerewu mpaka mutengere mawonekedwe a muvi, pamapeto pake omwe muli ndondomeko zinayi zoyendetsedwa m'njira zosiyanasiyana. Timagwiritsa ntchito batani la Shift pa kibokosiko ndikungoyendetsa mzere kumalo kumene tikufuna kuti tipezeke.

Monga momwe mukuonera, kayendetsedweko ndi kosavuta ndipo mzere umakhala pomwe mwini wogwiritsa ntchito. Kuti muchite izi, muyenera kungochitapo kanthu ndi mbewa.

Pali njira zambiri zosinthira zingwe mu Excel. Zomwe mwasankha zomwe mungagwiritse ntchito zimadalira malingaliro anu omwe akugwiritsa ntchito. Imodzi ndi yabwino komanso yodziwika bwino kachitidwe kakale kuti kayendetsedwe kayendetsedwe kachitidwe, kachitidwe ka kukopera ndi kuchotsa mizere, pamene ena amasankha njira zowonjezera. Aliyense amasankha yekha kusankha yekha, koma, ndithudi, tinganene kuti njira yofulumira yosinthanitsa mizere ndi mwayi wodula kwambiri ndi mbewa.