Indlela yokuQamba kwakhona iWindows Worksheet kwi-Excel

01 ka 02

Qamba kabusha iWindows Worksheet kwi-Excel

Ukuqamba kabusha nokubuyisela iiTebhu zokuSebenza

Izinguqu ezibini ezenza kube lula ukuhlela kunye nokuchonga amaxwebhu kunye neenkcukacha eziqulethweyo kufuneka ziqambe kwakhona iphepha lokusebenzela kwaye ziguqulwe umbala wethebhu yomsebenzi oqulethe igama phantsi kweendawo zomsebenzi.

Ukuqamba kabusha i-Excel Worksheet

Kukho iindlela ezininzi zokuqamba kwakhona iphepha lokusebenzela kwi-Excel, kodwa zonke zibandakanya ukusebenzisa iithebhu ezisezantsi phantsi kwesikrini se-Excel okanye iinketho eziseKhaya lithebhu yebhanethi .

Ikhefu 1 - Ukusebenzisa iiKhendi eziKhetele eziKhetele:

Qaphela : I- Alt ikhiye ayifuni ukuba ibanjwe phantsi ngelixa ezinye iitshixo zixinzezelwe, njengokuba kukho ezinye iinqamlezo zekhibhodi. Icandelo ngalinye lixinekile kwaye likhutshwe ngokulandelelana.

Okokusetyenzwa kwesi shintsho kusebenze ilayibhoni. Emva kokuba ukhiye wokugqibela ngokulandelelana - i-R - icinezele kwaye ikhutshwe, igama langoku kwiphepha leshidi lephepha elikhoyo okanye elisebenzayo ligqitywa.

1. Cinezela kwaye ukhulule ngokulandelelana le nxu lumfayile elandelayo ukugqamisa igama lephepha elisebenzayo;

Alt + H + O + R

2. Thayipha igama elitsha kwiphepha lokusebenzela;

3. Cofa iqhosha lokungena kwikhibhodi ukugqiba ukuqamba kabusha iphepha lokusebenzela.

Ukutshintsha iiWebhu ezisebenzayo Iqhosha elifutshane leKhobhodi

Inqamulelo yebhodi yebhodi ehambelanayo kukutshintshana phakathi kwamaphepha-misebenzi - ekubeni iphepha elisebenzayo liza kuthiwa liza kusetyenziswa inhlanganisela yentloko engenhla. Sebenzisa oku kudibanisa okubalulekileyo ukuqinisekisa ukuba iphepha lokusebenzela elichanekileyo liyaqanjwa ngokuthi:

Ctrl + PgDn - tshintshela kwiphepha elisekunene Ctrl + PgUp - tshintshela kwiphepha ngakwesobunxele

Iphepha leTebhu Ukuqhayisa kwakhona iinketho

Iphepha lokusebenzela lingaqanjwa ngokuqakraza kwiphepha leshidi ngeendlela ezimbini ezilandelayo.

Inketho yesi-2 - Cofa kabini kwiTebhu yeTekethi:

1. Cofa kabini kwigama langoku kwiphepha lokusebenzela lokubonisa igama langoku kwithebhu;
2. Thayipha igama elitsha kwiphepha lokusebenzela;
3. Cinezela ukhiye wokungena kwikhibhodi ukugqiba ukuqamba kabusha iphepha lokusebenzela;
4. Igama elitsha kufuneka libonwe kwithebhu yomsebenzi.

Ikhethi 3 - Ukunene nqakraza Ithebhu yeTekethi:

1. Ukucofa ngakwesokudla kwiphepha lephepha lokusebenzela ofuna ukuqamba kwakhona ukuvula imenyu yomongo;
2. Cofa kwiQonga lomncedisi ukugqamisa igama langoku lephepha lomsebenzi;
3. Landela amanyathelo 2 ukuya ku-4 ngasentla.

Ikhetho 4 - Finyelela kwi-Ribbon Option ngeMouse:

