Bisani ndikugwirizanitsa Zithunzi, Mizere, ndi Maselo mu Excel

Mukufuna kuphunzira momwe mungagwirizanitse kapena kubisa zikhomo mu Microsoft Excel? Phunziro lalifupili likufotokozera zonse zomwe mukufunika kuti muzitsatira, makamaka:

1. Bisani Mazithunzi
2. Onetsani kapena Yambani Mizati
3. Mmene Mungabisire Mizere
4. Onetsani kapena Yambani Mizere

01 a 04

Bisani Columns mu Excel

Maselo a munthu sangathe kubisika ku Excel. Kuti abise deta yomwe ili mu selo imodzi, mwina chigawo chonse kapena kusuntha seloyo muyenera kubisika.

Chidziwitso chazomwe mukubisa ndi zosagwirizana ndi mizere chingapezeke pamasamba otsatirawa:

1. Bisani Columns - onani pansipa;
2. Mizati Yogwirizanitsa - kuphatikizapo Phukusi A;
3. Bisani Mizere;
4. Misewu yotsitsimutsa - kuphatikizapo Row 1.

Njira Zophimbidwa

Monga mu mapulogalamu onse a Microsoft, pali njira imodzi yokwaniritsira ntchito. Malangizo omwe ali mu phunziroli akuphimba njira zitatu zobisala ndi kusanthana zipilala ndi mizere mu tsamba la Excel :

• pogwiritsa ntchito njira yomasulira,
• pogwiritsa ntchito ndondomeko yolongosola molondola
• pogwiritsa ntchito machitidwe omwe ali pa Tsambali la Home la Ribbon

Deta Gwiritsani Ntchito Ma Columns Ndiponso Mizere Yobisika

Pamene ndemanga ndi mizere yomwe ili ndi deta ili yobisika, deta siidachotsedwa ndipo Icho chingakhoze kufotokozedwa mu malemba ndi masati.

Mafomu obisika omwe ali ndi mafotokozedwe a magulu adzasinthabe ngati deta yomwe ili mu maselo ofotokozedwa amasintha.

1. Bisani Ma Columns Pogwiritsa Ntchito Zowonjezera Keyi

Kuphatikizira kwachinsinsi kwachinsinsi pamakalata obisala ndi:

Ctrl + 0 (zero)

Kubisa Kamba Womodzi Pogwiritsa Ntchito Chofufuzira Chophindikiza

1. Dinani pa selo m'ndandanda kuti mubisale kuti ikhale selo yogwira ntchito.
2. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
3. Dinani ndi kumasula "0" popanda kumasula makiyi a Ctrl .
4. Mphindi yomwe ili ndi selo yogwira ntchito limodzi ndi deta iliyonse yomwe ilipo iyenera kubisika kuchokera kuwona.

• Kuti mubise maulendo angapo pogwiritsa ntchito njira yachinsinsi, onetsetsani selo limodzi m'ndandanda iliyonse kuti mubisale, ndi kubwereza masitepe 2 ndi 3 pamwambapa.

2. Bisani Ma Columns Pogwiritsa Ntchito Mndandanda Wa Mndandanda

Zosankha zomwe zilipo mndandanda wazinthu - kapena pindani pakumanja - pangani malingana ndi chinthu chomwe mwasankha pamene menyu yatsegulidwa.

Ngati Chobisa Chinsinsi , monga momwe chisonyezedwera mu chithunzi pamwambapa, sichipezeka m'menyu yokhudza nkhaniyi mwinamwake kuti mzere wonse sunasankhidwe pamene menyu itsegulidwa.

Kubisa Mzere Womodzi

1. Dinani pa mutu wa mutu wa ndimeyo kuti mubisalire kuti muyankhe mzere wonsewo.
2. Dinani pazithunzi zomwe mwasankha kuti mutsegule mndandanda wamkati.
3. Sankhani Kubisa ku menyu.
4. Mndandanda wosankhidwa, kalata yamtundu, ndi deta iliyonse m'ndandanda idzabisika kuchokera kuwona.

