Mukhoza kugwiritsa ntchito Pezani ndikutsogola (Pezani ndi Kusintha) mu Excel kuti mupeze mwachangu mawu omwe mukufuna ndikusintha ndi mawu ena. Mukhozanso kugwiritsa ntchito lamulo Pitani ku Special (Sankhani Gulu la Maselo) kuti musankhe mwachangu maselo onse okhala ndi ma fomula, ndemanga, masanjidwe okhazikika, osasinthasintha, ndi zina zambiri.
Kuti mupeze
Kuti mupeze mawu enaake mwachangu, tsatirani malangizo athu:
- Pa Advanced tabu Kunyumba (Kunyumba) dinani Pezani & Sankhani (Pezani ndi kuwunikira) ndikusankha Pezani (Pezani).
A dialog box adzaoneka Pezani ndikutsogola (Pezani ndikusintha).
- Lowetsani malemba omwe mukufuna kufufuza, mwachitsanzo "Ferrari".
- atolankhani Pezani Zotsatira (Pezani pansipa).
Excel idzawonetsa zomwe zimachitika koyamba.
- atolankhani Pezani Zotsatira (Pezani chotsatira) kachiwiri kuti muwonetsere kuchitika kwachiwiri.
- Kuti mupeze mndandanda wazonse zomwe zachitika, dinani Pezani Zonse (Pezani zonse).
M'malo
Kuti mupeze mawu enaake mwachangu ndikusintha ndi mawu ena, tsatirani izi:
- Pa Advanced tabu Kunyumba (Kunyumba) dinani Pezani & Sankhani (Pezani ndi kuwunikira) ndikusankha Sinthanitsani (Sinthani).
Bokosi lazokambirana la dzina lomweli lidzawonekera ndi tabu yogwira Sinthanitsani (Sinthani).
- Lowetsani mawu omwe mukufuna kufufuza (mwachitsanzo, "Veneno") ndi mawu omwe mukufuna kuwasintha (mwachitsanzo, "Diablo").
- Dinani Pezani Zotsatira (Pezani pansipa).
Excel idzawonetsa zomwe zimachitika koyamba. Palibe zolowa m'malo zomwe zapangidwa pano.
- atolankhani Sinthanitsani (Bwezerani) kuti mupange cholowa chimodzi.
Zindikirani: ntchito Bwezerani Zonse (Sinthani Zonse) kuti musinthe zochitika zonse.
Kusankha gulu la maselo
Mukhoza kugwiritsa ntchito Pitani ku Special (Kusankha Magulu Amagulu) kuti musankhe mwachangu ma cell onse okhala ndi ma fomula, ndemanga, masanjidwe okhazikika, osasinthasintha, ndi zina zambiri. Mwachitsanzo, posankha ma cell onse okhala ndi ma formula, chitani izi:
- Sankhani selo limodzi.
- Pa Advanced tabu Kunyumba (Kunyumba) dinani Pezani & Sankhani (Pezani ndi kuwunikira) ndikusankha Pitani ku Special (Kusankha gulu la maselo).
Zindikirani: Mafomula, ndemanga, masanjidwe azikhalidwe, zokhazikika, ndi kutsimikizira deta zonse zitha kupezeka ndi lamulo Pitani ku Special (Kusankha gulu la maselo).
- Chongani bokosi pafupi Mafomu (Mafomu) ndikudina OK.
Zindikirani: Mutha kusaka ma cell okhala ndi ma fomula omwe amabwezera manambala, mawu, ogwiritsira ntchito momveka bwino (TRUE ndi FALSE), ndi zolakwika. Komanso, zosankhazi zitha kupezeka ngati muyang'ana bokosilo Zonse (Zokhazikika).
Excel iwonetsa ma cell onse okhala ndi ma formula:
Zindikirani: Ngati mwasankha selo limodzi musanadina Pezani (Pezani), Sinthanitsani (Bwezerani) kapena Pitani ku Special (Sankhani gulu la maselo), Excel idzawona pepala lonse. Kuti mufufuze m'maselo angapo, choyamba sankhani gulu lomwe mukufuna.