1. Cofa kwithebhu kwiphepha lokusebenzela eliza kuthethwa kabusha ukuze lenze iphepha elisebenzayo
2. Cofa kwiThebhu yasekhaya yerbhoni
3. Cofa kwiKhowudi yefomathi kwidibhoni ukuvula imenyu ehlayo
4. Kwiphepha leShedyuli ye - Organize yemenyu, nqakraza kwakhona Qamba kwakhona i-Sheet ukugqamisa ithebhu kwiphepha leskrini
5. Thayipha igama elitsha kwiphepha lokusebenzela
6. Cinezela ukhiye wokungena kwikhibhodi ukugqiba ukuqamba kabusha iphepha lokusebenzela

Jonga onke Amathebhu eTekethi kwiWindows Workbook

Ukuba incwadi yencwadana iqulethe inani elikhulu lamaphepha okanye i-bar yokuprola eqhelekileyo ngaphambili, ingeye yonke ithebhu yamaphepha mhlawumbi ibonakala ngexesha elithile-ngakumbi kuba njengoko amagama amaphepha afumana ixesha elide, kunjalo na amathebhu.

Ukulungisa le meko,

1. Beka isikhombisi semouse phezu kwe- ellipsis ebonakalayo (amachaphaza amathathu).
2. I-pointer ye mouse izakuguqula kwisicatshulwa esiphezulu esiphambili-njengoko kuboniswe kumfanekiso ongentla xa uchanekile ngokufanelekileyo;
3. Cinezela kwaye ubambe iqhosha lasekhohlo le mouse kwaye udibanise isilathisi ngakwesokudla ukukhulisa indawo yecwecwe lamaphepha ukuze uboniswe - okanye ngakwesobunxele ukuze ukwandise ibha yomqulu.

I-Excel Worksheet Igama leZithintelo

Kukho imithintelo embalwa xa kuziwa ngokuqamba kabusha iphepha lokusebenzela lase Excel:

