Pogwiritsa ntchito njira yochepa ya Excel kuwonjezera Ma Worksheets

Ndani ankadziwa kuti kunali kosavuta kuchita?

Monga momwe mungathere zinthu zambiri za Excel, pali njira zambiri zoika pepala limodzi kapena angapo mu bukhu lomwe likupezekapo.

Nazi malangizo a njira zitatu zosiyana:

1. Pogwiritsa ntchito makina achingwe pa makiyi.
2. Pogwiritsa ntchito mbewa ndi tsamba la pepala.
3. Pogwiritsa ntchito njira zomwe zili pa tsamba la Home la Ribbon .

Ikani Watsopano Worksheet Pogwiritsa Ntchito Chidule Chosewera

Pali kwenikweni makonzedwe awiri a makiyi a kuyika tsamba latsopano la Excel:

Shift + F11
kapena
Alt + Shift + F1

Mwachitsanzo, kuyika pepala limodzi ndi Shift + F11:

1. Dinani ndi kugwira Chifungulo cha Shift pa makiyi.
2. Limbikitsani ndi kumasula makiyi a F11 - omwe ali pamwamba pa mzere wa nambala pa kibodibodi.
3. Tulutsani makiyi a Shift .
4. Pepala latsopano lamasewera lidzalowetsedwa ku bukhu la ntchito yamakono kumanja kwa masamba onse omwe alipo.
5. Kuwonjezera maofesi angapo akupitiriza kusindikiza ndi kumasula filo F11 pamene akugwiritsira ntchito Shift key.

Yesetsani Maofesi Ambiri Amagwiritsira Ntchito Chophatikizira Chophimba

Kuti muwonjezere mapepala ambiri pa nthawi imodzi pogwiritsa ntchito njira zapamwamba zachitsulo, muyenera choyamba kuwonetsa chiwerengero cha ma tepi omwe akupezekapo kuti muuze Excel kuti mapepala atsopano ayenela kuwonjezerani asanayambe kugwiritsa ntchito njira yachinsinsi

Zindikirani: Ma tepi omwe ali osankhidwa ayenera kukhala pafupi ndi wina ndi mzake kuti njirayi igwire ntchito.

Kusankha mapepala angapo kungatheke ndi chinsinsi cha Shift ndi mbewa kapena ndi imodzi mwazidulezi:

Ctrl + Shift + PgDn - amasankha mapepala kumanja.
Ctrl + Shift + PgUp - amasankha mapepala kumanzere.

Mwachitsanzo, kuyika makalata atatu atsopano:

1. Dinani pa tepi limodzi lamasamba mu bukhu la ntchito kuti muliwonetse izo.
2. Dinani ndi kugwira Ctrl + Shift mafungulo pa kambokosi.
3. Koperani ndi kumasula foni ya PgDn kawiri kuti musonyeze mapepala awiriwo kumanja - mapepala atatu ayenera kufotokozedwa tsopano.
4. Tsatirani malangizo pamwambapa kuti muike masamba pogwiritsa ntchito Shift + F11.
5. Zatsopano zitatu zamasamba ziyenera kuwonjezeredwa ku bukhu la ntchito kumanja kwa masamba onse omwe alipo.

Onetsani Maofesi Atsopano a New Excel Pogwiritsa Ntchito Mouse ndi Ma Tsabola

Kuti muwonjezere pepala limodzi la ntchito pogwiritsa ntchito mbewa, dinani pa Chizindikiro Chatsamba Chapafupi chomwe chili pambali pazithunzi zam'munsi pamsewu wa Excel, monga momwe tawonetsera pa chithunzi pamwambapa.

Mu Excel 2013, chithunzi chatsopano ndicho chizindikiro chowonetsera monga momwe chikusonyezedwera pa chithunzi choyamba pamwambapa. Mu Excel 2010 ndi 2007, chithunzicho ndi chithunzi cha pepala lokhala ndi zolembera koma adakali pafupi ndi mapepala omwe ali pansi pazenera.

Tsamba latsopanoli limayikidwa kumanja kwa shee yogwira ntchito .

Yesetsani Maofesi Ambiri Amagwiritsa Ntchito Masamba A Mapepala ndi Mouse

Ngakhale kuti n'zotheka kuwonjezera maofesi ambiri pokhapokha ponyani kawirikawiri pazithunzi zatsopano, chinthu china ndi:

1. Dinani pa tsamba limodzi la pepala kuti muzisankhe.
2. Dinani ndi kugwira Chifungulo cha Shift pa makiyi.
3. Dinani pazowonjezera zapafupi zapafupi kuti muzitsindikize izo - onetsani chiwerengero chomwecho cha mapepala amapepala ngati mapepala atsopano omwe angawonjezere.
4. Dinani pamanja pa tsamba limodzi lomwe mwasankha kuti mutsegule Insert dialog box.
5. Dinani pa chithunzi cha Worksheet muwindo la bokosi la dialog.
6. Dinani OK kuti muwonjezere mapepala atsopano ndi kutseka bokosi la dialog.

Maofesi atsopano adzawonjezeredwa kumanja kwa masamba onse omwe alipo.

Ikani New Worksheet Pogwiritsa Ntchito Mphutsi

Njira ina yowonjezera tsamba latsopano ndi kugwiritsa ntchito njira Yowonjezera yomwe ili pa tabu la Home la Ribbon:

1. Dinani pa tabu la Home la riboni.
2. Dinani pa chithunzi Cholembera kuti mutsegule masewera otsika a zosankha.
3. Dinani pa Pezani Tsamba kuti muwonjezere pepala latsopano kumanzere kwa pepala logwira ntchito.

Yesetsani Maofesi Ambiri Amagwiritsa Ntchito Mphutsi

1. Tsatirani masitepe 1 mpaka 3 pamwamba kuti musankhe nambala yomweyo ya mapepala ngati mapepala atsopano omwe mungawonjezere.
2. Dinani pa tabu la Home la riboni.
3. Dinani pa chithunzi Cholembera kuti mutsegule masewera otsika a zosankha.
4. Dinani pa Pezani Tsamba kuti muwonjezere mapepala atsopano kumanzere kwa pepala logwira ntchito.