Xa usebenza kwinkqubo ye-Excel, kusoloko kuyimfuneko ukongeza imigca emitsha etafileni. Kodwa, ngelishwa, abanye abasebenzisi abayazi indlela yokwenza izinto ezilula ezilula. Kuyinyani, kuya kufuneka kuqatshelwe ukuba lo msebenzi uneminye imigibe ". Masibone ukuba ungayifaka njani umtya kwiMicrosoft Excel.
Faka imitya phakathi kwemiqolo
Kuya kufuneka kuqatshelwe ukuba inkqubo yokufakwa komgca omtsha kwiinguqulelo zanamhlanje zenkqubo ye-Excel ayinanto yanto yanto.
Ke, vula itafile ofuna ukongeza umtya. Ukufaka umtya phakathi kwemigca ngokucofa iqhosha lemouse ekunene kuyo nayiphi na umgca womtya, esiceba ukufaka into entsha. Kwimenyu yemeko evula, cofa ukuze "uncamathisele ...".
Kwakhona, kukho ukubakho kokufakwa ngaphandle kokubiza imenyu yemeko. Ukwenza oku, cofa nje kwikhibhodi Iqhosha lebhodi yezitshixo "Ctrl +".
Ibhokisi yencoko yababini ivulwa, enika sifaka itafile yeselfowuni kunye ne-Shift, iiseli ezihamba ngasekunene, ikholamu, kunye nomtya. Sibeka iswitshi kwisikhundla "somtya", kwaye ucofe iqhosha "Kulungile".
Njengoko ubona, umgca omtsha kwiNkqubo ye-Microsoft Excel yongezwa ngempumelelo.
Ukufaka imitya ekupheleni kwetafile
Kodwa yintoni omele uyenze ukuba ufuna ukufaka iseli hayi phakathi kwemigca, kodwa yongeza umtya ekupheleni kwetafile? Emva kwayo yonke loo nto, ukuba usebenzisa le ndlela ingentla, umgca ongezelelweyo awuyi kubandakanywa etafileni, kodwa uya kuhlala ngaphandle kwemida yayo.
Ukwenzela ukukhuthaza itafile phantsi, khetha umtya wokugqibela wetafile. Kwikona yayo esezantsi, kusenziwa umnqamlezo. Ndiyikhuphe kwimigca emininzi njengoko kufuneka sandisa itafile.
Kodwa, njengoko sibona, zonke iiseli ezisezantsi zisenziwa kunye nedatha egcwalisiweyo kwiseli yamama. Ukususa le datha, khetha iiseli ezisandula ukusekwa, kwaye ucofe iqhosha lemouse lasekunene. Kwimenyu yemeko evelayo, khetha into "ecacileyo".
Njengoko ubona, iiseli zicocwa, kwaye zikulungele ukuzalisa idatha.
Kuyimfuneko ukuqaphela ukuba le ndlela ifanelekile kuphela ukuba akukho luhlu lwezinto ezisezantsi etafileni.
Ukwenza itafile ye-smart
Kodwa, ilungele ngakumbi ukuyila, ebizwa ngokuba yiyo, "itafile ebalaseleyo". Oku kungenziwa kube kanye, kwaye emva koko ungakhathazeki ukuba uhlobo oluthile lomgca xa ukongeza akungeni kwimida yetafile. Le theyibhile iya kolulwa, ngaphandle, yonke idatha enegalelo kuyo ayizukuphuma kwiifomula ezisetyenziswa etafileni, ephepheni nasekwincwadi xa iyonke.
Ke, ukuze kudale "itafile enobuchule", sabela zonke iiseli ekufuneka zingene kuzo. Kwithebhu yasekhaya, cofa kwi "fomathi njengeTheyibhile" iqhosha. Kuluhlu lweetayile ezikhoyo, sikhetha isitayile osibona sikhethe kakhulu. Ukwenza "itafile efunekayo", ukhetho lwendlela ethile ayinamsebenzi.
Emva kokuba isitayile sikhethiwe, ibhokisi yencoko yababini ivulwa, apho uluhlu lweeseli ezikhethwe ngu-US zichaziwe, ngenxa yoko anifuni kwenza uhlengahlengiso. Cinezela iqhosha "Kulungile".
"Itafile e-Smart" ilungile.
Ngoku, ukongeza umtya, cofa kwiseli apho umtya uya kwenziwa khona. Kwimenyu yemeko, khetha i "Faka itheyibhile engezantsi" kwinto.
Intambo yongezwa.
Umtya phakathi kwemigca ungongezwa ngokucinezela "i-CTRL +" iqhosha eliphambili. Andifanelanga ukuba ungene kwenye into ngeli xesha.
Yongeza umtya ekupheleni kwetafile elumkileyo ngeendlela ezininzi.
Ungavuka kwisisele sokugqibela somgca wokugqibela, kwaye ucofe kwikhibhodi Iqhosha le-tabe (i-tab).
Kwakhona, unokuphakama isikhombisi kwikona esezantsi yeseli yokugqibela, kwaye uyikhuphe.
Ngeli xesha, iiseli ezintsha ziya kuzaliswa zizinto ezingenakuqala, kwaye aziyi kufuneka zicocwe kwidatha.
Kwaye ungangenisa naziphi na idatha phantsi komqolo apha ngezantsi kwetafile, kwaye iya kubandakanywa kwitafile.
Njengoko ubona, ukongeza iiseli kwitafile ye-Microsoft inokuba ngeendlela ezahlukeneyo, kodwa ukuze kungabikho ngxaki ukongeza, ngaphambili, kungcono ukwenza ifomathi.