Momwe Mungagwiritsire Ntchito Pulogalamu Yowonjezera mu Excel

01 a 02

Sinthani Patsamba la Ntchito mu Excel

Kubwezeretsa ndi kubwezeretsa Ma Tabs

Zosintha ziwiri zomwe zimapangitsa kuti zikhale zosavuta kukonzekera ndikuzindikiritsa mapepala ndi deta zomwe zili nazo zimatchulidwanso tsamba lapamwamba ndikusintha mtundu wa tabu lamasewera lomwe liri ndi dzina pansi pa malo ogwira ntchito.

Yongoleranso tsamba la Excel

Pali njira zambiri zowonjezera tsamba la zolemba ku Excel, koma zonse zimaphatikizapo kugwiritsa ntchito mapepala a pepala pansi pa sewero la Excel kapena zosankha zomwe zili Pakhomo labuboni.

Njira 1 - Kugwiritsa ntchito Keyboard Hot Keys:

Zindikirani : Tsinde la Alt siliyenera kugwiritsidwa pansi pomwe makiyi enawo akulimbikitsidwa, monga ndi zidule zina. Chilichonse chimatsindikizidwa ndi kumasulidwa motsatizana.

Chokhazikitsidwa ndi zolembazi ndizoyambitsa malamulo a riboni. Pamene fungulo lomalizira muzotsatira - R - ikulimbikitsidwa ndi kutulutsidwa, dzina lomwe likupezeka pa tsamba la pakali pano kapena yogwira ntchito likuwonetsedwa.

1. Koperani ndi kumasula mwachidule mndandanda wamtundu wotsatira kuti muwonetsetse dzina la pepala logwira ntchito;

Alt + H + O + R

2. Lembani dzina latsopano pa tsamba la ntchito;

3. Koperani fungulo lolowamo lolowera pakamaliza kukonzanso tsamba.

Kusintha Mapepala Othandizira Keyboard

Kusintha kwachibokosi kotsatizana ndiko kusinthana pakati pa mapepala - chifukwa pepala logwira ntchito ndilo limene lidzatchulidwe pogwiritsa ntchito makiyi ophatikizira pamwambapa. Gwiritsani ntchito mfundo zotsatirazi kuti mutsimikize kuti tsamba lovomerezeka limatchedwanso:

Ctrl + PgDn - pita ku pepala kumanja kwa Ctrl + PgUp - kusamukira ku pepala kumanzere

Tsambali Kapepala Kowonongeka

Pepala lothandizira likhoza kutchulidwa podutsa pa pepala lamasamba ndi zosankha ziwiri zotsatira.

Mwachidule 2 - Dinani kawiri pa Tsambali Tsamba:

1. Lembani kawiri pa dzina lomwe liripo pakanema la tsamba la ntchito kuti muwonetsetse dzina lomwe liripo pakabu;
2. Lembani dzina latsopano pa tsamba la ntchito;
3. Lembani fungulo lolowamo mu Enter in the keyboard kuti mutsirize kukonzanso tsamba;
4. Dzina latsopanolo liyenera kuwonetsedwa pa tabu lamasewera.

Njira 3 - Dinani Kumanja Patsamba:

1. Dinani pakanema pa tsamba limene mukufunanso kutchula kuti mutsegule mndandanda;
2. Dinani kuti Yonganinso kuphatikiza pa mndandanda wa menyu kuti muwonetsetse dzina lamasamba lamasamba ;
3. Tsatirani masitepe 2 mpaka 4 pamwambapa.

Zosankha 4 - Pezani Njira Yokwera ndi Mphamvu:

1. Dinani pa tabu la pepala loti lidzatchulidwe kuti likhale pepala logwira ntchito
2. Dinani pa tabu la Home la riboni
3. Dinani pa Fomu ya mtunduyo pa riboni kuti mutsegule menyu otsika pansi
4. Mu gawo la Mapangidwe a Mapepala a menyu, dinani pa Rename Mapepala kuti muike pepala lamasamba pansi pazenera
5. Lembani dzina latsopano pa tsambalo
6. Lembani fungulo lolowamo mu Enter to keyboard

Onani Ma Tsabola Onse M'buku la Ntchito

Ngati bukhuli lili ndi mapepala akuluakulu kapena mpukutu wosakanikirana wapita kale, osati ma pepala onse omwe amawonekera panthawi imodzi.

Kuti athetse vutoli,

1. Ikani pointeru ya mbewa pamtundu wa ellipsis (madontho atatu ofanana) pafupi ndi mpiringidzo wosaphika;
2. Choyimira phokoso chidzasinthira kuvivi la mutu wawiri - monga momwe chikuwonetsedwera pa chithunzi pamwambapa pamene chiri bwino;
3. Lembani ndi kugwira batani lakumanja lamanzere ndikukoka pointer kumanja kuti mukulitse dera la mapepala owonetsera - kapena kumanzere kuti mukulitse mpukutu wopukuta.

Zolemba Zina Zopangira Malemba

Pali zochepa pazomwe mukufuna kukhazikitsa pepala la Excel:

