Mokhoa oa ho notlela kapa ho notlolla lisele ho Excel?

Ka linako tse ling ha u batle hore lisele tse ling tsa maqephe a hau a Excel li fetoloe. U ka etsa joalo ka ho ithuta ho notlela kapa ho notlolla lisele ho Excel.

Microsoft Excel e re fa mokhoa o motle oa ho boloka data ea rona ka mokhoa o hlophisitsoeng le o hlophisitsoeng. Empa data ena e ka fetoloa ha e arolelanoa har'a batho ba bang. Haeba u batla ho sireletsa data ea hau liphetohong tsa ka boomo, u ka sireletsa maqephe a hau a Excel ka ho a notlela. Empa, ona ke mohato o fetelletseng oo mohlomong o sa rateheng. Ho e-na le hoo, u ka notlela lisele tse itseng, mela le likholomo. Mohlala, o ka lumella basebelisi ho kenya data e itseng empa ba notlele lisele ka tlhahisoleseling ea bohlokoa. Sehloohong sena, re tla bona mekhoa e fapaneng ea ho notlela kapa notlolla lisele ho Excel.

Litaba[ pata ]

• Mokhoa oa ho notlela kapa ho notlolla lisele ho Excel?
• Mokhoa oa ho notlela lisele tsohle ho Excel?
• Mokhoa oa ho notlela le ho sireletsa lisele tsa motho ka mong ho Excel?
• Mokhoa oa ho notlolla le ho sirelletsa lisele ho Excel Sheet?
• Mokhoa oa ho notlolla Lisele tse khethehileng Leqepheng le Sirelelitsoeng?

Mokhoa oa ho notlela kapa ho notlolla lisele ho Excel?

U ka notlela lakane kaofela kapa ua khetha lisele ka bomong ho latela khetho ea hau.

Mokhoa oa ho notlela lisele tsohle ho Excel?

Ho sireletsa lisele tsohle tse Microsoft Excel , o tlameha feela ho sireletsa leqephe lohle. Lisele tsohle tse ka har'a leqephe li tla sireletsoa hore li se ngoloe ho feta tekano kapa ho hlophisoa ka mokhoa o ikhethileng.

1. Khetha ' Sireletsa Leqephe ' ho tloha botlaaseng ba skrine ka ' Leqephe la Mosebetsi ' kapa ka kotloloho ho tsoa ho' Lethathamo la Tabo ' ho Fetola sehlopha .

2. The Sireletsa Leqephe ' lebokose la lipuisano lea hlaha. U ka khetha ho sireletsa leqephe la hau la Excel ka password kapa u tlohele ' password sireletsa leqephe la hau la Excel ' lebala le se nang letho.

3. Khetha liketso ho tsoa lethathamong leo u batlang ho le lumella ho lakane ea hau e sirelelitsoeng ebe o tobetsa 'OK'.

4. Haeba u khetha ho kenya phasewete, ' Netefatsa Phasewete ' lebokose la puisano le tla hlaha. Ngola phasewete ea hau hape ho phethela tšebetso.

Hape bala: Mokhoa oa ho tlosa password ho Excel File

Mokhoa oa ho notlela le ho sireletsa lisele tsa motho ka mong ho Excel?

O ka notlela lisele tse le 'ngoe kapa letoto la lisele ka ho latela mehato e ka tlase:

1. Khetha lisele kapa libaka tseo u batlang ho li sireletsa. U ka e etsa ka toeba kapa ka ho sebelisa linotlolo tsa shift le motsu ho mantsoe a hau a bohlokoa. Sebelisa le Tobetsa konopo ea Ctrl le mouse ho kgetha lisele le mela e sa bapaneng .

2. Haeba u batla ho notlela kholomo(li)le (li)lomo kaofela le(me) mela, u ka li khetha ka ho tobetsa kholomo kapa tlhaku ea mola. U ka boela ua khetha litšiea tse ngata tse haufi ka ho tobetsa mouse ka ho le letona kapa ho sebelisa konopo ea shift le mouse.

3. U ka boela ua khetha lisele tse nang le liforomo feela. Ho tab ya Lehae, tobetsa ho Sehlopha sa ho hlophisa eaba ' Fumana ebe o Khetha '. Tobetsa ho Eya ho Special .

4. Puisanonglebokose, khetha ea Mekhoa kgetho ebe o tobetsa OK .

5. Hang ha u se u khethile lisele tseo u li batlang ho notleloa, tobetsa Ctrl + 1 mmoho. ‘ Lisele tsa Fomata ' lebokose la puisano le tla hlaha. U ka tobetsa ka ho le letona ho lisele tse khethiloeng ebe u khetha khetho ea Format cell ho bula lebokose la puisano.

6. E-ea ho ' Tshireletso 'me u hlahlobe' notletsoe 'khetho. Tobetsa ho OK , mme mosebetsi wa hao o phethilwe.

Hlokomela: Haeba u leka ho notlela lisele letlapeng la Excel le sirelelitsoeng pele, u tla hloka ho notlolla lakane pele ebe u etsa ts'ebetso e kaholimo. Wena e ka notlela kapa ea notlolla lisele ho Excel ka liphetolelo tsa 2007, 2010, 2013, le 2016.

Mokhoa oa ho notlolla le ho sirelletsa lisele ho Excel Sheet?

O ka notlolla leqephe lohle ka kotloloho ho notlolla lisele tsohle ho Excel.