Kubisa Ma Columns Adjacent

Mwachitsanzo, mukufuna kubisa columns C, D, ndi E.

1. Mu mutu wa mutuwo, dinani ndi kukoka ndi pointer ya mouse kuti muwonetse zipilala zonse zitatu.
2. Dinani kumene pazitsulo zosankhidwa.
3. Sankhani Kubisa ku menyu.
4. Makalata osankhidwa ndi zilembo adzazibisika kuchokera kuwona.

Kubisa Ma Columns Osiyana

Mwachitsanzo, mukufuna kubisa zigawo B, D, ndi F

1. Mu mutu wa mutuwo dinani pa column yoyamba kuti mubisale.
2. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
3. Pitirizani kulemba makiyi a Ctrl ndikusankhira kamodzi pamphindi yina iliyonse kuti mubisankhire.
4. Tulutsani makiyi a Ctrl .
5. Mu mutu wa pamutu, dinani pomwepo pa imodzi mwazitsulo zosankhidwa.
6. Sankhani Kubisa ku menyu.
7. Makalata osankhidwa ndi zilembo adzazibisika kuchokera kuwona.

Zindikirani : Pamene mubisala zipilala zosiyana, ngati pointeru yamagulu sichidutsa pamutu wapamutu pamene bomba labwino la mbewa likudodometsedwa, chophimba sichipezeka.

02 a 04

Onetsani kapena Yambani Zikhomo mu Excel

1. Mgwirizano Phukusi A Kugwiritsa Ntchito Dzina la Bokosi

Njira iyi ingagwiritsidwe ntchito kuti iwonetsetse chigawo chilichonse - osati mzere wa A.

1. Lembani selo lotanthauzira A1 mu Box Name .
2. Dinani pakiyi ya Kulowa pa makina kuti musankhe chinsinsi chobisika.
3. Dinani pa tabu la Home la riboni .
4. Dinani pa Chithunzi chojambula pa kaboni kuti mutsegule menyu otsika pansi.
5. Muwonekera gawo la menyu, sankhani Kisani & Unhide> Unhide Column.
6. Pulogalamu A idzawonekera.

2. Zosakanikirana Phukusi A Kugwiritsa Ntchito Njira Zake

Njira iyi ingagwiritsidwenso ntchito kugwirizanitsa chigawo chilichonse - osangokhala ndime A.

Mgwirizano wofunikira pazitsulo zosayika ndi:

Ctrl + Shift + 0 (zero)

Kuphatikizira Phukusi A Pogwiritsa Ntchito Njira Zowonjezera ndi Bokosi la Dzina

1. Lembani selo lotanthauzira A1 mu Box Name.
2. Dinani pakiyi ya Kulowa pa makina kuti musankhe chinsinsi chobisika.
3. Dinani ndi kugwirizira makina a Ctrl ndi Shift pa makiyi.
4. Dinani ndi kumasula fungulo "0" popanda kumasula makiyi a Ctrl ndi Shift .
5. Pulogalamu A idzawonekera.

Kuphatikiza Mphindi Mmodzi kapena Zambiri Pogwiritsa Ntchito Zowonjezera Zake

Kuti musokoneze umodzi kapena zingapo, onetsetsani selo imodzi m'makalata mbali zonse zazomwe zilipo zobisika ndi pointer ya mouse.

Mwachitsanzo, mukufuna kusonkhanitsa zigawo B, D, ndi F:

1. Kuti mutsekezitse zipilala zonse, dinani ndi kukokera ndi mbewa kuti muwonetse zigawo A mpaka G.
2. Dinani ndi kugwirizira makina a Ctrl ndi Shift pa makiyi.
3. Dinani ndi kumasula fungulo "0" popanda kumasula makiyi a Ctrl ndi Shift .
4. Malo obisika (s) adzawonekera.

3. Zithunzi Zogwirizanitsa Pogwiritsa Ntchito Mndandanda wa Mndandanda

