Tsekani ndi kuteteza mabuku ogwirira ntchito mu Excel

Ngati mukuyembekeza kugawana buku lanu la Excel ndi ogwiritsa ntchito ena, ndiye kuti ndizomveka kubisa zinsinsi zonse zaumwini ndi zachinsinsi, fufuzani chikalatacho kuti muwone zolakwika, ndikuteteza bukulo m'njira imodzi. Momwe mungachitire zonsezi, muphunzira kuchokera mu phunziro ili.

Kufufuza kalembedwe

Musanagawane bukhu la Excel, zingakhale zothandiza kuyang'ana zolakwika za kalembedwe. Ndikuganiza kuti ambiri angavomereze kuti zolakwika za kalembedwe muzolemba zimatha kuwononga kwambiri mbiri ya wolemba.

1. Pa Advanced tabu Kubwereza pagulu kalembedwe press command kalembedwe.
2. A dialog box adzaoneka kalembedwe (kwathu ndi ). Wofufuza masipelo akupereka malingaliro owongolera cholakwika chilichonse cha masipelo. Sankhani njira yoyenera ndiyeno dinani batani M'malo.
3. Mukamaliza kufufuza za spell, bokosi la zokambirana lidzawoneka. Dinani OK kukwaniritsa.

Ngati palibe njira yoyenera, mutha kukonza cholakwikacho nokha.

Zolakwika zosowa

Kufufuza kwa spell mu Excel sikumagwira ntchito bwino nthawi zonse. Nthawi zina, ngakhale mawu olembedwa bwino amalembedwa molakwika. Nthawi zambiri izi zimachitika ndi mawu omwe mulibe mudikishonale. Ndizotheka kuti musakonze zolakwika zomwe zafotokozedwa molakwika pogwiritsa ntchito imodzi mwazinthu zitatu zomwe zilipo.

• Pitani - amasiya mawu osasinthika.
• Lumphani zonse - amasiya mawu osasinthika, ndikuwalumpha muzochitika zina zonse mu bukhu la ntchito.
• Onjezani ku mtanthauzira mawu - amawonjezera mawu ku dikishonale, kotero kuti sichidzadziwikanso ngati cholakwika. Onetsetsani kuti mawuwo alembedwa bwino musanasankhe izi.

Wofufuza Wopanga

Zambiri zanu zitha kuwoneka zokha mu Excel workbook. Pogwiritsa ntchito Wofufuza Wopanga mutha kupeza ndikuchotsa datayi musanagawane chikalatacho.

Chifukwa deta zichotsedwa Wofufuza Wopanga sichingabwezedwe nthawi zonse, tikukulangizani kuti musunge buku lowonjezera labukhuli musanagwiritse ntchito ntchitoyi.

Momwe Document Inspector imagwirira ntchito

1. Dinani file, Kusamukira ku mawonekedwe akumbuyo.
2. Pagulu luntha press command Sakani mavuto, ndiyeno kuchokera pa menyu yotsitsa, sankhani Wofufuza Wopanga.
3. Atsegula Wofufuza Wopanga. M'bokosi la zokambirana, sankhani mabokosi oyenerera kuti musankhe mitundu yomwe mukufuna kuyang'ana, kenako dinani cheke. Mu chitsanzo chathu, tinasiya zinthu zonse.
4. Zotsatira za mayeso ziyenera kuwonekera. Pachithunzi chomwe chili pansipa, mutha kuwona kuti bukhuli lili ndi zambiri zamunthu. Kuti muchotse deta iyi, dinani batani kufufuta zonse.
5. Dinani mukamaliza Close.

Chitetezo cha Ntchito

Mwachisawawa, aliyense amene ali ndi mwayi wopeza bukhu lanu lantchito akhoza kutsegula, kukopera, ndi kusintha zomwe zili mkati mwake, pokhapokha ngati zili zotetezedwa.

Momwe mungatetezere buku

1. Dinani file, Kusamukira ku mawonekedwe akumbuyo.
2. Pagulu luntha press command Kuteteza buku.
3. Sankhani njira yoyenera kwambiri pa menyu yotsitsa. Mu chitsanzo chathu, tasankha Chongani ngati chomaliza. Gulu Chongani ngati chomaliza limakupatsani kuchenjeza ena ogwiritsa ntchito za zosatheka kusintha bukhuli. Malamulo otsalawo amapereka mlingo wapamwamba wa kulamulira ndi chitetezo.
4. Chikumbutso chidzawonekera kuti bukhulo lidzalembedwa ngati lomaliza. Dinani OK, kupulumutsa.
5. Chikumbutso china chidzawonekera. Dinani OK.
6. Buku lanu lantchito tsopano lalembedwa kuti lomaliza.

Team Chongani ngati chomaliza sichingalepheretse ogwiritsa ntchito ena kusintha bukuli. Ngati mukufuna kuletsa ena ogwiritsa ntchito kusintha bukuli, sankhani lamulo Chepetsani mwayi.