1. Tobetsa ho ' Leqephe le sa Sireletsang ' ka ' Lethathamo la tlhahlobo ' ho liphetoho sehlopha kapa tobetsa khetho ka ho tobetsa ka ho le letona ho Leqephe tab ya.

2. Hona joale u ka etsa liphetoho leha e le life ho data e liseleng.

3. U ka boela ua notlolla lakane u sebelisa ‘ Format Cells' lebokose la puisano.

4. Khetha lisele tsohle tse leqepheng la Ctrl + A . Ebe o tobetsa Ctrl + 1 kapa tobetsa ka ho le letona ebe u khetha Lisele tsa Fomata . Ka ' Tshireletso ' tab ea lebokose la puisano la Lisele tsa Format, hlakola ' Notletsoe ' kgetho ebe o tobetsa OK .

Hape Bala: Lokisa Excel e emetse sesebelisoa se seng ho phethela ketso ea OLE

Mokhoa oa ho notlolla Lisele tse khethehileng Leqepheng le Sirelelitsoeng?

Ka linako tse ling u ka 'na ua batla ho hlophisa lisele tse itseng leqepheng la Protected Excel. Ka ho sebelisa mokhoa ona, o ka notlolla lisele tse le 'ngoe leqepheng la hau u sebelisa senotlolo:

1. Khetha lisele kapa libaka tseo u lokelang ho li notlolla ka har'a leqephe le sirelelitsoeng ka password.

2. Ka ‘ Hlahloba ' tab, tobetsa ho' Lumella basebelisi ho fetola Ranges 'khetho. U hloka ho notlolla leqephe la hau pele ho fumana khetho.

3. Lebokose la puisano la ‘Lumella basebedisi ho Fetola Mekhahlelo’ lea hlaha. Tobetsa ho ' E ncha 'khetho.

4. A Range e Ncha ' lebokose la lipuisano le hlaha ka Sehlooho, E bua ka lisele, le Lethathamo la password lebala.

5. Tšimong ea Sehlooho, fana ka lebitso sebakeng sa hau sa marang-rang . Ka ' E bua ka sele ' tšimong, ngola mefuta e mengata ea lisele. E se e ntse e na le lisele tse khethiloeng ka ho sa feleng.

6. Tlanya password sebakeng sa Password ebe o tobetsa OK .

7. Tlanya phasewete hape ho ' Netefatsa Phasewete ' lebokose la puisano ebe o tobetsa OK .

8. Ho tla eketsoa sebaka se secha . U ka latela mehato hape ho theha mekhahlelo e mengata.

9. Tobetsa ho ' Sireletsa Leqephe ' konopo.

10. Ngola phasewete fensetereng ea 'Sireletsa Sheet' bakeng sa leqephe lohle le khetha diketso o batla ho dumella. Tobetsa OK .

leshome le motso o mong. Tlanya phasewete hape fensetereng ea netefatso, 'me mosebetsi oa hau o felile.

Hona joale, leha lakane ea hau e sirelelitsoe, lisele tse ling tse sirelelitsoeng li tla ba le boemo bo eketsehileng ba tšireletso 'me li tla notleloa feela ka password. U ka boela ua fana ka phihlello ea mabala ntle le ho kenya phasewete nako le nako:

ngoe.Ha u etsa lethathamo, tlanya ho ' Litumello ' kgetho pele.

2. Tobetsa ho Eketsa konopo fensetereng. Kenya mabitso a basebelisi ho ' Kenya mabitso a ntho eo o tla e khetha ’ lebokose. U ka ngola lebitso la mosebelisi la motho joalo ka ha le bolokoa sebakeng sa hau sa marang-rang . Tobetsa ho OK .

3. Joale bolela tumello ea mosebelisi e mong le e mong tlasa ' Mabitso a sehlopha kapa a basebelisi 'me u hlahlobe khetho ea Lumella. Tobetsa ho OK , mme mosebetsi wa hao o phethilwe.

E khothalelitsoe:

• Mokhoa oa ho fapanyetsana likholomo kapa mela ho Excel
• Joang ho fetolela faele ea Excel (.xls) ho faele ea vCard (.vcf)?
• Fetola ka Potlako lipakeng tsa Lipampiri tsa Mosebetsi ho Excel
• Mokhoa oa ho Lokisa Lits'oants'o tsa Whatsapp Tse sa Bontšang Ka Gallery

Tsena e ne e le mekhoa e fapaneng eo u ka e etsang notlela kapa notlolla lisele ho Excel. Ho tseba ho sireletsa lakane ea hau ho bohlokoa haholo ho e sireletsa liphetohong tsa kotsi. U ka sireletsa kapa ua sireletsa lisele ka har'a leqephe la Excel ka nako e le 'ngoe kapa ua khetha mofuta o itseng. U ka boela ua fa basebelisi ba itseng monyetla oa ho kena ka password kapa ntle le eona. Latela mehato e ka holimo ka hloko, 'me ha ua lokela ho ba le bothata.

Pete ke sengoli se phahameng sa basebetsi ba Cyber ​​S. Pete o rata lintho tsohle tsa theknoloji hape ke DIYer ea chesehang pelong. O na le lilemo tse leshome tsa boiphihlelo ba ho ngola mokhoa-tos, likarolo, le litataiso tsa theknoloji inthaneteng.