Chotsani kachitidwe mu Microsoft Excel

Kugwira ntchito ndi ma formula ku Excel kumakupatsani mwayi wambiri wosavuta komanso kusinthira mawerengeredwe osiyanasiyana. Komabe, sizofunikira nthawi zonse kuti zotsatira zake zikhale zolumikizidwa. Mwachitsanzo, posintha ma cell omwe ali olumikizidwa, zomwe zimachitika ndizosinthanso, ndipo nthawi zina izi sizofunikira. Kuphatikiza apo, mukasinthana ndi tebulo lomwe mwakopera ndi mawonekedwe amalo lina, zomwe zimayikidwa zimatha "kutayika". Chifukwa china chobisira iwo akhoza kukhala pomwe simukufuna kuti anthu ena awone momwe kuwerengera kumachitikira. Tiyeni tiwone momwe mungachotsere formula muma cell, kungosiyira zotsatira za kuwerengera.

Kuchotsa

Tsoka ilo, Excel ilibe chida chomwe chimachotsa ma formula nthawi yomweyo m'maselo, ndipo chimangosiya zofunikira pamenepo. Chifukwa chake, tiyenera kuyang'ana njira zovuta kwambiri zothetsera vutoli.

Njira 1: kukopera zofunikira kudzera pakanema

Mutha kukopera deta popanda fomula kupita kudera lina pogwiritsa ntchito njira zamtunduwu.

1. Sankhani tebulo kapena mulingo, womwe timazunguliza ndi cholozera pomwe tili ndi batani lakumanzere. Kukhala mu tabu "Pofikira"dinani pachizindikiro Copy, yomwe imayikidwa pa tepi mu chipika Clipboard.



2. Sankhani khungu lomwe lidzakhale cell yakumanzere kwa thebulo. Dinani pa icho ndi batani la mbewa yoyenera. Zosintha zamakina zidzakonzedwa. Mu block Ikani Zosankha siyani kusankha pa "Makhalidwe". Imawonetsedwa ngati chithunzi ndi manambala "123".

Mukamaliza njirayi, malowa adzaikidwa, koma amtengo opanda mawonekedwe. Zowona, zojambula zoyambirira zidzatayika. Chifukwa chake, muyenera kupanga patebulo pamanja.

Njira 2: koperani ndi phala yapadera

Ngati mukufunikira kuyika zolemba zoyambirira, koma simukufuna kutaya nthawi pokonza tebulo, ndiye kuti pali mwayi wogwiritsa "Lowetsani mwapadera".

1. Koperani chimodzimodzi monga nthawi yomaliza zomwe zili patebulo kapena mtundu.
2. Sankhani malo onse oyikapo kapena khungu lanu lakumanzere. Timadina molondola, potipangitsa kusinthitsa mitu yankhani yonse. Pamndandanda womwe umatsegulira, sankhani "Lowetsani mwapadera". Chotsatira, pazowonjezera, dinani batani "Zotsatira zamtundu woyambira"lomwe limayikidwa mgulu Ikani Mfundo ndipo ndichizindikiro chachikulu ndi manambala ndi burashi.

Pambuyo pa opaleshoniyo, zomwe zatsimikizidwazo zitha kukopedwa popanda njira, koma mitundu yoyambirira idzasungidwa.

Njira 3: chotsani zojambulazo patsamba lochokera

Izi zisanachitike, tinakambirana za momwe mungachotsere formula mukamakopera, tsopano tiyeni tiwone momwe tingachichotsere pamtundu woyambira.

1. Timatsitsa tebulo pogwiritsa ntchito njira zomwe tafotokozazi pamwambapa. Kusankha njira mwatokha sizitanthauza.
2. Sankhani malo omwe mwatengera. Dinani batani Copy pa tepi.



3. Sankhani mtundu woyamba. Timadulira pomwepo ndi batani la mbewa. Pamndandanda wazomwe zili mgululi Ikani Zosankha sankhani "Makhalidwe".



4. Pambuyo poti yaikapo, mutha kufufuta mayendedwe ake. Sankhani. Timayitanitsa menyu wanthawi yonse ndikudina batani lakumanja. Sankhani zomwe zili mmenemo Chotsani ... ".



5. Iwindo laling'ono limatseguka pomwe muyenera kukhazikitsa zomwe zimayenera kuchotsedwa. M'nthawi yathu ino, magawo omwe amapezeka ali pansi pa gome la magwero, chifukwa chake tiyenera kuchotsa mizere. Koma ngati inali pambali pake, ndiye kuti mizati ichotsedwe, ndikofunikira kuti musazisakanikize, popeza tebulo lalikulu lingawonongeke. Chifukwa chake, timakhazikitsa zochotsa ndikudina batani "Zabwino".

