Kwi-Excel, imida imida ifakwe kwimida yeseli okanye iqela leeseli.
Izitayela zomgca ezingasetyenziselwa imida zibandakanya imigca engatshatanga, ephindwe kabini, nakwezinye izikhathi. Ubunzima bomgca bunokuhluka njengoko kunako umbala.
Imijelo ifomathiza izixhobo ezisetyenziselwa ukuphucula ukubonakala kwephepha lakho lokusebenzela . Zingenza kube lula ukufumana nokufunda idatha ethile.
Zingasetyenziselwa ukubeka ingqwalasela kwizinto ezibalulekileyo ezifana neziphumo zefomula .
Ukongeza imigca kunye nemida kuyindlela esheshayo yokufomatha ulwazi olubalulekileyo kwi-Excel.
Amanani ekholomu, iibhloko zeedata , okanye izihloko ezibalulekileyo kunye nezihloko ziyakwenziwa ngokubonakalayo ngokwongezwa kwemida kunye nemida.
Ukongeza iMida-fayile usebenzisa Iqhosha eliKhobhodi
Qaphela: le mfutshane yongeza umngcele kwimida yangaphandle yesinye okanye ezinye iiseli ezikhethiweyo usebenzisa umgca wemiqolo engagqibekanga kunye nobukhulu.
Intlangano ebalulekileyo yokongeza imida ngu:
Ctrl + Shift + & & (i-ampersand key)Umzekelo Wendlela Yokufaka Imida Yomgca usebenzisa Iqhosha elifutshane lekhibhodi
- Gqamisa iiseli eziluhlu ezifunwayo kwiphepha lokusebenzela
- Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi.
- Cinezela kwaye ukhulule inombolo yam ampersand (&) - ngaphezu kwenombolo 7 kwikhibhodi - ngaphandle kokukhulula iifayile zeCtrl kunye ne- Shift .
- Iiseli ezikhethiweyo mazizungezwe ngumda omnyama.
Ukongeza iMida e-Excel usebenzisa i-Ribbon Options
Njengoko kuboniswe kumfanekiso ongentla, ikhetho leMida lifumaneka phantsi kwethebhu yaseKhaya yebhebhoni .
- Gqamisa iiseli eziluhlu ezifunwayo kwiphepha lokusebenzela
- Cofa kwiThebhu yasekhaya yerbhoni;
- Cofa kwi icon ye Borders kwi ribhoni ukuvula imenyu ehlayo njengoko kuboniswa kumfanekiso ongentla;
- Cofa kwindlela efunwayo yomda ukusuka kwimenyu;
- Umda okhethiweyo ufanele uvele ngeenxa zeeseli ezikhethiweyo.
Izinketho zeMida
Kukho iindlela ezininzi zokukhetha xa kuzibandakanya ukongeza kunye neendlela zokufomatha kunye nemida:
- Imida ingafakwa kwenye okanye kumacala onke eseli okanye kwibloko yeeseli;
- Uluhlu oluhlukeneyo lwemizila lunokusetyenziswa;
- iintlobo zeendlela ezikhoyo;
- kukho imibala emininzi yokukhetha kuyo;
- Inkcazo yomda we-Excel ingasetyenziselwa ukudweba imida ngokujikeleza izithintelo zedatha ezingafaniyo, njengoko kuboniswe kumzekelo wesithombe.
Ukudweba iMida
Njengoko kuboniswe kumfanekiso, uphawu lweDraw Border lufumaneka kwindawo ephantsi kweMida yokuhla kweMida njengoko kuboniswe kumfanekiso ongentla.
Enye inzuzo yokusebenzisa imida yokudweba kukuba akuyimfuneko ukukhetha iiseli kuqala. Endaweni yoko, xa ukhetho lwemida yokudweba imida ekhethiweyo iyakongezwa ngqo kwiphepha lokusebenzela, njengoko kuboniswe kwicala lasekunene lomfanekiso.
Ukutshintsha Umgca weMbala kunye neSitayela seMpawu
Dweba i-Borders iqulethe iinketho zokutshintsha umbala womgca kunye nesitayela somgca, okwenza kube lula ukutshintsha ukubonakala kwemida ebetyenziswe ukugqamisa ibhloko ebalulekileyo yeedatha.
Izinketho zesitayela zendlela ekuvumela ukudala imida nge:
- imigca ehlukeneyo
- imigca echaziweyo kunye edibeneyo
- imigca emibini
Ukusebenzisa iMida yeBhodi
- Cofa kwiThebhu yasekhaya yerbhoni;
- Cofa kwi- Borders option kwi-ribbon ukuvula imenyu ehlayo;
- Shintsha umbala womgca kunye / okanye isitayela somgca ukuba ufuna;
- Cofa kwiDraw Border ngaphantsi kwemenyu ehlayo;
- I-pointer ye mouse iguqula kwipencilisi - njengoko kuboniswe kwicala lasekunene lomfanekiso;
- Cofa kwiigalari zeefowuni ngamnye ukuze ungeze imida eminye kule ndawo;
- Cofa uze uhudule kunye nesilathisi ukuze ungeze imida yangaphandle kwiseli okanye kuseli.
Dweba umgca weGrid
Enye inketho yeDraw Border idibanisa ngaphandle nangaphakathi kwemida ukuya kwelinye okanye ngaphezulu kweeseli ngexesha elinye.
Ukwenza njalo, nqakraza uze udonse kwiiyunithi uze "uthathe igridi yomda" ukudala imida malunga nawo onke amaseli ayingxenye yokukhethwa.
Yeka udweba imida
Ukuyeka umda wokudweba, nqakraza okwesibini kwisithonjana somda kwi-ribbon.
Uhlobo lokugqibela lomda osetyenziswayo lukhunjulwa yinkqubo, nangona kunjalo, ngokuchofoza uphawu lweemida kwakhona luyakwenza loo mode ibuye iyenze kwakhona.
Sula iMida
Olu khetho, njengoko igama libonisa, yenza kube lula ukususa imida ukusuka kwiiseli zomsebenzi. Kodwa ngokungafani neNombolo yeBorder ngaphandle kwoluhlu lwemida ephantsi, i- Erase Borders ikuvumela ukuba ususe imida yomda ngamnye - ngokuziqhafaza.
Imida emininzi ingasuswa kwakhona usebenzisa ucofa uze udonse.