Mmene Mungakwirire ndi Kuthetsa Mzere ndi Ma Columns mu Excel

Monga mu mapulogalamu onse a Microsoft, pali njira imodzi yokwaniritsira ntchito. Malangizo awa akuphimba njira ziwiri zowonjezeretsa ndi kuchotsa mizere ndi zigawo mu tsamba la Excel:

• pogwiritsa ntchito njira yomasulira
• pogwiritsa ntchito ndondomeko yolongosola molondola

Wonjezerani Mizere Ku Pulogalamu Yolemba

Pamene ndemanga ndi mizere yomwe ili ndi deta imachotsedwa, deta imachotsedwanso. Kuwonongeka kumeneku kungathenso kuthandizira ma fomu ndi ma chati omwe amatsata deta muzolemba ndi mizere yochotsedwa.

Ngati mwangozi tchulani zipilala kapena mizere yomwe ili ndi deta, gwiritsani ntchito ndondomeko yowonongeka pa kaboni kapena njira iyi yachinsinsi kuti mubwezeretsedwe.

Wonjezerani Mizere Pogwiritsa Ntchito Njira Zowonjezera

Kuphatikizira kwa makiyi a makiyi kuwonjezera mazere ku tsambali ndi:

Ctrl + Shift + "+" (kuphatikizapo chizindikiro)

Zindikirani : Ngati muli ndi kibokosi ndi Number Pad kumanja kwa makina okhazikika, mungagwiritse ntchito chizindikiro + kumeneko popanda chinsinsi cha Shift . Mgwirizano wachinsinsi umangokhala:

Ctrl + "+" (kuphatikizapo chizindikiro)

• Musanawonjezere mzere, mumauza Excel kumene mukufuna kuti yatsopanoyo iikepo posankha woyandikana naye. Izi zingachitenso pogwiritsa ntchito njira yomasulira:

Shift + Spacebar

Excel adzaika mzere watsopano pamwamba pa mzere wosankhidwa.

Kuwonjezera Mzere Womodzi pogwiritsa ntchito Keyboard Shortcut

1. Dinani pa selo mumzere momwe mukufuna mzere watsopano.
2. Lembani ndi kugwiritsira chinsinsi cha Shift pa makiyi
3. Sindikirani ndi kumasula Spacebar popanda kumasula chinsinsi cha Shift .
4. Mzere wonse uyenera kusankhidwa.
5. Dinani ndi kugwira Ctrl ndi Shift mafungulo pa makiyi.
6. Dinani ndi kumasula fungulo "+" popanda kumasula makiyi a Ctrl ndi Shift .
7. Mzere watsopano uyenera kuwonjezedwa pamwamba pa mzere wosankhidwa.

Kuwonjezera Mizere Yambiri Yowonjezera pogwiritsira ntchito Keyboard Shortcut

Mumauza Excel kuti ndi mizere yambiri yapafupi yomwe mukufuna kuwonjezera pa tsambalo posankha nambala yomweyo ya mizere yomwe ilipo.

Ngati mukufuna kukhazikitsa mizere iwiri yatsopano, sankhani mizere iwiri yomwe mukufuna kuti yatsopano ikhalepo. Ngati mukufuna mizere itatu yatsopano, sankhani mizere itatu yomwe ilipo.

Kuwonjezera Mizere Yatsopano Yatsopano ku Mapepala Othandizira

1. Dinani pa selo mumzere momwe mukufuna mizere yatsopano yowonjezera.
2. Lembani ndi kugwiritsira chinsinsi cha Shift pa makiyi.
3. Sindikirani ndi kumasula Spacebar popanda kumasula chinsinsi cha Shift .
4. Mzere wonse uyenera kusankhidwa.
5. Pitirizani kusunga fungulo la Shift .
6. Koperani ndi kumasula makiwo a Up arrow kawiri kuti musankhe mizere iwiri yowonjezera.
7. Dinani ndi kugwira Ctrl ndi Shift mafungulo pa makiyi.
8. Dinani ndi kumasula fungulo "+" popanda kumasula makiyi a Ctrl ndi Shift.
9. Mizere itatu yatsopano iyenera kuwonjezedwa pamwamba pa mizere yosankhidwa.

