E-Excel, imingcele yimizila ingezwe emaphethelweni eseli noma iqembu lamaseli.
Izitayela zomugqa ezingasetshenziselwa imingcele zihlanganisa imigqa engashadile, kabili, futhi ngezinye izikhathi ephukile. Ubukhulu bemigqa bungahlukana njengoba kungenziwa umbala.
Amaphethelo afaka izici ezisetshenziselwa ukuthuthukisa ukubukeka kwephepha lakho lokusebenzela . Zingenza kube lula ukuthola nokufunda idatha ethile.
Zingasetshenziselwa ukunaka imininingwane ebalulekile njengemiphumela yamafomula .
Ukwengeza imigqa nemingcele yindlela esheshayo yokufometha ulwazi olubalulekile ku-Excel.
Amanani wekholomu , amabhlogo wedatha , noma izihloko ezibalulekile kanye nezihloko zingenziwa zonke zibonakala ngokungeziwe kwemigqa nemingcele.
Ukwengeza iMingcele Ngokusebenzisa isinqamuleli sekhibhodi
Qaphela: Le nqamuleli ineza umngcele kuya emaphethelweni angaphandle kwilali eyodwa noma ngaphezulu akhethiwe usebenzisa umbala ozenzakalelayo umbala nobukhulu.
Inhlanganisela ebalulekile yokwengeza imingcele yile:
Ctrl + Shift + & (ukhiye we-ampersand)Isibonelo Sendlela Yokufaka Imingcele Ngokusebenzisa isinqamuleli sekhibhodi
- Qinisekisa amaseli obubanzi oyifunayo kushidi lokusebenzela
- Cindezela bese ubamba izinkinobho ze-Ctrl ne-Shift ekhibhodi.
- Cindezela bese ukhulula ukhiye we-ampersand wenombolo (&) - ngaphezu kwenombolo 7 ekhibhodi - ngaphandle kokukhulula okhiye be- Ctrl ne- Shift .
- Amaseli akhethiwe kufanele azungezwe umngcele omnyama.
Ukwengeza Imingcele E-Excel Ukusebenzisa Izinketho Zebhange
Njengoba kuboniswe esithombeni ngenhla, inketho ye-Borders itholakala ngaphansi kwethebhu yaseKhaya yebhebhoni .
- Qinisekisa amaseli obubanzi oyifunayo kushidi lokusebenzela
- Chofoza kuthebhu yaseKhaya yebhebhoni;
- Chofoza kusithonjana seMingcele kwi-ribbon ukuze uvule imenyu ehlehlisayo njengoba kuboniswe esithombeni esingenhla;
- Chofoza uhlobo olufunayo lomngcele kusuka kwimenyu;
- Umngcele okhethiwe kufanele uvele kuzungeze amaseli akhethiwe.
Izinketho zomngcele
Kunezinketho eziningi kakhulu uma kuziwa ekungenizeni nasekufomeni imigqa nemingcele:
- Imingcele ingafakwa kwenye noma zonke izinhlangothi zeseli noma ibhokisi lamaseli;
- Ubukhulu obuhlukene bomugqa bungasetshenziswa;
- izinhlobo ezehlukene zezitayela zitholakalayo;
- kunemibala eminingi ongakhetha kuyo;
- I-Excel's draw borders feature ingasetshenziswa ukudweba imingcele ejikeleze amabhlogo adijithali we-data, njengoba kuboniswe kusibonelo sesithombe.
Imingcele Yokudweba
Njengoba kuboniswe esithombeni, isici seDraw Border sitholakala ngaphansi kweMenyu ye-Borders down-down njengoba kuboniswe esithombeni ngenhla.
Enye inzuzo yokusebenzisa imingcele yokudweba ukuthi akudingeki ukhethe amaseli kuqala. Esikhundleni salokho, uma ukhetho lwemingcele yokudweba imingcele ekhethiwe ingezwa ngokuqondile ephepheni lokusebenzela, njengoba kuboniswe ngakwesokudla kwesithombe.
Ukushintsha umbala womugqa nomugqa wendwangu
Dweba ama-Borders futhi aqukethe izinketho zokushintsha umbala womugqa nesitayela somugqa, okwenza kube lula ukushintsha ukubonakala kwemingcele esetshenziselwa ukugqamisa imigqa ebalulekile yedatha.
Izinketho zesitayela semigqa ikuvumela ukuthi udale imingcele nge:
- imigqa yobukhulu obuhlukahlukene
- imigqa enezinhlamvu eziphawuliwe
- imigqa emibili
Ukusebenzisa iDraw Borders
- Chofoza kuthebhu yaseKhaya yebhebhoni;
- Cindezela inketho ye- Borders kwi-ribbon ukuze uvule imenyu ehlayo;
- Shintsha umbala womugqa kanye / noma isitayela somugqa uma uthanda;
- Chofoza kuDweba iBorder ngaphansi kwemenyu ehlayo;
- I-pointer yegundane ishintsha ipensela - njengoba kuboniswe ngakwesokudla kwesithombe;
- Chofoza kumigqadididi yeselula ngayinye ukuze ungeze imingcele eyodwa kulezi zindawo;
- Chofoza bese uhudula ngesikhombisi ukwengeza imingcele engaphandle kumakhalekhukhwini noma amaseli.
Dweba iBrid Grid
Enye indlela yeDraw Border ukufaka kokubili ngaphandle nangaphakathi kwemingcele kuya kwesinye noma amangqamuzana amaningi ngesikhathi esisodwa.
Ukwenza kanjalo, chofoza uphinde uhudule kuwo wonke amaseli futhi "udwebe igridi yomngcele" ukudala imingcele ezungeze wonke amaseli ayingxenye yokukhethwa.
Misa imigqa yokudweba
Ukuyeka ukudweba imingcele, mane uchofoze okwesibili esithonjana somngcele ku-ribbon.
Uhlobo lokugcina lomngcele osetshenzisiwe lukhunjulwa wuhlelo, noma kunjalo, ngokuchofoza isithonjana semingcele futhi senza leyo modi ibuye isenze.
Imingcele Ehlulekayo
Le nketho, njengoba igama liphakamisa, yenza kube lula ukususa imingcele kusuka kumaseli weshidi lomsebenzi. Kodwa ngokungafani nenketho ye- No Border ukusuka kuhlu olulinganiselwe lwemingcele, ama- Borders Erase akuvumela ukuba ususe imigqa yemingcele ngamunye - ngokuchofoza kuwo.
Imingcele eminingi ingasuswa futhi usebenzisa bese uchofoza.