• Dzina silingapitirire malemba 31 m'litali
• Dzina lamasewera silingalephereke
• Zotsatira zotsatirazi sizingagwiritsidwe ntchito pa dzina: \ /? : * [

Kugwiritsa Ntchito Maofesi Othandizira Mayina mu Mafomu Atsulo

Kubwezeretsa pepala sikumangokhala kosavuta kusunga mapepala okhaokha mu buku lalikulu la ntchito, koma kuli ndi phindu lina lopangitsa kuti zikhale zosavuta kumvetsetsa malemba omwe amaphatikizapo mapepala ambiri.

Pamene fomu ikuphatikizidwa ndi selo lochokera ku tsamba lina lolembedwapo dzina lamasewera likuphatikizidwa mu ndondomekoyi.

Ngati maina olembedwa pamasewerawa akugwiritsidwa ntchito - monga Sheet2, Sheet3 - njirayi idzawoneka ngati izi:

= Tsamba 3! C7 + Sheet4! C10

Kupatsa maofesi dzina lofotokozera - monga Maola a May ndi June - Lingathe kupanga chiwerengerochi mosavuta. Mwachitsanzo:

= 'Zowonjezera Zowonjezera'! C7 + 'June Expenses'! C10

02 a 02

Kusintha Kapepala Kapepala

Kusintha Kapepala ka Makapu Ophatikizira

Pofuna kukuthandizani kupeza tsatanetsatane m'mafayilo akuluakulu a spreadsheet, nthawi zambiri zimathandiza kuti makondomu apange ma tapepala omwe ali ndi data.

Mofananamo, mungagwiritse ntchito matepi osiyana kuti musiyanitse pakati pa mapepala omwe ali ndi mfundo zosagwirizana.

Njira ina ndikutenga mawonekedwe a ma tabu omwe amapereka chisonyezero chofulumira pazowonjezereka kwa mapulojekiti - monga zobiriwira zopitirira, ndi zofiira kuti zatha.

Kusintha Kabukhu Kakang'ono ka Tsamba Loyamba la Ntchito

Njira 1 - Kugwiritsa ntchito Keyboard Hot Keys:

Zindikirani : Monga pomanganso tsambalo pogwiritsira ntchito mafungulo otentha, makiyi a Alt sayenera kugwiritsidwa pansi pomwe makiyi enawo akulimbikitsidwa, monga ndi zidule zina. Chilichonse chimatsindikizidwa ndi kumasulidwa motsatizana.

1. Panizani ndi kutulutsana motsatizana motsatizanitsa mitu yotsatirayi kuti mutsegule mtundu wa mtundu womwe uli pansi pa fayilo ya Fayilo pa tsamba lapanyumba la Ribbon:

Alt + H + O + T

2. Posalephera, malo ojambula pamwamba pa ngodya yam'mwamba ya pala - choyera pachithunzi pamwambapa - wasankhidwa. Dinani ndi ndondomeko yamagulu kapena mugwiritsire ntchito makiyi a fungulo pa khibhodi kuti musunthire mtundu wofiira;

3. Ngati mukugwiritsa ntchito makiyi, pindani makiyi a Kulowa pa khididiyi kuti mukwanitse kukonzanso tsambali;

4. Kuti muwone mitundu yambiri, yesani Mfungulo pa Mbokosi kuti mutsegule mtundu wa mtundu.

Zosankha 2 - Dinani Kumanja kwa Tsambali Tsamba:

1. Dinani pakanema pa tsamba limene mukufunanso kuti likhale lopangira mtundu kuti mupange pepala lothandizira ndi kutsegula mndandanda;
2. Sankhani Majambula Achidindo mndandanda wa menyu kuti mutsegule mtundu wa mtundu;
3. Dinani pa mtundu kuti muzisankhe;
4. Kuti muwone mitundu yambiri, dinani pa Zowonjezera Zowonjezera pansi pa mtundu wa pulogalamu kuti mutsegule mtundu wa mtundu wa mtundu.

Zosankha 3 - Pezani Njira Yokwera ndi Mphamvu:

1. Dinani pa tepi la pepala lothandizira kuti litchulidwe kuti likhale pepala yogwira ntchito;
2. Dinani pa tsamba la Home la riboni;
3. Dinani pa Fomu ya mtunduyo pa riboni kuti mutsegule menyu otsika;
4. M'magawo Okonzekera Mapepala a menyu, dinani pajambula la Masamba kuti mutsegule pepala;
5. Dinani pa mtundu kuti muzisankhe;
6. Kuti muwone mitundu yambiri, dinani pa Zowonjezera Zowonjezera pansi pa mtundu wa pulogalamu kuti mutsegule mtundu wa mtundu wa mtundu.

Kusintha Kabukhu Kakang'ono ka Zambiri Zamalonda

Zindikirani: Zonse zomwe mwasankha ma tebulo zidzakhala zofanana.

1. Kusankha makapu oposa limodzi, pezani Ctrl pa makiyi ndipo dinani pa tabu lililonse ndi ndondomeko ya mouse.
   Dinani pamanja pa tsamba limodzi lamasankhidwe kuti mutsegule menyu.
2. Sankhani Majambula Achidindo mndandanda wa menyu kuti mutsegule mtundu wa pepala.
3. Kuti muwone mitundu yambiri, dinani pa Zowonjezera Zowonjezera pansi pa mtundu wa pulogalamu kuti mutsegule Custom Color Palette.

Zotsatira

1. Kusintha mtundu wa tabu pa tsamba limodzi:
   • Dzina lamasewera limatsindika mu mtundu wosankhidwa.
2. Kusintha mtundu wa tabu kwa pepala limodzi loposa:
   • Tsambali yogwira ntchito lamasamba imatsindika mu mtundu wosankhidwa.
   • Ma tabu ena onse apamwamba amaonetsa mtundu wosankhidwa.