Mofanana ndi njira yochepetsera njira yam'munsiyi, muyenera kusankha ndime imodzi kumbali zonse zachinsinsi kapena ma column kuti muwasonyeze.

Kuphatikiza Mphindi imodzi kapena Zambiri

Mwachitsanzo, kusanthana zikhomo D, E, ndi G:

1. Tsambani pointer la mouse pa column C mu mutu wa mutu.
2. Dinani ndi kukokera ndi mbewa kuti muyike mizati C mpaka H kuti muzitha kuimiritsa mizati yonse nthawi imodzi.
3. Dinani kumene pazitsulo zosankhidwa.
4. Sankhani Chiphwando kuchokera pa menyu.
5. Malo obisika (s) adzawonekera.

4. Mgwirizano Wachigawo A mu Excel Versions 97 mpaka 2003

1. Lembani selo lotanthauzira A1 mu Bokosi la Dzina ndipo dinani fungulo lolowamo mukibokosi.
2. Dinani pa menyu ya Fomu .
3. Sankhani Phukusi> Yambani mndandanda mu menyu.
4. Pulogalamu A idzawonekera.

03 a 04

Mmene Mungabisire Mizere Mu Excel

1. Bisani Mzere pogwiritsa ntchito njira zofikira

Kuphatikizira kwachinsinsi kwachinsinsi pazinsinsi zobisala ndi:

Ctrl + 9 (nambala 9)

Kubisa Mzere Womodzi pogwiritsa ntchito Keyboard Shortcut

1. Dinani pa selo mzere kuti mubisidwe kuti mupange selo yogwira ntchito .
2. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
3. Onetsetsani ndi kumasula "9" popanda kumasula makiyi a Ctrl .
4. Mzere umene uli ndi selo yogwira ntchito limodzi ndi deta iliyonse yomwe ilipo iyenera kubisika kuwona.

• Kuti mubise mizera yambiri pogwiritsa ntchito njira yachinsinsi, onetsetsani selo imodzi mumzere uliwonse kuti mubisidwe, ndi kubwereza masitepe 2 ndi 3 pamwambapa.

2. Bisani Mzere Pogwiritsa Ntchito Mndandanda wa Mndandanda

Zosankha zomwe zilipo mndandanda wazinthu - kapena pindani pakumanja - pangani malingana ndi chinthu chomwe mwasankha pamene menyu yatsegulidwa.

Ngati Chobisa Chinsinsi , monga momwe chisonyezedwera pa chithunzi pamwambapa, sichipezeka m'menyu yokhudza nkhaniyi mwinamwake mzera wonse sunasankhidwe pamene menyu itsegulidwa. Njira Yobisika imapezeka kokha pamene mzere wonse wasankhidwa.

Kubisa Mzere Wokha

1. Dinani pamutu wa mzere wa mzere kuti mubiseke kuti musankhe mzera wonse.
2. Dinani pakanema omwe mwasankha kuti mutsegule mndandanda wa masewera
3. Sankhani Kubisa ku menyu.
4. Mzere wosankhidwa, kalata ya mzere, ndi deta iliyonse mu mzere idzabisika kuchokera kuwona.

Kubisa Mizere Yambiri

Mwachitsanzo, mukufuna kubisa mizere 3, 4, ndi 6.

1. Mu mutu wa mzere, dinani ndi kukokera ndi pointer ya mouse kuti muike mizere itatu yonse.
2. Dinani pazitsulo zomwe mwasankha.
3. Sankhani Kubisa ku menyu.
4. Mizere yosankhidwa idzabisika kuchokera kuwona.

Kubisa Mzere Wosiyana

Mwachitsanzo, mukufuna kubisa mizere 2, 4, ndi 6

1. Mu mzere wa mutu, dinani pamzere woyamba kuti mubiseke.
2. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
3. Pitirizani kusunga fungulo la Ctrl ndikusani kamodzi pamzere wina uliwonse kuti mubisankhire kuti muwasankhe.
4. Dinani kumene pa umodzi mwa mizere yosankhidwa.
5. Sankhani Kubisa ku menyu.
6. Mizere yosankhidwa idzabisika kuchokera kuwona.

