Njira 6 zoletsa kuwerenga mu Excel 2016

Fayilo ya Excel imatha kuyikidwa munjira yowerengera-pokha pomwe fayiloyo yalembedwa kuti ndiyomaliza, ikasungidwa ngati yowerengera-yokha, kapena mawonekedwe a spreadsheet kapena buku lantchito atatsekedwa, ndi zina zambiri. Komabe, ngakhale kuwerenga kungakhale kothandiza, kungakhalenso cholepheretsa, makamaka ngati simukudziwa kuchotsa choletsacho.

M'nkhaniyi, tiona njira zina zochitira letsani kuwerenga mu Excel 2016 kaya muli ndi mawu achinsinsi kapena ayi.

Gawo 1. Njira Yodziwika Yoletsa Kuwerenga mu Excel 2016 Popanda Achinsinsi

Kuletsa gawo lowerengera mu Excel kumatha kukhala kovuta, ngakhale kosatheka, pomwe simukudziwa mawu achinsinsi omwe amagwiritsidwa ntchito poika zoletsa. Komabe, pali zida zina pamsika zomwe zingakuthandizeni kuthetsa kuwerenga mu Excel 2016 mosavuta. Chimodzi mwa zabwino kwambiri ndi Passper kwa Excel .

Izi ndi zina mwazinthu zomwe Passer for Excel amapereka:

• Imathandizira kuchotsa mitundu yonse pamachitidwe owerengera okha palibe mawu achinsinsi.
• Chotsani mawu achinsinsi otsegula ndi kuthetsedwa chitetezo cha werengani mu mapepala / mabuku Excel 2016 popanda kukhudza chikalata deta.
• Tsegulani mapepala a Excel pamene mwaiwala mawu achinsinsi, simungathe kukopera spreadsheet kapena deta ya buku la ntchito, simungathe kusindikiza spreadsheet/bookbook, kapena simungathe kusintha zomwe zili mu chikalatacho.
• Komanso, ndi yosavuta kugwiritsa ntchito , popeza imakulolani kufufuta zowerengazo mukangodina kamodzi.
• Imathandizira mitundu yonse ya zolemba za Excel, kuphatikiza Excel 96-Excel 2019.

Yesani kwaulere

Umu ndi momwe mungagwiritsire ntchito Passper for Excel kuchotsa kuwerenga mu chikalata chilichonse cha Excel:

Gawo 1: Tsitsani ndikuyika Passper ya Excel pa kompyuta yanu ndikuyambitsa pulogalamuyo.

Gawo 2: Dinani "Chotsani Zoletsa" ndikudina "Onjezani" kuti mupeze chikalata choletsedwa cha Excel mu pulogalamuyi.

Gawo 3: Fayiloyo ikawonjezedwa ku pulogalamuyi, dinani "Chotsani" ndipo Passper for Excel iyamba kuchotsa zoletsa pafayiloyo. M'masekondi angapo, mudzatha kupeza chikalata cha Excel 2016 popanda zoletsa zilizonse.

Yesani kwaulere

Gawo 2. 5 Milandu Yosiyanasiyana Yoletsa Kuwerenga mu Excel 2016

Pali makamaka 5 mitundu yosiyanasiyana pomwe Excel 2016 yanu imalembedwa kuti yowerengera-yokha ndipo yankho lawo lofananira ndikuyimitsa mawonekedwe owerengera okha.

Mlandu 1: Pamene chikalatacho chikuwerengedwa pokha posunga

Mutha kugwiritsa ntchito gawo la "Save As" monga lili pansipa kuti muzimitse njira yowerengera mu Excel 2016:

Gawo 1: Yambani ndikutsegula buku la Excel ndikulowetsa mawu achinsinsi ngati kuli kofunikira. Dinani "Fayilo> Sungani Monga" ndiyeno sankhani malo oyenera pa kompyuta yanu kuti musunge fayilo.