Wonjezerani Mizere Pogwiritsa Ntchito Mndandanda wa Mndandanda

Zosankha pazenera zamkati - kapena pang'onopang'ono pomwe-menyu - zomwe zingagwiritsidwe ntchito kuwonjezera mizere ku tsamba lomwelo ndilowetsa.

Mofanana ndi njira yachinsinsi pamwambapa, musanandike mzere, mumauza Excel kumene mukufuna kuti yatsopanoyo iikepo posankha mnansi wake.

Njira yosavuta yowonjezera mizera pogwiritsa ntchito masewerawa ndi kusankha mzere wonse mwakudalira mutu wa mzere .

Kuwonjezera Mzere Womodzi ku Pepala Labwino

1. Dinani pamzere wa mzere wa mzere kumene mukufuna mzere watsopano uwonjezere kusankha mzere wonse.
2. Dinani pazithunzi zomwe mwasankha kuti mutsegule menyu.
3. Sankhani Kuika ku menyu.
4. Mzere watsopano uyenera kuwonjezedwa pamwamba pa mzere wosankhidwa.

Kuwonjezera Mizere Yambiri Yowonjezera

Apanso, mumauza Excel mizere yambiri yomwe mukufuna kuwonjezera pa tsambalo posankha nambala yomweyo ya mizere yomwe ilipo.

Kuwonjezera Mizere Yatsopano Yatsopano ku Mapepala Othandizira

1. Mutu wa mzere, dinani ndi kukokera ndi pointer ya mouse kuti muike mizere itatu kumene mukufuna mizere yatsopano yowonjezera.
2. Dinani pazitsulo zomwe mwasankha.
3. Sankhani Kuika ku menyu.
4. Mizere itatu yatsopano iyenera kuwonjezedwa pamwamba pa mizere yosankhidwa.

Chotsani Mizere mu Pulogalamu Yolemba

Kuphatikizira kwachinsinsi kwachinsinsi pochotsa mizere kuchokera pa tsamba lolemba ndi:

Ctrl + "" "(chizindikiro chosasintha)

Njira yosavuta yochotsera mzere ndi kusankha mzere wonse kuti uchotsedwe. Izi zingachitenso pogwiritsa ntchito njira yomasulira:

Shift + Spacebar

Kuchotsa Mzere Womodzi pogwiritsa ntchito Keyboard Shortcut

1. Dinani pa selo mumzere kuti muchotsedwe.
2. Lembani ndi kugwiritsira chinsinsi cha Shift pa makiyi.
3. Sindikirani ndi kumasula Spacebar popanda kumasula chinsinsi cha Shift .
4. Mzere wonse uyenera kusankhidwa.
5. Tulutsani makiyi a Shift .
6. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
7. Dinani ndi kumasula " - " fungulo popanda kumasula makiyi a Ctrl .
8. Mzere wosankhidwa uyenera kuchotsedwa.

Kuchotsa Mizere Yowonjezera pogwiritsira ntchito Keyboard Shortcut

Kusankha mizere yoyandikana pa tsambali kukulola kuti muwachotse zonse mwakamodzi. Kusankha mizere yoyandikana kungapangidwe pogwiritsa ntchito makiyi a muviki pamsakiti mzere woyamba utasankhidwa.

Kuchotsa Mipatu itatu kuchokera ku Worksheet

1. Dinani pa selo mzere pamunsi kumapeto kwa gulu la mizere kuti muchotsedwe.
2. Lembani ndi kugwiritsira chinsinsi cha Shift pa makiyi.
3. Dinani ndi kumasula malo osungira popanda kumasula fayilo la Shift .
4. Mzere wonse uyenera kusankhidwa.
5. Pitirizani kusunga fungulo la Shift .
6. Koperani ndi kumasula makiwo a Up arrow kawiri kuti musankhe mizere iwiri yowonjezera.
7. Tulutsani makiyi a Shift .
8. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
9. Dinani ndi kumasula " - " fungulo popanda kumasula makiyi a Ctrl .
10. Mizere itatu yosankhidwa iyenera kuchotsedwa.

