Iindlela ezi-3 zokutshintsha iWebhu yeWebhu yeHlabathi ye-Excel

Imibala yeTeb ingakunceda uhlale uhlelekile ngaphakathi kwipredishithi

Ukukunceda ufumene ulwazi oluthile kwiifayile ezinkulu zepredishithi, kudla ngokuba luncedo kumgaqo wemibala kwiithebhu zephepha lomsebenzi ngamnye oqukethe idatha ehambelanayo. 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.

Ezi zikhetho ezintathu zokutshintsha umbala wephepha lomxholo wephepha lokusebenzela elilodwa kwincwadi yokusebenzela:

• Ukusebenzisa izitshixo zekhibhodi.
• Ukuchofoza ngokuchanekileyo kwiphepha leshidi (mhlawumbi indlela elula).
• Ukusebenzisa ukhetho lwethebhu kwi-Ribbon.

Tshintsha i-Tab ye-Worksheet Tab Ubalala usebenzisa ii-Keyboard Keys okanye iMouse

Ikhefu 1 - Ukusebenzisa iiKhendi eziKhetele eziKhetele:

Qaphela : I-Alt iqhosha ngokulandelelana ngezantsi akufanele igcinwe phantsi ngelixa ezinye iitshixo zicinezelwe, njengakwizinye iinqamlezo zekhibhodi. Icandelo ngalinye lixinekile kwaye likhutshwe ngokulandelelana.

Okokusetyenzwa kwesi shintsho kusebenze ilayibhoni. Emva kokuba ukhiye wokugqibela ulandelelwano - i-T - icinezele kwaye ikhutshwe, umbala wepeyinti wokutshintsha umbala wethebhu yoluhlu uvuliwe.

1. Cofa kwithebhu yokusebenzela ukuze wenze iphepha elisebenzayo - okanye sebenzisa iifomaththi ezilandelayo zekhibhodi ukuze ukhethe iphepha lokusebenzela elifunwayo:

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

2. Cinezela kwaye ukhulule ngokulandelelana inhlanganisela eyintloko elandelayo ukuvula iphalethi yombala ephantsi kwekhefu yefomati kwikhebhu yasekhaya yerbhoni :

Alt + H + O + T

3. Ngokungagqibekanga, umgca webala lombala wethebhu okhoyo ugqityiwe (ujikelezwe ngumda we-orange). Ukuba umbala wethebhu awuzange utshintshwe ngaphambili le nto iya kuba mhlophe. Cofa nge mouse ye mouse okanye sebenzisa izitshixo zitshixo kwikhibhodi ukuhambisa ukugqwesa kumbala oyifunayo kwi palette;

4. Ukuba usebenzisa izitshixo zitshixo, cofa iqhosha lokungena kwikhibhodi ukugqiba utshintsho lombala;

5. Ukubona imibala emininzi, cinezela ikhi ye M ekwibhodibhodi ukuvula umbala wemibala yebala.

Inketho yesi-2 - Cofa iqhosha kwiTebhu leTekethi:

1. Cofa iqhosha kwisithuba sephepha lokusebenzela ofuna ukuphinde umbala ukuze wenze iphepha elisebenzayo kwaye uvule imenyu yomongo;

2. Khetha Umbala weTeb kwiluhlu lwemenyu ukuvula ipalayini yombala;

3. Cofa kumbala ukuba ukhethe;

4. Ukubona imibala emininzi, nqakraza kwiiMbala eziMbala ngaphantsi kombala wepeyinti ukuvula ipalayini yombala wesiko.

Indlela 3 - Finyelela kwi-Ribbon Option ngeMouse:

1. Cofa kwiphepha lephepha lokusebenzela eliza kuthethwa kabusha ukuze lenze iphepha elisebenzayo;

2. Cofa kwikhaya lasekhaya lasebhanini;

3. Cofa kwiKhowudi yefomathi kwi-Ribbon ukuvula imenyu ehlayo;

4. Kwicandelo lamaHlathi okuHlanganisa kwimenyu, nqakraza kwi- Tab yombala ukuze uvule umbala wepeyinti;

5. Cofa kumbala ukuba ukhethe;

6. Ukubona imibala emininzi, nqakraza kwiiMbala eziMbala ngaphantsi kwepalayini yombala ukuze uvule umbala wemibala yombala.

Ukutshintsha Umbala weTebhu weeMibhalo ezininzi

Ukutshintsha umbala wethebhu wephepha kumaphepha amaninzi asebenzayo kufuna ukuba onke amashishini akhethwe phambi kokusebenzisa enye yeendlela ezichazwe ngasentla.

Iimakhishithi ezikhethiweyo zinokubambisana - ngokulandelana komnye nomnye, ezinjengamaxwebhu, amabini, amathathu okanye amaphepha amaphepha anokukhethwa, njengamaxwebhu amane kunye nesithandathu.

Zonke iithebhu zomsebenzi ezikhethiweyo ziya kuba ngumbala ofanayo.

Ukukhetha iifayile ezisebenzayo

1. Cofa kwiphepha lephepha lokusebenzela elisekupheleni kwesigxina seliqela ukuba litshintshwe ukuze lenze iphepha elisebenzayo.

2. Gcina phantsi iqhosha leShift kwikhibhodi.

3. Cofa kwiphepha lephepha lokusebenzela kwicala elifanelekileyo leqela - zonke iifayile eziphakathi kwamaphepha okuqala nokuphela kufuneka zikhethwe.

4. Ukuba amanqaku amaninzi akhethwe ngephutha, nqakraza kwiphepha lokugqibela elichanekileyo - kunye nefayile yeShift isacinezelwe - ukukhethwa kwee-worksheets ezingafunekiyo.

5. Sebenzisa enye yezindlela ezikhankanywe ngasentla ukutshintsha umbala wethebhu kuwo onke amaphepha ekhethiweyo.

Ukukhetha amaphepha okusebenzela ngamnye

1. Cofa kwithebhu yephepha lokusebenzela lokuqala ukwenza iphepha elisebenzayo;

2. Gcina ikhi ye Ctrl kwibhodibhodi uze uqhosha kwiithebhu zazo zonke iifomthi zokusebenzela ukuba zitshintshwe - azidingeki ukuba zenze iqela elithintekayo - njengoko kuboniswe ngamakhishithi amane kunye nesithandathu kumfanekiso ongentla;

3. Ukuba iphepha likhethwa ngephutha, nqakraza okwesihlandlo sesibini - kunye nekhi ye Ctrl isacinezela - ukuyikhetha;

4. Sebenzisa enye yezindlela ezikhankanywe ngasentla ukutshintsha umbala wethebhu kuwo onke amaphepha ekhethiweyo.

Imigaqo Yemibala YeThabhu

Xa imibala yecatshulwa yefayile ishintshiwe, imigaqo ye-Excel ilandelayo ekuboniseni imibala yombhalo yile:

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