Excel Lembani Lamulo Lansi

Sungani nthawi ndikuwonjezera kulondola mwa kukopera deta ku maselo ena

Lamulo lotsegula la Microsoft Excel limakuthandizani kuti muzitha maselo mwamsanga komanso mosavuta. Phunziro lalifupili likuphatikizira njira zochepetsera makina kuti ntchito yanu ikhale yosavuta.

Kulemba manambala, malemba, ndi malemba mu Excel spreadsheets kungakhale kovuta komanso kosavuta ngati mutalowa ma selo iliyonse kapena mumaganizira mosiyana. Mukafuna kufotokoza deta yomweyi mu ma selo angapo pafupi ndi mzere , Fill Down command ikhoza kukuchitirani izi mwamsanga pogwiritsira ntchito kambokosi.

Mgwirizano wapadera umene umagwira Ntchito Yodzaza pansi ndi Ctrl + D (Windows) kapena Command + D (macOS).

Gwiritsani ntchito Zodzaza ndi Chotsani Chophimba Chophimba ndi Palibe Mouse

Njira yabwino yofotokozera Lamulo Lodzaza ndi chitsanzo. Tsatirani ndondomekoyi kuti muwone momwe mungagwiritsire ntchito Zodzaza anu ma Excel spreadsheets.

1. Lembani nambala, monga 395.54 , kulowa mu selo D1 mu tsamba la Excel.
2. Lembani ndi kugwiritsira chinsinsi cha Shift pa makiyi.
3. Lembani ndi kugwiritsira ntchito fungulo la Down Arrow pa kibokosilo kuti mukulitse kuunika kwa selo kuchokera ku selo D1 mpaka D7.
4. Tulutsani mafungulo onsewa.
5. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
6. Dinani ndi kumasula fungulo D pa makiyi.

Maselo D2 ku D7 ayenera tsopano kudzazidwa ndi deta yomweyi monga selo D1.

Lembani Chitsanzo Chogwiritsira Ntchito Mouse

Ndimatchulidwe ambiri a Excel, mungagwiritse ntchito mbewa yanu kuti mulowe mu selo ndi nambala yomwe mukufuna kufotokozera m'maselo pansi pake ndipo dinani mu selo lotsiriza la maina kuti musankhe maselo oyambirira ndi otsiriza ndi maselo onse pakati pawo. Gwiritsani ntchito njira yachinsinsi ya Ctrl + D (Windows) kapena Command + D (macOS) kuti mufanizire nambala yomwe ili mu selo yoyamba ku maselo onse osankhidwa.

Solution ya Feature AutoFill

Pano ndi momwe mungakwaniritsire zotsatira zomwezo ndi mbali ya AutoFill:

1. Lembani nambala mu selo mu Excel spreadsheet.
2. Dinani ndigwiritseni pazitsulo chodzaza pansi pa ngodya ya kumanja ya selo yomwe ili ndi nambala.
3. Kokani chotsani chotsitsa pansi kuti musankhe maselo omwe mukufuna kukhala nawo nambala yomweyo.
4. Tulutsani mbewa ndipo nambala imakopilidwa mu selo iliyonse yosankhidwa.

Chigawo cha AutoFill chimagwiranso ntchito pang'onopang'ono kufotokozera nambala kumaselo oyandikana mumzere womwewo. Ingodinani ndi kukoketsa chogwiritsira chodzaza m'maselo pang'onopang'ono. Mukamasula mbewa, nambalayi imakopedwa mu selo iliyonse yosankhidwa.

Njira iyi imagwiranso ntchito ndi malemba kuwonjezera pa malemba ndi manambala. M'malo molemba mobwerezabwereza kapena kukopera ndi kupangira ndondomeko, sankhani bokosi lomwe liri ndi chiganizo. Dinani ndikugwiritsira ntchito chogwiritsira ntchito ndikugwedeza pamaselo omwe mukufuna kukhala nawo.