Kwiitafile ngenani elikhulu leekholamu, ngokungathandekiyo ukuhambela uxwebhu, kuba ukuba luphuma umda wenqwelomoya, ukuze ubone amagama emigca apho idatha ifakwe khona, kuya kufuneka rhoqo Skrolela iphepha elishiywe, kwaye emva koko ubuyele ngasekunene. Le misebenzi iya kufunda ixesha elingaphezulu. Ke ngoko, ukwenzela ukuba umsebenzisi angenise ixesha namandla akhe, inkqubo ye-Microsoft i-Excel ibonelela ngobuchule bokulungisa iikholamu. Emva kokwenza le nkqubo, inxenye yasekhohlo yetafile apho amagama emigca ahlala emehlweni. Masibone ukuba ungayilungisa njani iikholamu kwisicelo se-Excel.
Qhatha ikholamu kwitafile ekhethekileyo
Xa usebenza ngetafile "ebanzi", unokufuna ukulungisa zombini iikholamu zombini (indawo) ngaxeshanye. Oku kwenziwe ngokoqobo kunqakrazo oluninzi, kwaye i-algorithm ye-algorithm kwangoko kwezi zibini zahlukile kwinqaku elinye.Inketho 1: Ikholamu enye
Ukwenzela ukukhusela ikholamu yasekhohlo engasekhohlo, awungekhe uyifumane ngaphambi kokuba le nkqubo iza kuqondwa, ukuba kufuneka kwenzeke into yokwamkela utshintsho olichaziweyo.
- Yiya kwi-theb ye-tib.
- Yandisa imenyu yemenyu yemenyu.
- Khetha ukhetho lokugqibela kuluhlu lweenketho ezikhoyo - "ukhusele ikholamu yokuqala".
Ukusukela kule nqaku, kunye nescroll scrolls ethe tyaba, iKholamu yayo yokuqala (ngasekhohlo) iya kuhlala ihleli kwindawo emiselweyo.
Inketho 2: Iikholamu ezininzi (indawo)
Kwenzeka ukuba iyimfuneko ukulungisa ngaphezulu kwekholamu enye, oko kukuthi, indawo leyo. Kule meko, kuya kufuneka uqwalasele i-nues enye ebalulekileyo-ungaqaqambisa uluhlu lweekholamu.
- Chaza ikholamu ecaleni kwendawo oceba ukukhusela. Oko kukuthi, ukuba kuyafuneka ukukhusela uluhlu A-c. Yabela oko kuyimfuneko D..
- Yiya kwi-theb ye-tib.
- Cofa kwindawo ethi "Indawo ekhuselekileyo" kwaye ukhethe inqaku elifanayo kulo.
Ngoku inani leekholamu olifunayo lilungiswa kwaye xa likroba itafile, baya kuhlala endaweni yabo - ngasekhohlo.
Bona: Ungayiqinisa njani le ndawo kwiMicrosoft Excel
Ukulahlwa kwendawo erekhodiweyo
Ukuba isidingo sokuqinisa ikholamu okanye iikholamu zinyamalala, kuyo yonke i-theb "ye-theb nganye" yenkqubo ye-Excel, vula "indawo ekhuselekileyo" yemenyu yeqhosha kwaye ukhethe i-Commander Regioner " Iya kusebenza zombini kwinqaku elinye kunye noluhlu.
Ukuqukumbela
Njengoko ubona, kwi-Microsoft Prossar Supersor Supersor, unokulungisa ngokulula enye, ikholamu yasekhohlo engaphezulu okanye uluhlu lwe (ndawo). Bakhuphe loo nto, ukuba imfuno enjalo ivela, ungangokoqobo kunqakrazo ezintathu.