Mukamaliza kukonza bukhuli, mutha kuyika zoletsa zowerengera zokha ndipo aliyense amene mumagawana naye azitha kuliwerenga, koma sangathe kusintha chikalatacho mwanjira iliyonse. Komabe, kugwiritsa ntchito kuwerenga kokha kungakhale cholepheretsa pamene mukufunikiradi kusintha chikalatacho. Mwina mnzanu kapena mnzanu adagawana nanu buku lowerengera lokha la Excel ndikuyiwala kugawana nanu momwe mungachotsere lamuloli.
Excel ikhoza kukhazikitsidwa kuti iwerenge-pokha ndi zosankha zingapo. M'nkhaniyi, tikulemba zochitika zonse zomwe zingatheke ndi zothetsera zokhudzana nazo kuti mudziwe momwe mungachotsere kuwerenga kuchokera ku Excel muzochitika zingapo.
Excel imapangidwa kuwerengera kokha pogwiritsa ntchito "Mark ngati Final"
Chimodzi mwazifukwa zomwe chikalata cha Excel chomwe muli nacho chimangowerengedwa chokha ndichakuti chidalembedwa chomaliza ndi mkonzi. Ngati ndi choncho, muyenera kuwona uthenga pamwamba pa chikalatacho kuti "Zolembedwa ngati zomaliza."
Chikalatacho chikalembedwa chomaliza, sikudzakhala kotheka kusintha. Simungathe kulemba, kusintha kapena kuyesa chikalatachi m'derali. Koma ndizosavuta kuchotsa. Ingodinani batani la "Sinthani mulimonse" kumapeto kwa uthengawo ndipo mutha kuzimitsa zowerengera zokha mu Excel.
Fayilo ya Excel imakhala fayilo yowerengera yokha yomwe imalimbikitsidwa ndi "Save As"
Chinthu chinanso chodziwa kuti chikalata cha Excel chili mumayendedwe owerengera okha ndikuti mudzapemphedwa kuti mutsegule chikalatacho mwanjira yowerengera pokhapokha mutafunika kusintha. Ngati simukufuna kusintha chikalatacho, dinani "Inde". Ndipo ngati mukufuna kusintha chikalatacho, dinani "Ayi" kuti mutsegule.
Ngati mukufuna kutsegula fayilo ya Excel yowerengera, tsatirani izi:
Gawo 1: Mukatsegula chikalata cha Excel koyamba ndikulandila uthenga womwe ukukupatsani njira zitatu kuti mutsegule chikalatacho kuti muwerenge kokha, ingodinani "Inde" kuti mutsegule fayiloyo powerenga pokha.
Gawo 2: Ngati musintha zomwe zili m'chikalatacho ndikuyesa kusunga zosinthazo, uthenga watsopano umawonekera ndikukupemphani kuti musunge fayiloyo ndikuyitchanso. Dinani "Chabwino" kuti mutsegule bokosi la "Save As", kenako dinani "Zida > Zosankha Zonse."
Gawo 3: M'bokosi la "General Options" lomwe likuwonekera, sankhani njira ya "Kuwerenga Kovomerezeka" ndikudina "Chabwino."
Gawo 4: Kubwerera mu bokosi la "Save As", dinani "Sungani." Izi zipanga kopi ya fayilo yoyambirira ya Excel. Fayilo yomwe yakopedwa siingowerengedwa kokha ndipo mutha kupitiriza kuyisintha momwe mukufunira.
Izi zidzachotsa zoletsa zowerengera zokha kuchokera pa chikalata cha Excel.
Mapangidwe a mapepala a Excel ndi mabuku ogwirira ntchito amatsekedwa ndikuwerengedwa kokha
Ngati fayilo ya Excel ili mumayendedwe owerengera okha chifukwa tsamba logwirira ntchito kapena buku lantchito latsekedwa, mutha kuchotsa choletsa chowerengera chokhacho mu Excel ngati mukudziwa mawu achinsinsi. Umu ndi momwe mumachitira:
Gawo 1: Tsegulani fayilo yotetezedwa ya Excel, kuti muwone mapepala onse ndi zomwe zili.
Gawo 2: Dinani "Review" mu menyu yayikulu ndikusankha "Unprotect Sheet" pansi pa "Zosintha." Lowetsani achinsinsi kumaliza ndondomekoyi.
Gawo 3 : Ngati ndi buku lantchito lomwe limatetezedwa, dinani "Onetsani Buku la Ntchito" ndiyeno lowetsani mawu achinsinsi kuti muchotse choletsacho.
Sungani chikalatacho ndipo chiletso chowerengera chidzachotsedwa.
Fayilo ya Excel ndi mawu achinsinsi oletsedwa ngati kuwerenga kokha
Nthawi zina mukatsegula fayilo ya Excel yosungidwa, mudzafunsidwa kuti mulowetse mawu achinsinsi kuti mulembe kapena kuti mutsegule kuti muwerenge kokha. Dinani pa "Werengani kokha" ndipo fayilo ya Excel idzangosinthidwa ndikuwerenga. Tsatirani izi kuti mutsegule fayilo ya Excel yowerengera yokha:
Gawo 1. Sungani fayilo yomwe ilipo pano ya Excel kuti muwerenge pokha podina Fayilo> Sungani Monga.
Gawo 2. Ingosungani ngati chikalata china cha Excel ndikudina "Sungani" kuti mupitilize.
Tsopano mutha kutsegula fayilo ya Excel ndikusintha.
Langizo la Bonasi: Chotsani Excel Kuwerenga Popanda Mawu Achinsinsi (Pamilandu Yonse Yapamwamba)
Ngati mukufuna kuchotsa mawonekedwe a "kuwerenga-okha" a Excel kukhazikitsidwa ndi zosankha zonse kungodina kamodzi opanda mawu achinsinsi , ndiye imodzi mwa njira zabwino kwambiri zopangira izi ndikugwiritsa ntchito chida chochotsa achinsinsi cha Excel ngati Passper kwa Excel .
Passper kwa Excel ndi chida chomwe chimakupatsani mwayi wochotsa zosintha zowerengera zokha pogwiritsa ntchito Mark monga Final ndi Save As, chotsani zoletsa pamapangidwe amasamba a Excel ndi mabuku ogwirira ntchito, ndikuchotsa mawu achinsinsi otsegulira pa chikalata chilichonse chotsekedwa cha Excel.
Chifukwa chake, ndi chida chothandiza kwambiri ngati simungathe kutsegula kapena kusintha chikalata chowerengera chokha cha Excel. Izi ndi zina mwazinthu zake:
Passper wa Excel: Chotsani kuwerenga Excel mumasekondi a 2:
- Milandu yonse imakhudzidwa: Chotsani kapena kuletsa kuwerenga Excel muzochitika zonse zomwe zingatheke.
- Kupambana kwakukulu: Algorithm yapamwamba imatsimikizira a 100% kuchotsa mlingo .
- Zosavuta kugwiritsa ntchito : Ndiwosavuta kugwiritsa ntchito. Ndi izo, inu mukhoza achire kutsegula achinsinsi mu masitepe ochepa ndi kuchotsa zoletsa kamodzi pitani.
Momwe Mungatsegule Mafayilo Owerenga-Okha a Excel okhala ndi Passper ya Excel
Nayi momwe mungagwiritsire ntchito Passper ya Excel kuchotsa zoletsa zowerengera zokha pa chikalata cha Excel:
Gawo 1: Koperani ndi kukhazikitsa Passper kwa Excel pa kompyuta yanu ndikutsegula. Mu chachikulu zenera, kusankha «Chotsani zoletsa «.
Gawo 2: Dinani "Add" kuti mulowetse chikalata choletsedwa ku Passper.
Gawo 3: Chikalatacho chikawonjezedwa bwino ku pulogalamuyi, dinani "Kuthetsa »ndipo zoletsa zilizonse zowerengera pa chikalata cha Excel zidzachotsedwa bwino.
Malangizo: Monga tanena kale, Passper for Excel itha kugwiritsidwanso ntchito kubwezeretsa mapasiwedi otsegula. Ngati mwataya achinsinsi kuti mutsegule fayilo yanu ya Excel kapena ngati mwalandira fayilo ya Excel yotetezedwa ndi mawu achinsinsi otsegulira, mutha kuyesanso.
Mapeto
Zomwe zili pamwambazi ndi njira 5 zabwino kwa inu ngati simukudziwa momwe mungachotsere kuwerenga kuchokera ku Excel . Chonde dziwani kuti pakhoza kukhala zifukwa zingapo zomwe simungathe kupeza chikalata cha Excel, ngakhale chimodzi mwazofala kwambiri ndi pomwe chikalatacho "chalembedwa chomaliza." Passper kwa Excel amakulolani kuti mupeze chikalatacho mosavuta mosasamala kanthu za zoletsedwa, kuphatikizapo chikalata chotetezedwa ndi mawu achinsinsi.