Chotsani Mizere Pogwiritsa Ntchito Mndandanda wa Mndandanda

Chotsatira pazenera zamkati - kapena pang'onopang'ono pomwe-menyu - zomwe zingagwiritsidwe ntchito kuchotsa mzere kuchokera pa tsamba ndi kuchotsa.

Njira yosavuta yochotsera mizera pogwiritsa ntchito makondomu akutsatidwa ndi kusankha mzere wonse mwa kudalira mutu wa mzere.

Kuchotsa Mzere Womodzi ku Pepala Labwino

1. Dinani pamutu wa mzere wa mzere kuti muchotsedwe.
2. Dinani pakanema omwe mwasankha kuti mutsegule mndandanda wa masewera.
3. Sankhani Kuchotsa ku menyu.
4. Mzere wosankhidwa uyenera kuchotsedwa.

Kuchotsa Mipando Yambiri Yowonjezera

Apanso, mizera yambiri yaying'ono ingachotsedwe nthawi yomweyo ngati onse asankhidwa

Kuchotsa Mipatu itatu kuchokera ku Worksheet

Mu mzere wa mutu, dinani ndi kukokera ndi pointer ya mouse kuti muike mizera itatu yoyandikana nayo

1. Dinani pazitsulo zomwe mwasankha.
2. Sankhani Kuchotsa ku menyu.
3. Mizere itatu yosankhidwa iyenera kuchotsedwa.

Kuchotsa Malire Osiyana

Monga momwe tawonetsera pa chithunzi pamwambapa, mzere wosiyana, kapena wosakhala pafupi ukhoza kuchotsedwa nthawi yomweyo poyamba kuwasankha ndi makina a Ctrl ndi mbewa.

Kusankha Mzere Wosiyana

1. Dinani mzere wa mzere wa mzere woyamba kuti uchotsedwe.
2. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
3. Dinani pa mizere yowonjezera mumutu wamutu kuti muwasankhe.
4. Dinani pazitsulo zomwe mwasankha.
5. Sankhani Kuchotsa ku menyu.
6. Mizere yosankhidwa iyenera kuchotsedwa.

Onjezani Ma Columns ku Excel Worksheet

Kuphatikizira kwa makiyi a makina powonjezera zipilala ku tsambali ndi zofanana ndi kuwonjezera mizere:

Ctrl + Shift + "+" (kuphatikizapo chizindikiro)

Zindikirani: Ngati muli ndi kibokosi ndi Number Pad kumanja kwa makina okhazikika, mungagwiritse ntchito chizindikiro + kumeneko popanda chinsinsi cha Shift. Mgwirizano wachinsinsi umangokhala Ctrl + "+".

• Musanawonjezere chingwe, mumauza Excel kumene mukufuna kuti yatsopanoyo iikepo posankha woyandikana naye. Izi zingachitenso pogwiritsa ntchito njira yomasulira:

Ctrl + Spacebar

Excel idzaika ndime yatsopano kumanzere kwa ndime yosankhidwa.

Kuti muwonjezere Khola limodzi pogwiritsa ntchito Keyboard Shortcut

1. Dinani pa selo m'mbali yomwe mukufuna kuti chigawo chatsopano chiwonjezere.
2. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
3. Dinani ndi kumasula Spacebar popanda kumasula makiyi a Ctrl .
4. Mzere wonse uyenera kusankhidwa.
5. Dinani ndi kugwira Ctrl ndi Shift mafungulo pa makiyi.
6. Dinani ndi kumasula " + " popanda kumasula makiyi a Ctrl ndi Shift .
7. Mzere watsopano uyenera kuwonjezeredwa kumanzere kwa gawo losankhidwa.