Wadutsa 2: Dinani muvi wotsikira pansi pafupi ndi batani "Zida »ndipo sankhani «General options «.

Wadutsa 3: Chotsani mawu achinsinsi omwe amapezeka mubokosi la "Password to modify" ndikudina "Chabwino" kuti mukweze chiletso chowerengera chokha. Dinani "Chabwino."

Wadutsa 4: Pomaliza, dinani "Save" kuti mumalize ndondomekoyi.

Mlandu 2: Pamene chikalatacho chalembedwa ngati chomaliza

Kuyika chikalata chanu cha Excel 2016 ngati "Final" kumatha kuyika chiletso chowerengera pa chikalatacho. Umu ndi momwe mungaletsere chiletsochi pachikalata chomwe chalembedwa kuti chomaliza.

Gawo 1: Tsegulani chikalata choletsedwa cha Excel 2016 pa kompyuta yanu.

Gawo 2: Pamwamba pa chikalatacho, muyenera kuwona batani "Sinthani mulimonse «. Dinani ndipo chiletso chowerengera chokha chidzachotsedwa, kukulolani kuti musinthe chikalatacho.

Mlandu 3: Pamene spreadsheet kapena kabukhu kabuku katsekedwa

Zoletsa zowerengera zokha zitha kuchitikanso ngati wolemba chikalata cha Excel 2016 watseka dongosolo la pepala kapena buku logwirira ntchito, kulepheretsa kuti tsambalo lisasinthidwe. Pankhaniyi, mungathe kuthetsa vutoli mwa njira zosavuta izi:

Gawo 1: Tsegulani chikalata cha Excel ndikuletsa kuwerenga kokha, kenako dinani «Unikani> Tsamba lotetezedwa «.

Gawo 2: Lowetsani mawu achinsinsi m'bokosi loyenera ndikudina "Chabwino" kuti mukweze chiletsocho.

Mlandu wa 4: Pamene chikalatacho chili ndi mawonekedwe owerengera okha

Kuwerenga kumatha kulemedwa mu Excel 2016 pogwiritsa ntchito njira ya File Properties mu Windows File Explorer. Umu ndi momwe mumachitira:

Gawo 1: Mu File Explorer, pita ku fayilo ya Excel yoletsedwa. Dinani kumanja chikalatacho, ndiyeno sankhani "Katundu" mwa njira zomwe zaperekedwa.

Gawo 2: Chotsani chosankhacho Werengani kokha " mu gawo "Makhalidwe »ndipo dinani "Chabwino" kuti mulepheretse zoletsa zowerengera zokha.

Mlandu 5: Pamene chikalata cha Excel 2016 chikufunika mawu achinsinsi

Mukafuna kuyika mawu achinsinsi kuti mupeze ndikusintha chikalata cha Excel 2016, mutha kutsata njira zosavuta izi kuti muchotse izi:

Gawo 1: Yambani ndikutsegula chikalata cha Excel 2016 chomwe mukufuna kuzimitsa chowerengera chokha.

Gawo 2: Pamene bokosi lachinsinsi likuwonekera, dinani Werengani kokha » m'malo mwake ndipo chikalatacho chidzatsegulidwa mu Read Only mode.

Gawo 3: Tsopano dinani "Archive > Sungani ngati »ndipo lowetsani dzina lina lafayilo. Dinani pa « Sungani »kusunga fayilo yatsopano.

Fayilo yatsopano yomwe yapangidwa idzalowa m'malo mwa chikalata chowerengera chokha ndipo sichikhala ndi zoletsa zilizonse zoyambirira.

Mayankho omwe ali pamwambawa amakupangitsani kukhala kosavuta kuti muletse kuwerenga kokha mu Excel 2016 kaya muli ndi mawu achinsinsi kapena ayi. Sankhani njira yomwe ikugwirizana ndi zosowa zanu komanso mkhalidwe wanu. Tiuzeni ngati mungathe kukweza malire owerengera okha mu gawo la ndemanga pansipa.

Yesani kwaulere