Momwe Mungasankhire Mzere, Mizati, kapena Ma Worksheets mu Excel

Pogwiritsa ntchito mndandanda wa maselo - monga mizere yonse, mazamu, matebulo a deta, kapena ngakhale mapepala onse, zimapangitsa kuti zikhale zosavuta komanso zosavuta kuchita ntchito zingapo ku Excel monga:

• Kusintha mazenera aakulu ndi mizere yapamwamba .
• Kusunga ndondomeko ndi mizere ya deta .
• Kuika zikhomo ndi mizere yatsopano pa tsamba .
• Kugwiritsa ntchito kupanga ma nombolo .

Mmene Mungasankhire Mipando Yonse Msewu Wopangira ndi Zowonjezera Zake

Mtsinje wachinsinsi wowonetsera mzere wonse pa tsambali ndi:

Shift + Spacebar

Pogwiritsa ntchito njira zofikira Njira Yopangira Ntchito

1. Dinani pa selo lamasewero pamzere kuti musankhidwe kuti mupange selo yogwira ntchito .
2. Lembani ndi kugwiritsira chinsinsi cha Shift pa makiyi.
3. Dinani ndi kumasula makina a Spacebar pa khibhodi popanda kumasula chinsinsi cha Shift .
4. Tulutsani makiyi a Shift .
5. Maselo onse mu mzere wosankhidwa ayenera kuwonetsedwa - kuphatikizapo mutu wa mzere .

Kusankha Mazira Owonjezera

Sankhani mizere yowonjezera pamwamba kapena pansi pa mzere wosankhidwa

1. Lembani ndi kugwiritsira chinsinsi cha Shift pa makiyi.
2. Gwiritsani zitsulo zam'mwamba kapena zotsitsa pa makina kuti musankhe mizere yowonjezera pamwamba kapena pansi pa mzere wosankhidwa.

Sankhani Mizere Ndi Mouse

Mzere wonse ukhoza kusankhidwa ndi:

1. Ikani pointeru ya mbewa pa nambala ya mzere mu mutu wa mzere - choyimira phokoso chikusintha ku mzere wakuda ukulozera kumanja momwe zikusonyezedwera mu chithunzi pamwambapa.
2. Dinani kamodzi ndi batani lamanzere .

Mizere yambiri ingasankhidwe ndi:

1. Ikani pointeru ya mouse pamzere wa mzere mu mutu wa mzere.
2. Dinani ndikugwiritsira ntchito batani lamanzere .
3. Kokani chofufumitsa cha mouse pamwamba kapena pansi kuti musankhe nambala yomwe mukufuna.

Mmene Mungasankhire Mizere Yonse M'ndandanda Yopangira ndi Zowonjezera Zake

Mgwirizano wambiri womwe umagwiritsidwa ntchito posankha gawo lonse ndi:

Ctrl + Spacebar

Pogwiritsa ntchito njira zofikira Njira yolembera

1. Dinani pa selo lamasewera lamasewera m'ndandanda kuti musankhidwe kuti mupange selo yogwira ntchito.
2. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
3. Dinani ndi kumasula makina a Spacebar pa khibhodi popanda kumasula chinsinsi cha Shift .
4. Tulutsani makiyi a Ctrl .
5. Maselo onse omwe ali mudongosolo losankhidwa ayenera kuwonetsedwa - kuphatikizapo mutu wa mutuwo.

Kusankha Maulendo Owonjezera

Sankhani zipilala zina kumbali zonse za gawo losankhidwa

1. Lembani ndi kugwiritsira chinsinsi cha Shift pa makiyi.
2. Gwiritsani ntchito mafungulo odzanja lakumanzere kapena kumanja pa khibhodi kuti musankhe mazamu ena owonjezera kumbali zonse zazomwe zili pamwambazo.

Sankhani Ma Colonni Ndi Mouse

Mzere wonse ukhoza kusankhidwa ndi:

1. Ikani pointeru ya mbewa pa kalata ya mndandanda mu mutu wa mndandanda - pointer ya mouse imasintha ku mzere wakuda ukulozera pansi monga momwe tawonetsera pa chithunzi pamwambapa.
2. Dinani kamodzi ndi batani lamanzere .

Mizere yambiri ingasankhidwe ndi:

1. Ikani pointeru yamagulu pa kalata ya mndandanda mu mutu wa mutuwo.
2. Dinani ndikugwiritsira ntchito batani lamanzere .
3. Kokani chofufumitsa cha khosi kumanzere kapena kuti muthe kusankha mizere yomwe mukufuna.

Mmene Mungasankhire Maselo Onse mu Pulogalamu Yopangira Zolemba ndi Zowonjezera Zake