Kuti muwonjezere Ma Columns Ambiri Ogwiritsira ntchito Keyboard Shortcut

Mumauza Excel kuti pali zingati zatsopano zomwe mukufuna kuwonjezera pa tsambalo posankha nambala yomweyi yomwe ilipo.

Ngati mukufuna kufalitsa zigawo ziwiri zatsopano, sankhani zipilala ziwiri zomwe zilipo kumene mukufuna kuti zatsopano zikhalepo. Ngati mukufuna zigawo zitatu zatsopano, sankhani ma katatu omwe alipo.

Kuwonjezera Zowonjezera Zatsopano Zatsopano ku Worksheet

1. Dinani pa selo m'mbali yomwe mukufuna kuti zipilala zatsopano ziwonjezere.
2. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
3. Dinani ndi kumasula malo osungira popanda kumasula makiyi a Ctrl .
4. Mzere wonse uyenera kusankhidwa.
5. Tulutsani makiyi a Ctrl .
6. Lembani ndi kugwiritsira chinsinsi cha Shift pa makiyi.
7. Sakanizani ndi kumasula makiyi oyenera awiri kuti musankhe mizere iwiri yowonjezera.
8. Dinani ndi kugwira Ctrl ndi Shift mafungulo pa makiyi.
9. Dinani ndi kumasula " + " popanda kumasula makiyi a Ctrl ndi Shift .
10. Zitsulo zitatu zatsopano ziyenera kuwonjezeredwa kumanzere pamitu yosankhidwa.

Onjezani Ma Columns Pogwiritsa Ntchito Mndandanda wa Mndandanda

Chotsatira pazenera zamkati - kapena pang'onopang'ono pomwe-menyu - yomwe idzagwiritsidwa ntchito kuwonjezera zipilala ku tsamba lomwelo ndilowetsa.

Mofanana ndi njira ya chibokosi pamwambapa, musanandikepo colon, mumauza Excel kumene mukufuna kuti yatsopanoyo iikepo posankha woyandikana naye.

Njira yosavuta yowonjezera zikhomo pogwiritsira ntchito makondomu akutsatila ndi kusankha mzere wonse pakhomopo.

Kuwonjezera Phukusi Lokha ku Tsamba Labwino

1. Dinani pa mutu wa mutu wa chigawo kumene mukufuna kuti chigawo chatsopano chiwonjezedwe kuti musankhe kalolo lonse.
2. Dinani pazithunzi zomwe mwasankha kuti mutsegule mndandanda.
3. Sankhani Kuika ku menyu.
4. Mzere watsopano uyenera kuwonjezedwa pamwamba pa gawo losankhidwa.

Kuwonjezera Mizere Yambiri Yamakono

Mofanana ndi mizere, mumauza Excel mazenera angati omwe mukufuna kuwonjezera pa tsambalo posankha nambala yomweyi yomwe ilipo.

Kuwonjezera Zowonjezera Zatsopano Zatsopano ku Worksheet

1. Mu mutu wa mutuwo, dinani ndi kukokera ndi pointer ya mouse kuti muwonetse zipilala zitatu kumene mukufuna kuti zipilala zatsopano ziwonjezere.
2. Dinani kumene pazitsulo zosankhidwa.
3. Sankhani Kuika ku menyu.
4. Mizere itatu yatsopano iyenera kuwonjezeredwa kumanzere kwa zigawo zosankhidwa.

Chotsani Ma Columns ku Excel Worksheet

Kuphatikizira kwachinsinsi kwachinsinsi pochotsa zikhomo kuchokera pa tsamba lolemba ndi:

Ctrl + "" "(chizindikiro chosasintha)

Njira yosavuta yochotsera gawo ndi kusankha mzere wonse kuti uchotsedwe. Izi zingachitenso pogwiritsa ntchito njira yomasulira:

Ctrl + Spacebar

Kuchotsa Phukusi Lokha pogwiritsa Ntchito Keyboard Shortcut