Pambuyo pochita izi, zinthu zonse zosafunikira zimachotsedwa, ndipo mawonekedwe kuchokera pagome loyambirira adzazimiririka.

Njira 4: chotsani njira popanda kupanga mayendedwe

Mutha kuzipangitsa kukhala zosavuta koma osapanga mayendedwe konse. Zowona, pankhaniyi, muyenera kuchitapo kanthu mosamala, chifukwa zochita zonse zidzachitidwa mkati mwa tebulo, zomwe zikutanthauza kuti cholakwika chilichonse chingaphwanye umphumphu wa data.

1. Sankhani mtundu womwe mukufuna kuti mufafanize mitundu. Dinani batani Copykuyikidwa pa riboni kapena kuyika kuphatikiza mafungulo pa kiyibodi Ctrl + C. Machitidwe awa ndi ofanana.



2. Kenako, osachotsa masankhidwewo, dinani kumanja. Zosintha zamakambirano zayambitsidwa. Mu block Ikani Zosankha dinani pachizindikiro "Makhalidwe".

Chifukwa chake, deta yonse idzajambulidwa ndi kuthandizidwa mwachangu ngati mfundo. Pambuyo pa izi, mawonekedwe mu malo osankhidwa sangakhalebe.

Njira 5: gwiritsani ntchito zazikulu

Muthanso kugwiritsa ntchito ma macros pochotsera njira m'maselo. Koma pa izi muyenera kuyambitsa batani loyambitsira, ndikuwathandizanso ma macro enieni ngati osagwira. Momwe mungachitire izi mutha kupezeka mumutu wina. Tilankhula mwachindunji za kuwonjezera ndi kugwiritsa ntchito zazikuluzikulu kuti tichotse njira.

1. Pitani ku tabu "Wopanga". Dinani batani "Zowoneka Zachikulu"yokhala pa riboni m'bokosi la chida "Code".



2. Kuwongolera kwa macro kumayamba. Ikani khodi ili m'munsiyi:

   
Chotsani Fomula Yoyimira ()
Kusankha.Value = Selection.Value
Mapeto sub

   Pambuyo pake, tsekani mawonekedwe a mkonzi m'njira yofananira podina batani pakona yakumanja yakumanja.



3. Timabwereranso ku pepala lokhala ndi tebulo lokondwererali. Sankhani kachidutswa komwe njira zomwe zimachotsedwa zimapezeka. Pa tabu "Wopanga" dinani batani Macroskuyikidwa pa tepi mgulu "Code".



4. Windo lotsegulira la macro likutseguka. Tikuyang'ana chinthu chomwe chimatchedwa Kuchotsera Kwamtundu, sankhani ndikudina batani Thamanga.

Pambuyo pa izi, mitundu yonse yomwe yasankhidwa idzachotsedwa, ndipo mawerengero okha ndi omwe angatsalire.

Phunziro: Momwe mungathandizire kapena kuletsa macros ku Excel

Phunziro: Momwe mungapangire zazikulu mu Excel

Njira 6: Chotsani njira iyi ndi zotsatira zake

Komabe, pali nthawi zina pamene muyenera kuchotsa osati fomula yokha, komanso zotsatira zake. Khalani osavuta.

1. Sankhani malo omwe mafomulowo aikidwapo. Dinani kumanja. Pazosankha, siyani kusankha pazomwe zili Chotsani Zolemba. Ngati simukufuna kuyitanitsa menyu, mutha kungodinikiza fungulo mutasankha Chotsani pa kiyibodi.



2. Pambuyo pa izi, zonse zomwe zili m'maselo, kuphatikizapo mawonekedwe ndi mfundo, zidzachotsedwa.

Monga mukuwonera, pali njira zingapo zomwe mungachotsere mitundu yonse, mukamakopera deta, komanso mwachindunji patebulo lenilenilo. Zowona, chida chokhazikika cha Excel, chomwe chimangochotsa mawuwo mwachidule chimodzi, mwatsoka, chilibe. Mwanjira imeneyi, mutha kungochotsa ma formula limodzi ndi mfundo zake. Chifukwa chake, muyenera kuchitapo kanthu pochita zina ndi zina kapena kugwiritsa ntchito ma macros.