Pali makonzedwe awiri ofunika pakusankha maselo onse pa tsamba ndi:

Ctrl + A

kapena

Ctrl + Shift + Spacebar

Pogwiritsa ntchito njira zofiira Njira Zosankha Maselo Onse mu Worksheet

1. Dinani pamalo opanda kanthu a pepala - gawo lomwe mulibe deta m'maselo oyandikana nawo.
2. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
3. Koperani ndi kumasula kalata A fungulo pa kibokosi.
4. Tulutsani makiyi a Ctrl .

Maselo onse omwe ali mu worksheet ayenera kusankhidwa.

Sankhani Maselo Onse mu Tsamba Labwino pogwiritsira ntchito Butsani "Sankhani Onse"

Kwa iwo omwe amasankha kusagwiritsa ntchito kamphindi, batani la Onse Onse ndi njira ina mwamsanga musankhe maselo onse pa tsamba.

Monga momwe zasonyezera pa chithunzi pamwambapa, Sankhani Zonse ziri pa ngodya yapamwamba kumapeto kwa tsamba limene pamapeto pake mitu ya mzere ndi mutu wa mutuwo ukumana.

Kusankha maselo onse omwe ali pakali pano, dinani kamodzi pa batani Onse .

Mmene Mungasankhire Maselo Onse M'ndondomeko ya Data mu Excel ndi Zowonjezera Zake

Maselo onse omwe ali ndi deta kapena deta yosakanikirana angasankhidwe mwachangu pogwiritsa ntchito makina oyendetsa. Pali njira ziwiri zofunika zomwe mungasankhe kuchokera:

Ctrl + A

kapena

Ctrl + Shift + Spacebar

Kuphatikizira kwachindunji ichi ndizitsulo zomwe zimagwiritsidwa ntchito posankha maselo onse pa tsamba.

Kusankha Mbali Zosiyanasiyana za Deta ndi Zolemba

Malinga ndi momwe deta ikuyendera, kugwiritsa ntchito makina achitsulo pamwambapa idzasankha kuchuluka kwa deta.

Ngati chochititsa chidwi cha selo chiri mkati mwa deta yodalirika ndi:

• Dinani Ctrl + A kamodzi - Excel amasankha maselo onse okhala ndi deta.

Ngati Mndandanda wa deta wapangidwa ngati tebulo ndipo uli ndi mzere wotsatira womwe umakhala ndi menyu otsika monga momwe taonera pa chithunzi pamwambapa.

• Onetsani Ctrl + A kachiwiri - Excel amasankha mzere wotsatira.

Dera losankhidwa likhoza kupatsidwanso kuti liphatikize maselo onse pa tsamba.

• Onetsetsani Ctrl + A kachitatu - Excel amasankha pepala lonse.

Momwe Mungasankhire Maofesi Ambiri Ambiri mu Excel Ndi Zowonjezera Zake

Sizingatheke kusuntha pakati pa mapepala mu bukhu la ntchito pogwiritsa ntchito njira yomasulira, koma mukhoza kusankha mapepala ambiri omwe ali pafupi ndi njira yachinsinsi.

Kuti muchite zimenezi, onjezerani chinsinsi cha Shift pazitsulo ziwiri zomwe zili pamwambapa. Chomwe mumagwiritsa ntchito chimadalira ngati mukusankha mapepala kumanzere kapena pomwepo pakanema.

Kusankha masamba kumanzere:

Ctrl + Shift + PgUp

Kusankha masamba kumanja:

Ctrl + Shift + PgDn

Kusankha Mapepala Ambiri Pogwiritsa Ntchito Mouse ndi Kinkibodi

Kugwiritsira ntchito mbewa pamodzi ndi makina a kiyibodi kuli ndi mwayi umodzi pogwiritsira ntchito kambokosi kokha - kumakupatsani mwayi wosankha mapepala omwe sali pafupi monga momwe amachitira pa chithunzi pamwambapa komanso pafupi.

Chifukwa chosankha ma sheet of paper ndi awa:

• Kusintha mtundu wa tabu wa tsamba .
• Kuika mapepala ambiri atsopano .
• Kubisa ma sheet .

Kusankha Mapepala Ambiri Ambiri

1. Dinani pa tsamba limodzi la pepala kuti muzisankhe.
2. Dinani ndi kugwira Chifungulo cha Shift pa makiyi.
3. Dinani pazowonjezera zina zapafupi ndizitsamba kuti muwoneke.

Kusankha Mapepala Ambiri Osadziwika

1. Dinani tsamba limodzi la pepala kuti muzisankhe.
2. Dinani ndi kugwira Ctrl key pa makiyi.
3. Dinani pazowonjezera zamapepala kuti muwoneke.