• Igama alikwazi ukudlula iibali ezingama-31 ubude
• Igama lephepha lokusebenzela alikwazi ukushiywa libala
• Abalinganiswa abalandelayo abanakusetyenziswa kwigama: \ /? : * [

Ukusebenzisa amagama omsebenzi kwiifomula ze-Excel

Ukuqamba kabusha iphepha lokusebenzela akukwenze kube lula ukugcina ithrekhi yamaphepha ngamnye kwincwadi yokusebenzela enkulu, kodwa inenzuzo eyongeziweyo yokwenza kube lula ukuqonda amafomula afana nama-worksheet amaninzi.

Xa ifomula ibandakanyela iselferensi yeseli ukusuka kwiphepha elihlukileyo lomsebenzi igama lomsebenzi lifakiwe kwifom.

Ukuba amagama asetshenzisiweyo asebenzayo - afana neSheet2, iSheet3 - ifomu iya kujonga into enje:

= I-Sheet3! C7 + Sheet4! C10

Ukunika iifishthi zamaphepha igama elichazayo- njengeeMali zeMeyi kunye neendleko zeJuni - zinokukwenza ukuba ifomula ikwazi ukuyiqonda lula. Umzekelo:

= 'Iindleko zemihla ngemihla'! C7 + 'Iindleko zeJuni'! C10

02 we 02

Ukutshintsha i-Tab Sheet Colors

Utshintsho lweTebhu yeTebhu yoHlelo lweMbala

Ukukunceda ufumene ulwazi oluthe ngqo kwiifayile ezinkulu zepredishithi, kudla ngokuba luncedo kwimikhodi yombala iithebhu zeesekhsi zomsebenzi ngamnye ezineenkcukacha ezihambelanayo.

Ngokufanayo, ungasebenzisa iithebhu ezinemibala eyahlukileyo ukuze uhlukanise phakathi kweemakhishithi ezineenkcukacha ezingahambelaniyo.

Enye inketho kukudala inkqubo yemibhobho yesibhaso esinika izikhombisi ezibonakalayo ngokukhawuleza njengendlela yokugqiba iiprojekthi - ezifana nokuluhlaza okuqhubekayo kunye nobomvu ukugqitywa.

Ukutshintsha Umbala weThabhu weWindows Worksheet

Ikhefu 1 - Ukusebenzisa iiKhendi eziKhetele eziKhetele:

Qaphela : Njengoko ngokuqamba kabusha iphepha lokusebenzela usebenzisa izitshixo ezitshisayo , i- Alt ayifuni ukuba ibanjwe phantsi ngelixa ezinye iitshixo zixinekile, njengezinye iifutshane zekhibhodi. Icandelo ngalinye lixinekile kwaye likhutshwe ngokulandelelana.

1. Cinezela kwaye ukhulule ngokulandelelana le nxalenye yentloko elandelayo ukuvula ipalayini yombala ephantsi kwekhefu yefomathi kwiTable yasekhaya yerbhoni:

Alt + H + O + T

2. Ngokungagqibekanga, isikwere sombala kwikhoneni eliphezulu lasekhohlo lepaletti - emhlophe kumfanekiso ongentla - ukhethwe. Cofa nge mouse yomnxeba okanye sebenzisa izitshixo zitshixo kwikhibhodi ukuhambisa ukugqwesa kumbala oyifunayo;

3. Ukuba usebenzisa izitshixo zitshixo, cofa iqhosha lokungena kwikhibhodi ukugqiba ukuqalisa kwakhona iphepha lokusebenzela;

4. Ukubona imibala emininzi, cinezela ikhi ye M ekwibhodibhodi ukuvula ipalayini yombala wesintu.

Inketho yesi-2 - Cofa iqhosha kwiTebhu leTekethi:

1. Cofa ngokukhawuleza kwithebhu yesikhewu somsebenzi ofuna ukuphinde umbala ukuze wenze iphepha elisebenzayo kwaye uvule imenyu yomongo;
2. Khetha Umbala weTab kwiluhlu lwemenyu ukuvula ipalayini yombala;
3. Cofa kumbala ukuba ukhethe;
4. Ukubona imibala emininzi, nqakraza kwiiMbala eziMbala ngaphantsi kombala wepeyinti ukuvula ipalayini yombala wesintu.

Indlela 3 - Finyelela kwi-Ribbon Option ngeMouse:

1. Cofa kwithebhu kwiphepha lokusebenzela eliza kuthethwa kwakhona ukuze lenze iphepha elisebenzayo;
2. Cofa kwiThebhu yasekhaya yerbhoni;
3. Cofa kwiKhowudi yefomathi kwidibhoni ukuvula imenyu ehlayo;
4. Kwiphepha leShedyuli ye - Organize kwimenyu, qhosha kwi- Tab Umbala ukuze uvule umbala wepeyinti;
5. Cofa kumbala ukuba ukhethe;
6. Ukubona imibala emininzi, nqakraza kwiiMbala eziMbala ngaphantsi kombala wepeyinti ukuvula ipalayini yombala wesintu.

Ukutshintsha Umbala weTebhu weeMisebenzi ezininzi

Qaphela: Zonke iithebhu zomsebenzi ezikhethiweyo ziya kuba ngumbala ofanayo.

1. Ukukhetha itekisi engaphezulu kwesinye sephepha lokusebenzela, ubambe iqhosha le Ctrl kwibhodibhodi uze uqakraza kwithebhu nganye kunye ne-mouse pointer.
   Ukucofa ngakwesokudla kwenye iithebhu zokusebenzela ezikhethiweyo ukuvula imenyu ehlayo.
2. Khetha Umbala weTeb kwiluhlu lwemenyu ukuvula ipalayini yombala.
3. Ukubona imibala emininzi, nqakraza kwiMbala engaphezulu kwi-palette yambala ukuze uvule i-Custom Color Palette.

Iziphumo

1. Ukutshintsha umbala wethebhu kwiphepha elilodwa lomsebenzi:
   • Igama lomsebenzi lugqityiweyo kumbala okhethiweyo.
2. Ukutshintsha umbala wethebhu kwiphepha lokusebenzela elilodwa:
   • Ithebhu yomsebenzi osebenzayo icacisiwe kumbala okhethiweyo.
   • Zonke ezinye iithebhu zomsebenzi zibonisa umbala okhethiweyo.