04 a 04

Onetsani kapena Yambani Mizere mu Excel

1. Mgwirizanitse Row 1 Kugwiritsa Ntchito Dzina la Bokosi

Njira iyi ingagwiritsidwe ntchito kuti isokoneze mzere umodzi - osati mzere woyamba.

1. Lembani selo lotanthauzira A1 mu Box Name.
2. Lembani fungulo lolowamo mulowelo kuti musankhe mzere wobisika.
3. Dinani pa tabu la Home la riboni.
4. Dinani pa Chithunzi chojambula pa kaboni kuti mutsegule menyu otsika pansi.
5. Muwoneka gawo gawo la menyu, sankhani Kisani & Unhide> Gwirizanitsani Row.
6. Row 1 liwoneka.

2. Mgwirizanitse Mzere 1 Pogwiritsa Ntchito Njira Zake

Njira iyi ikhonza kugwiritsidwanso ntchito kugwirizanitsa mzere umodzi - osati mzere woyamba.

Mgwirizano wofunika pa mizere yosagwedera ndi:

Ctrl + Shift + 9 (nambala 9)

Kuthandizani Mgwirizano Wowonjezera 1 pogwiritsa ntchito njira zadule ndi dzina la bokosi

1. Lembani selo lotanthauzira A1 mu Box Name.
2. Lembani fungulo lolowamo mulowelo kuti musankhe mzere wobisika.
3. Dinani ndi kugwirizira makina a Ctrl ndi Shift pa makiyi.
4. Dinani ndi kumasula makiyi 9 owerengeka popanda kumasula makiyi a Ctrl ndi Shift .
5. Row 1 liwoneka.

Kuyanjanitsa Mmodzi kapena Mitsinje Yambiri Kugwiritsa Ntchito Njira Zopangira Msewu

Kuti mutseke mizere imodzi kapena iwiri, onetsetsani selo imodzi m'mzerewu kumbali zonse za mzere wosabisika ndi pointer ya mouse.

Mwachitsanzo, mukufuna kupanga mizere 2, 4, ndi 6:

1. Kuti mutseke mizere yonse, dinani ndi kukokera ndi mbewa kuti muike mizera 1 mpaka 7.
2. Dinani ndi kugwirizira makina a Ctrl ndi Shift pa makiyi.
3. Dinani ndi kumasula makiyi 9 owerengeka popanda kumasula makiyi a Ctrl ndi Shift .
4. Mzere wobisika (s) udzawonekera.

3. Misewu Yogwirizanitsa Pogwiritsa Ntchito Mndandanda wa Mndandanda

Mofanana ndi njira yochepetsera njira yapamwamba, muyenera kusankha mzere umodzi kumbali iliyonse ya mzere kapena mzere wofikira kuti muwasonyeze.

Kuyanjanitsa Mmodzi kapena Mitsinje Yambiri Pogwiritsa Ntchito Mndandanda wa Mndandanda

Mwachitsanzo, kuti mutseke mizere 3, 4, ndi 6:

1. Sungani pointer la mouse pamzerewu 2 pamutu wa mutu.
2. Dinani ndi kukokera ndi mbewa kuti muike mizere 2 mpaka 7 kuti musokoneze mizere yonse nthawi imodzi.
3. Dinani pazitsulo zomwe mwasankha.
4. Sankhani Chiphwando kuchokera pa menyu.
5. Mzere wobisika (s) udzawonekera.

4. Mgwirizanitse Row 1 mu Excel mavesi 97 mpaka 2003

1. Lembani selo lotanthauzira A1 mu Bokosi la Dzina ndipo dinani fungulo lolowamo mukibokosi.
2. Dinani pa menyu ya Fomu .
3. Sankhani Mzere> Yambani mndandanda.
4. Row 1 liwoneka.

Muyeneranso kufufuza momwe mungabisire ndi kusokoneza maofesi ku Excel .