Theha sehokelo sa kantle ho Excel

• Etsa sehokelo sa kantle
• Litlhahisoleseding
• Ho lokisa lihokelo

Tšupiso ea kantle ho Excel ke sesupo sa sele (kapa mofuta oa lisele) bukeng e 'ngoe ea mosebetsi. Litšoantšong

ka tlase u bona libuka tse tsoang mafapheng a mararo (Leboea, Bohareng le Boroa).

Etsa sehokelo sa kantle

Ho theha sehokelo sa kantle, latela litaelo tse ka tlase:

1. Bula litokomane tse tharo kaofela.
2. Bukeng ea "Khampani", totobatsa sele B2 ebe o kenya letshwao le lekanang “=”.
3. Ho Advanced tab View (Sheba) tobetsa konopo Fetolela Windows (E-ea fensetereng e 'ngoe) ebe u khetha "North".
4. Bukeng ea "Leboa", totobatsa sele B2 ebe o kenya "+".
5. Pheta mehato ea 3 le ea 4 bakeng sa libuka tsa "Bohareng" le "South".
6. Tlosa matšoao a "$" ka foromo ea sele B2 ebe u kopitsa foromo ena liseleng tse ling. Sephetho:

Litlhahisoleseding

Koala litokomane tsohle. Etsa liphetoho libukeng tsa lefapha. Koala litokomane tsohle hape. Bula faele ea "Company".

1. Ho nchafatsa lihokelo tsohle, tobetsa konopo Numella Content (Kenyelletsa litaba).
2. Ho thibela likhokahano ho nchafatsoa, ​​tobetsa konopo X.

Hlokomela: Haeba u bona temoso e 'ngoe, tobetsa Update (Apdate) kapa U se ke ua Nchafatsa (Se ke oa ntlafatsa).

Ho lokisa lihokelo

Ho bula lebokose la puisano Fetola Lihokelo (Fetola Lihokelo), ho tab Lintlha (Data) karolong Sehlopha sa likhokahano (Mahokelo) tobetsa Fetola letšoao la lihokelo (Fetola lihokelo).

1. Haeba u sa ka ua nchafatsa lihokelo hanghang, u ka li nchafatsa mona. Khetha buka ebe o tobetsa konopo Nchafatsa Litekanyetso (Refresh) ho nchafatsa lihokelo tsa buka ena. lemoha hore boemo (Boemo) fetoha ho OK.
2. Haeba u sa batle ho ntlafatsa lihokelo ka bo eona 'me u sa batle hore litemoso li hlahisoe, tobetsa konopo Molaetsa oa ho qala (Kopo ea ho ntlafatsa lihokelo), khetha khetho ea boraro ebe o tobetsa OK.