Pogwiritsa ntchito Point ndi Dinani Kuti Mukonze Mafomu mu Excel

Pogwiritsa ntchito mfundo ndikusindikiza mu Excel ndi Google Spreadsheets amakulolani kugwiritsa ntchito pointer ya mouse kuti muwonjezere maofesi a mawonekedwe pokhapokha mutsegula selo lofunidwa monga momwe zasonyezedwera mu chitsanzo cha chithunzi pamwambapa.

Lembani ndikulumikiza kawirikawiri njira yosankhika yowonjezeramo zigawo zapangidwe kawonekedwe kapena kugwira ntchito ngati zimachepetsa kuthekera kwa zolakwika zomwe zimayambidwa posawerenga kapena kusindikiza muloweta.

Njira iyi ingathenso kuteteza nthawi yambiri ndi khama popanga mawonekedwe popeza anthu ambiri amawona deta omwe akufuna kuwonjezera pa ndondomeko m'malo mowerengera selo.

Kupanga Fomu Pogwiritsa Mfundo ndi Dinani

1. Lembani chizindikiro chofanana (=) mu selo kuti muyambe fomu;
2. Dinani pa selo yoyamba kuti muwonjezere ku ndondomekoyi. Tsitsi la selo lidzawoneka mu ndondomeko, ndipo mzere wonyezimira utawonekera kuzungulira selo lofotokozedwa;
3. Koperani chinsinsi cha makina pa khibhodi (monga chizindikiro chowonjezera kapena chosasinthika) kuti mulowetse woyendetsa muyeso pambuyo poyang'ana selo yoyamba;
4. Dinani pa selo yachiwiri kuti muwonjezere ku ndondomekoyi. Tsitsi la selo lidzawoneka mu ndondomeko, ndipo mzere wofiira wofiira udzawoneka kuzungulira selo lachiwiri lofotokozedwa;
5. Pitirizani kuwonjezera operekera ndi mawonekedwe a maselo mpaka ndondomeko yatha;
6. Dinani ku Enter pa kibokosiko kuti mutsirize fomuyi ndikuyang'ana yankho mu selo.

Kusinthasintha kwa Malo ndi Dinani: Kugwiritsira ntchito Zingwe za Arrow

Kusiyanitsa pa mfundo ndi pang'onopang'ono kumaphatikizapo kugwiritsa ntchito makiyi a makani pa kibokosilo kuti mulowetse mafotokozedwe a selo muyeso. Zotsatirazo ndizofanana, ndipo ndizofunikira chabe pa njira yosankhidwa.

Kugwiritsa ntchito makiyi otsekera kuti mulowetse zizindikiro za selo:

1. Lembani chizindikiro chofanana (=) mu selo kuyambitsa fomu;
2. Gwiritsani ntchito mafungulo pa makiyi kuti mupite ku selo yoyamba kuti igwiritsidwe ntchito - chilolezo cha selo chimenecho chimawonjezeredwa ku chithunzi pambuyo pa chizindikiro chofanana;
3. Pewani makiyi a makina pa makiyi - monga chizindikiro chowonjezera kapena chosasintha - kulowetsa woyendetsa muyeso pambuyo poyang'ana selo yoyamba ( yogwiritsira ntchito selo yeniyeniyo idzabwerera ku selo yomwe ili ndi fomu);
4. Gwiritsani ntchito mafungulo pa makiyi kuti mupite ku selo yachiwiri kuti mugwiritsidwe ntchito - fomu yachiwiri yowonjezeredwa ikuwonjezeredwa ku ndondomeko pambuyo pa olemba masamu;
5. Ngati mukufunikira, lowetsani masamu owonjezera a masamu pogwiritsa ntchito kambokosiyo potsatira ndondomeko ya selo ya deta
6. Mukamaliza kukonzekera, pindani makiyi a Enter mu makina kuti mukwaniritse mayendedwe anu ndikuyang'ana yankho mu selo.