1. Dinani pa selo m'mbali kuti muchotsedwe.
2. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
3. Sindikirani ndi kumasula Spacebar popanda kumasula chinsinsi cha Shift .
4. Mzere wonse uyenera kusankhidwa.
5. Pitirizani kulemba makiyi a Ctrl pa makiyi.
6. Dinani ndi kumasula " - " fungulo popanda kumasula makiyi a Ctrl .
7. Mzere wosankhidwa uyenera kuchotsedwa.

Kuchotsa Mizati Yowonjezera pogwiritsira ntchito Keyboard Shortcut

Kusankha mazenera omwe ali pafupi pa tsambali kukulola kuti muwachotse iwo mwakamodzi. Kusankha mizere yoyandikana ikhoza kuchitidwa pogwiritsa ntchito makiyi a fungulo pa khibhodi pambuyo polemba mzere woyamba.

Kuchotsa Mizati itatu kuchokera ku Worksheet

1. Dinani pa selo muzomwe zili kumapeto kwa gulu la zikhomo kuti zichotsedwe.
2. Lembani ndi kugwiritsira chinsinsi cha Shift pa makiyi.
3. Dinani ndi kumasula malo osungira popanda kumasula fayilo la Shift .
4. Mzere wonse uyenera kusankhidwa.
5. Pitirizani kusunga fungulo la Shift .
6. Sakanikizani ndi kumasula khididi yapamwamba yachitsulo kawiri kuti musankhe mizati iwiri yowonjezera.
7. Tulutsani makiyi a Shift .
8. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
9. Dinani ndi kumasula " - " fungulo popanda kumasula makiyi a Ctrl .
10. Zithunzi zitatu zosankhidwa ziyenera kuchotsedwa.

Chotsani Mazenera Pogwiritsa Ntchito Mndandanda wa Mndandanda

Chotsatira pazenera zamkati - kapena pang'onopang'ono pomwe-menyu - yomwe idzagwiritsidwe ntchito kuchotsa zikhomo kuchokera pa tsamba lochotsa ntchito ndichotsani.

Njira yosavuta yochotsera timapepala pogwiritsa ntchito makondomu akutsatidwa ndi kusankha mzere wonse podalira mutu wa mutuwo.

Kuchotsa Phukusi Lokha ku Tsamba Labwino

1. Dinani pa mutu wa mutu wa ndimeyo kuti muchotsedwe.
2. Dinani pazithunzi zomwe mwasankha kuti mutsegule mndandanda.
3. Sankhani Kuchotsa ku menyu.
4. Mzere wosankhidwa uyenera kuchotsedwa.

Kuchotsa Ma Columns Ambiri Oposa

Apanso, zipilala zozungulira zambiri zingachotsedwe nthawi yomweyo ngati zonse zasankhidwa.

Kuchotsa Mizati itatu kuchokera ku Worksheet

1. Mu mutu wa pamutu, dinani ndi kukoka ndi pointer ya mouse kuti muike pamitu yapafupi pafupi.
2. Dinani kumene pazitsulo zosankhidwa.
3. Sankhani Kuchotsa ku menyu.
4. Zithunzi zitatu zosankhidwa ziyenera kuchotsedwa.

Kuchotsa Mizere Yopatulidwa

Monga momwe tawonetsera pa chithunzi pamwambapa, zigawo zosiyana, kapena zosakhala pafupi zingathe kuchotsedwa nthawi yomweyo poyamba kuzisankha ndi makina a Ctrl ndi mbewa.

Kusankha Mazati Osiyana

1. Dinani pamutu wa mutu wa ndime yoyamba kuti muchotsedwe.
2. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
3. Dinani pa mizere yowonjezera mu mutu wa mutuwo kuti muwasankhe iwo.
4. Dinani pamanja pazitsulo zosankhidwa.
5. Sankhani Kuchotsa ku menyu.
6. Mazere omwe asankhidwa ayenera kuchotsedwa.