Pangani ulalo wakunja mu Excel

• Pangani ulalo wakunja
• Zidziwitso
• Kusintha kwa ulalo

Kufotokozera kwakunja ku Excel ndikofotokozera za selo (kapena ma cell angapo) mubuku lina lantchito. Pa zojambula

pansipa mukuwona mabuku ochokera m'madipatimenti atatu (Kumpoto, Pakati ndi Kumwera).

Pangani ulalo wakunja

Kuti mupange ulalo wakunja, tsatirani malangizo ali pansipa:

1. Tsegulani zolemba zonse zitatu.
2. M'buku la "Company", onetsani selo B2 ndipo lowetsani chizindikiro chofanana "="".
3. Pa Advanced tabu View (Onani) dinani batani Sinthani Windows (Pitani ku zenera lina) ndi kusankha "North".
4. M'buku "North", onetsani selo B2 ndi kulowa "+".
5. Bwerezani masitepe 3 ndi 4 pa mabuku a "Mid" ndi "South".
6. Chotsani zizindikiro za "$" mu fomula yamaselo B2 ndikukopera fomulayi kumaselo ena. Zotsatira:

Zidziwitso

Tsekani zolemba zonse. Pangani zosintha m'mabuku a dipatimenti. Tsekaninso zolemba zonse. Tsegulani fayilo ya "Company".

1. Kuti musinthe maulalo onse, dinani batani Onetsani Zamkatimu (Phatikizanipo zomwe zili).
2. Kuti maulalo asasinthidwe, dinani batani X.

Zindikirani: Mukawona chenjezo lina, dinani Pezani (Zosintha) kapena Osasintha (Osasintha).

Kusintha kwa ulalo

Kuti mutsegule bokosi la zokambirana Sinthani Maulalo (Sintha Maulalo), pa tabu Deta (Deta) mu gawo Magulu olumikizana (Malumikizidwe) dinani Sinthani maulalo chizindikiro (Sintha maulalo).

1. Ngati simunasinthe maulalo nthawi yomweyo, mutha kuwasintha pano. Sankhani buku ndikudina batani Sinthani Makhalidwe (Refresh) kuti mukonzenso maulalo abukuli. Zindikirani kuti kachirombo (Makhalidwe) amasintha kukhala OK.
2. Ngati simukufuna kusintha maulalo basi ndipo simukufuna kuti zidziwitso ziwonetsedwe, dinani batani Chidziwitso Choyambira (Pemphani kuti musinthe maulalo), sankhani njira yachitatu ndikudina OK.