Ingabe ufuna ukuvula ispredishithi sakho se-Excel kusuka kuhla lwezinombolo ezithandekayo kube isibonisi esilula kalula? Akukho lutho oludlulisela idatha eluhlaza into into eqondakalayo efana neshadi. Ngenkathi iMicrosoft ishiya amashadi ngokusuka ekukhululweni kwe-Word and PowerPoint yokuqala ye-iPad, kunalokho kulula ukudala ishadi ku-Excel. Ungakwazi ngisho ukukopisha amashadi kusuka ku-Excel bese uwanamathisela ku-Word noma ku-PowerPoint.
Ake siqale.
- Qalisa i-Excel uphinde uvule isipredishithi esisha ukufaka idatha. Uma usebenzisa ispredishithi ekhona, kungadingeka uhlele kabusha idatha ukuze uhambisane neshadi.
- Idatha kufanele ithathe uhlobo lwegridi, noma ngabe unamaritha owodwa kuphela. Kufanele ube ilebula ngakwesokunxele kwegqa ngalinye lemininingwane futhi phezulu kwekholomu ngayinye. Lawa malebula azosetshenziselwa ekwakheni ishadi.
- Uma usulungele ukwakha ishadi lakho, thepha esitokisini sangakwesobunxele segridi yakho yedatha. Kufanele ibe iseli elingenalutho ngaphezu kwamalebula wakho omugqa.
- Ungakwazi ukwandisa ukukhetha izindlela ezimbili: (1) Uma uqala ukuthepha iseli elingenalutho, ungaphakamise umunwe wakho. Esikhundleni salokho, yiphonsa phansi esiteleni lesokudla kwesokudla. Ukukhethwa kuzokwandiswa ngomunwe wakho. Noma (2), ngemuva kokuthinta iseli elingenalutho, iseli lizogqanyiswa ngemibuthano emnyama ngakwesokudla-kwesokunxele nangakwesokudla. Lawa angamahange. Thepha i-anchor engezansi-kwesokudla bese uslayida umunwe wakho esiteleni ngakwesokudla kwesigcawu sakho.
- Manje ukuthi idatha igcizelelwe, thepha "Faka" phezulu futhi ukhethe Amashadi.
- Kukhona amanani amashadi ahlukene atholakalayo avela kumashadi e-bar ukuze athathe amashadi kumashadi wendawo ukuze asakaze amashadi. Zula izigaba bese ukhetha ishadi ofuna ukulidala.
- Uma ukhetha uhlobo lweshadi, ishadi lizofakwa kufasitredishithi. Ungathutha ishadi elizungezile ngokuthepha bese ulihudula esibukweni. Ungasebenzisa futhi amahange (imibuthano emnyama emaphethelweni eshadi) ukuze ushintshe ishadi ngokuthepha futhi ulayishe umunwe wakho.
- Ufuna ukushintsha amalebula? Ukufaka ishadi kungase kungakutholi konke okulungile. Uma ufuna ukushintsha amalebuli, thinta ishadi ukuze ligqanyiswe bese uthepha "Shintsha" kusuka kwimenyu yeThart.
- Ungathandi umumo? Noma nini lapho uthepha ishadi ukuze uliqokomise, imenyu yeshadi ivela phezulu. Ungakhetha "Izakhiwo" ukushintshela kwesinye sezici eziningi ezahlukene. Kukhona nezinketho zokushintsha imibala, isitayela segrafu, noma ngisho nokushintsha uhlobo oluthile lwesigrafu.
- Uma ungathandi umkhiqizo wokugcina, qala futhi. Mane nje uthephe ishadi bese ukhetha "Susa" kwimenyu ukuze ususe ishadi. Qinisekisa igridi futhi ukhethe ishadi elisha.