Okuqukethwe
Kulo mhlahlandlela uzofunda futhi ukwazi ukufunda ukufihla amakholomu ku-Excel 2010-2013. Uzobona ukuthi ukusebenza kwe-Excel okujwayelekile kokufihla amakholomu kusebenza kanjani, futhi uzofunda nokuthi ungawaqoqa kanjani amakholomu futhi uwahlukanise ngamaqoqo usebenzisa “Ukuqoqa".
Ukwazi ukufihla amakholomu ku-Excel kuyasiza kakhulu. Kungaba nezizathu eziningi zokungavezi ingxenye ethile yethebula (ishidi) esikrinini:
- Amakholomu amabili noma ngaphezulu adinga ukuqhathaniswa, kodwa ahlukaniswa ngamanye amakholomu amaningana. Isibonelo, ungathanda ukuqhathanisa amakholomu A и Y, futhi ngenxa yalokhu kulula kakhulu ukuzibeka eceleni. Ngendlela, ngaphezu kwalesi sihloko, ungase ube nesithakazelo esihlokweni Ungamisa kanjani izifunda ku-Excel.
- Kunamakholomu asizayo amaningana anezibalo ezimaphakathi noma amafomula angadida abanye abasebenzisi.
- Ungathanda ukucasha emehlweni okuhlola noma uvikele ekuhleleni amafomula athile abalulekile noma ulwazi lomuntu siqu.
Qhubeka ufunda ukuze ufunde ukuthi i-Excel ikwenza kanjani kusheshe futhi kube lula ukufihla amakholomu angafuneki. Ngaphezu kwalokho, kulesi sihloko uzofunda indlela ethokozisayo yokufihla amakholomu usebenzisa “Ukuqoqa", okuvumela ukuthi ufihle futhi ubonise amakholomu afihliwe ngesinyathelo esisodwa.
Fihla amakholomu akhethiwe ku-Excel
Ingabe ufuna ukufihla ikholomu eyodwa noma ngaphezulu etafuleni? Ingabe ikhona indlela elula yokwenza lokhu:
- Vula ishidi le-Excel bese ukhetha amakholomu ofuna ukuwafihla.
Ithiphu: Ukuze ukhethe amakholomu angasondelene, wamaka ngokuchofoza inkinobho yegundane engakwesokunxele ngenkathi ubambe ukhiye Ctrl.
- Chofoza kwesokudla kwenye yamakholomu akhethiwe ukuze uveze imenyu yokuqukethwe bese ukhetha Fihla (Fihla) ohlwini lwezenzo ezitholakalayo.
Ithiphu: Kulabo abathanda izinqamuleli zekhibhodi. Ungafihla amakholomu akhethiwe ngokuchofoza Ctrl + 0.
Ithiphu: Ungathola iqembu Fihla (Fihla) kuRibhoni Yemenyu Ikhaya > Amaseli > Framework > Fihla futhi ubonise (Ikhaya > Amaseli > Ifomethi > Fihla futhi Ungafihli).
Voila! Manje ungakwazi ukushiya kalula kuphela idatha edingekayo ukuze ubuke, futhi ufihle okungadingekile ukuze bangaphazamisi emsebenzini wamanje.
Sebenzisa ithuluzi elithi "Iqembu" ukuze ufihle noma ubonise amakholomu ngokuchofoza okukodwa
Labo abasebenza kakhulu ngamatafula bavame ukusebenzisa ikhono lokufihla nokubonisa amakholomu. Kukhona elinye ithuluzi elenza umsebenzi omuhle ngalo msebenzi - uzowazisa! Leli thuluziUkuqoqa“. Kwenzeka ukuthi eshidini elilodwa kunamaqembu amaningana angahlangene amakholomu adinga ukufihlwa noma ukuboniswa ngezinye izikhathi - futhi akwenze ngokuphindaphindiwe. Esimweni esinjalo, ukuqoqana kuwenza ube lula umsebenzi.
Uma uqoqa amakholomu, ibha evundlile ivela ngaphezu kwawo ukuze ibonise ukuthi yimaphi amakholomu akhethiwe ukuze aqoqwe futhi angafihlwa. Eduze kwedeshi, uzobona izithonjana ezincane ezikuvumela ukuthi ufihle futhi ubonise idatha efihliwe ngokuchofoza okukodwa nje. Ukubona izithonjana ezinjalo eshidini, uzoqonda ngokushesha ukuthi amakholomu afihliwe akuphi nokuthi yimaphi amakholomu angafihlwa. Kwenziwa kanjani:
- Vula ishidi le-Excel.
- Khetha amaseli ozowafihla.
- Cindezela Umcibisholo othi Shift+Alt+Wesokudla.
- Ibhokisi lengxoxo lizovela Ukuqoqa (Iqembu). Khetha Amakholamu (Amakholomu) bese uchofoza OKukuqinisekisa ukukhetha.
Ithiphu: Enye indlela eya ebhokisini lengxoxo elifanayo: Idatha > Group > Group (Idatha > Iqembu > Iqembu).
Ithiphu: Ukuze ukhiphe iqembu, khetha ububanzi obuqukethe amakholomu aqoqwe bese uchofoza Umcibisholo othi Shift+Alt+Left.
- Ithuluzi «Ukuqoqa» izokwengeza izinhlamvu zesakhiwo esikhethekile eshidini le-Excel, elizobonisa kahle ukuthi yimaphi amakholomu afakwe eqenjini.
- Manje, ngayinye ngayinye, khetha amakholomu ofuna ukuwafihla, kanye nokucindezela ngakunye Umcibisholo othi Shift+Alt+Wesokudla.
Qaphela: Ungaqoqa amakholomu ancikene kuphela. Uma ufuna ukufihla amakholomu angasondelene, kuzodingeka udale amaqembu ahlukene.
- Ngokushesha nje lapho ucindezela inhlanganisela yokhiye Umcibisholo othi Shift+Alt+Wesokudla, amakholomu afihliwe azoboniswa, kanye nesithonjana esikhethekile esinophawu oluthi “-»(okuncane).
- Ukuchofoza ku susa izofihla amakholomu, futhi “-' izophenduka '+“. Ukuchofoza more izobonisa khona manjalo wonke amakholomu afihlwe kuleli qembu.
- Ngemva kokuqoqa, izinombolo ezincane zivela ekhoneni eliphezulu kwesokunxele. Zingasetshenziselwa ukufihla nokubonisa wonke amaqembu ezingeni elifanayo ngesikhathi esisodwa. Isibonelo, kuthebula elingezansi, ngokuchofoza inombolo 1 izofihla wonke amakholomu abonakala kulo mfanekiso, futhi ngokuchofoza inombolo 2 izofihla amakholomu С и Е. Lokhu kuyasiza kakhulu uma udala ukulandelana kanye namaleveli amaningi okuqoqa.
Yilokho kuphela! Ufundile ukusebenzisa ithuluzi ukufihla amakholomu ku-Excel. Ngaphezu kwalokho, ufunde ukuhlanganisa nokukhipha amakholomu eqembu. Sithemba ukuthi ukwazi la maqhinga kuzokusiza wenze umsebenzi wakho ojwayelekile ku-Excel ube lula kakhulu.
Uphumelele nge-Excel!