Momwe mungapangire malowa

Mukamagwira ntchito ndi chiwerengero chachikulu cha data pa pepala la ma prophegesheet, muyenera kuyang'ana magawo ena pafupipafupi. Koma ngati pali ambiri a iwo, ndipo dera lawo limapitilira malire a chinsalu chophimba, isuntha nthawi zonse bala ndi lovuta. Excel opanga amangosamala kuti ogwiritsa ntchito agwiritse ntchito, kuwonetsa pulogalamuyi kuthekera kwa malo ophatikizira. Tiyeni tiwone momwe izi zimachitikira komanso momwe mungagwiritsire ntchito pulogalamu ya microsoft.

Kumangirira malowa

Njira yothetsera ntchito yathu ya lero idzawonetsedwa pa chitsanzo cha pulogalamu ya Exrosoft Office 365 Phukusi la Pakhumi 365 kapena lochulukirapo (2019), njira zopangira Mwanjira.

Njira 1: Dera la zingwe

Nthawi zambiri mu tebulo labwino kwambiri, ndikofunikira kukonza malowa kuchokera kumizere ingapo, yomwe ndi yotchedwa kapu. Izi zimachitika motere:

Kuyang'ana pa nambala ya mzere kumbali (kumanzere) pulogalamuyi, sankhani batani lakumanzere ndikukakamiza batani la mbewa (LKM) malingana ndi mzere, zomwe zingakhale zotsatirazi pazotsatira. Mwachitsanzo, timangira mizere itatu yoyambayo, ndiye kuti, ndikofunikira kugawana izi wachinayi.

Kusankha mzere pansi kuti muteteze malowa mu tebulo la Microsoft Excel

Pitani ku "Onani" tabu ndi "zenera" chida, chowonjezera mndandanda wa "malo otetezeka".

Kusintha kupita ku Kuphatikiza pa malo oyambira mu tebulo la Microsoft

M'ndandanda wowonetsera zomwe zilipo, sankhani njira yokhayo yoyenera pa zolinga zathu - "Valani malo".

Tengani malowa kuchokera kumizere mu tebulo la Microsoft Excel

Umu ndi momwe mungasinthire malo oyimirira okhazikika pamizere ingapo, mu tebulo lamagetsi.

Chitsanzo cha gawo lopambana la mizere mu tebulo la Microsoft Excel

Njira 2: Dera la Mizamu

Zimachitikanso kuti ndikofunikira kumangiriza pamwamba pa tebulo, koma mbaliyo, ndiye kuti, mizati yomwe ili kumanzere. Algorith machitidwe pankhaniyi ndi ofanana, koma ndi kusintha kwakanthawi.

Unikani mzere womwe ukutsatira mtundu wa omwe mukufuna kukonza. Mwathu, mzati wa C ali, ndiye kuti, tidzakonza mtundu A-B.

Kusankhidwa kwa mzere kutsatila mtunduwo kuti muteteze patebulo la Microsoft Excel

Tsegulani tabu yowonetsera ndikugwiritsa ntchito "malo otetezeka".

Pitani ku malo otetezedwa kuchokera ku mitu ya microsoft Excel

Sankhani njira yoyamba kuchokera pamndandanda womwe umabwereza dzina la chinthu chachikuluchi ndipo tatchulidwa kale m'gawo lapitalo.

Sungani dera la Column mu tebulo la Microsoft Excel

Kuyambira nthawi imeneyi, dera lomwe linatchulidwa (kumanzere) lidzakonzedwa, ndipo polowerera patebulopo pamalo opingasa, nthawi zonse zimakhala pamalo ake.

Zotsatira za Kukhazikika Kwamitundu ya Microsoft Chuma Chachikulu

Njira 3: dera la mizere ndi mizati

Kutengera mfundo yomwe ili m'maselo, omwe nthawi zambiri amafunikira kuti azikhala pamaso pa maso, akhoza kupezeka konsekonse m'mizere ndi mizere yake, sizodabwitsa kuti chida chambiri, chomwe chimakupatsani mwayi woyamba ndi wachiwiri. Za ichi:

Unikani mwa kukanikiza LCM kuti ili pansi pa mizere ndi kumanja kwa mizamu yomwe mukufuna kukonza, kenako ndikupita ku "Onani" tabu.

Chitsanzo: Pofuna kukonza mizere iwiri yoyamba (12) ndi mzere (A, b) , Sankhani foni yomwe ili ndi adilesi C3.
.
Pamunda wa "Window" Zida, Gwiritsani ntchito chinthucho "valani malo"

Ndipo mndandanda womwe umatsegula, sankhani njira yomweyo.

Kuthamanga kuderalo kwa mizere ndi mizere mu tebulo la Microsoft Excel

Tsopano, ndi kupukutira kokhazikika kwa tebulo, mizere yokhazikika ikhalabe m'malo mwake

Ndipo ndi mizati yokhazikika yokhazikika.

Dera la mizamu limakhazikika mu tebulo la Microsoft Excel

Mtundu wazomwe zachitika mu gawo ili ndi tanthauzo lenileni la mawu oti "kuphatikiza m'deralo". Pangani malo okhazikika pamizere ndi mizati ingafunikire pamene gawo lapamwamba la chipewa ndi chipewa, ndipo kumbali ili ndi ziwerengero zotsatizana ndi dzina lonse la ogwira ntchito.

Dera la mizere ndi mizere imatsekeka mu tebulo la Microsoft Excel

Njira 4: Mzere umodzi kapena mzere umodzi

Ngati mutaphatikizana ndi derali, mumatanthawuza kusintha kwa gawo limodzi la tebulo, ndiye kuti, mzere wake kapena mzati umodzi, zonse zimachitika mosavuta. Mumangoyang'ana gawo lomwe mukufuna, kenako sankhani chinthu chomwe chikufanana ndi ntchito yanu mu batani "lotetezeka". Kapenanso, simunganene chilichonse pa zonse, ndipo nthawi yomweyo musankhe imodzi mwazosankha - "khazikitsani chingwe chokwanira" kapena "khazikitsani gawo loyamba", kutengera ntchito yomwe ili patsogolo panu. Ndondomeko iyi, komanso nyuzizo zomwe zingatanthauze kukhazikitsa kwathu, zimaganiziridwa ndi ife m'malemba osiyana, ndipo timalimbikitsa kuwonetsa.

Kukonza mzere umodzi kapena mzere umodzi mu tebulo la Microsoft Excel

Werengani zambiri: Momwe mungasungire mzere umodzi kapena mzere umodzi

Kutaya malo omwe ali m'ndende

Pakachitika kuti kufunikira kogwirizanitsa malowo (zingwe, mizati kapena mtundu wosakanikirana ndi ngakhale) zilibe kanthu) zikufunika kutero, ndikofunikira kutero, monga momwe zinkalongosoledwa pamwambapa. Kusiyana kokha ndikuti "kukonza" kuyenera kusankha chinthu choyamba komanso chodziwikiratu pamene "chotsani zigawo zija".

Chotsani ma rights ndi zigawo mu tebulo la Microsoft Excel

Mapeto

Swit zingwe, zigawo kapena kukulitsa mitundu yawo mu Microsoft Centersel ndizosavuta. Chinthu chachikulu pankhaniyi weretsani kuti ndi ziti mwa tebulo ziyenera kugawidwa, ndipo tidanena mwatsatanetsatane m'nkhani ya lero.