E le ho thibela liphetoho tse sa lebelloang kapa ka boomo ho likarolo tse itseng kahare kapa lipampiring , Excel e na le lisebelisoa tsa ho sireletsa likarolo tse ling tsa likarolo tse ka sebelisoang kapa ntle le password.
Ho sireletsa dintlha ho tswa ho phetoho ya Excel sheetsheet ke mehato e mmedi.
- Ho koala kapa ho bula lisele kapa lintho tse itseng tse kang lichate kapa li-graphics, leqepheng la lipampiri.
- Ho sebelisa kemiso ea Protect Sheet - ho fihlela mohato oa 2 o qetile, likarolo tsohle tsa lipampiri le data li kotsing ea ho fetoha.
Tlhokomeliso : Ho sireletsa likarolo tsa lipampiri ha li lokela ho ferekanngoa le ts'ireletso ea password ea lebala-bala, e fanang ka boemo bo phahameng ba ts'ireletso 'me e ka sebelisoa ho thibela basebedisi ho bula feshene ka ho feletseng.
Mohato oa 1: Tlosa / Tlosa Melelo ho Excel
Ka ho feletseng, lisele tsohle tse hlahang ho Excel li hlakile. Sena se etsa hore ho be bonolo haholo ho sireletsa dintlha tsohle le ho etsa moralo ka leqepheng le le leng feela ka ho sebelisa kgetho e sireletsang letlapa.
E le ho sireletsa boitsebiso maqepheng ohle a libuka, kgetho ea tšireletso e tlameha ho sebelisoa ho lekhako ka leng ka bomong.
Ho bula lisebelisoa tse khethehileng tsa lisebelisoa tsa tumello tse lokelang ho etsoa liseleng tsena ka mor'a hore khetho ea polokelo ea lihlahisoa / ea libuka e sebelisoe.
Lisele li ka buloa ka khetho ea Cell Cell. Khetho ena e sebetsa joaloka sesebelisoa sa ho itokolla-se na le bobeli feela kapa maemo - ON kapa OFF. Kaha lisele tsohle li qalile ho kenngoa pampiring ea mosebetsi, ho tobetsa khetho e koala lisele tsohle tse khethiloeng.
Lisele tse ling tse sebetsaneng le leqephe li ka 'na tsa siuoa e le hore boitsebiso bo bocha bo ka kenngoa kapa bo teng boitsebiso bo fetohileng.
Lisele tse nang le litlhaloso kapa lintlha tse ling tsa bohlokoa li bolokiloe e le hore hang ha khetho ea polokelo ea lisebelisoa / mosebetsi e sebelisitsoe, lisele tsena li ke ke tsa fetoloa.
Mohlala: Tlosa li-cellele ho Excel
Setšoantšong se ka holimo, tšireletso e sebelisitsoe liseleng. Mehato e ka tlase e amanang le mohlala oa lipampiri setšoantšong se ka holimo.
Mohlala ona:
- Lisele tse I6 ho J10 li 'nile tsa kooloa ho lumella hore data e kenyelletsoe kapa e hlophisoe ha ho hlokahala.
- Lisele tse I10 le J10, tse nang le mekhoa ea ho bala chelete eohle, li siiloe li koetsoe.
- Khetho ea ts'ireletso e sirelelitsoe bakeng sa leqephe lena la mosebetsi.
Mehato ea ho koala / ho bula lisele:
- Totobatsa lisele tsa I6 ho J10 ho li khetha.
- Tlanya tabeng ea lapeng .
- Khetha mofuta oa Fomati ka lekareche ho bula lenane le theoha.
- Tobetsa ho Kgetha Cell e kgetho tlasa lenaneng.
- Lisele tse totobetseng I6 ho J10 li se li koetsoe joale.
Tlolela Charts, Li-textbox, le Graphics
Ka linako tsohle, lichate tsohle, melaetsa ea melaetsa le lintho tsa litšoantšo-tse kang litšoantšo, lipapali tsa papiso ea lipapali, libopeho le Smart Art-tse teng ka har'a leqephe la lipampiri li koaletsoe 'me ka hona li sireletsoa ha khetho ea Protect Shee e sebelisoa.
Ho tlohela lintho tse joalo li koetsoe e le hore li ka fetoloa hang ha letlapa le sirelelitsoe:
- Khetha ntho e lokelang ho buloa; ho etsa joalo ho phaella tabeng ea Fomati ho lithane.
- Tlanya Format tab.
- Ka lehlakoreng le letona ka lehlakoreng le letona, tobetsa konopo ea lebokose la lebokose la lebokose la lebokose ( lebokose le lenyenyane le ka tlase ho lebokose ) haufi le lentsoe Boima ho bula setšoantšo sa mosebetsi oa marang-rang (Etsa setšoantšo sa lebokose la lebokose la Excel 2010 le 2007)
- Karolong ea Lihlahisoa tsa mochini oa mosebetsi, tlosa letšoao la ho hlahloba lebokose le koetsoeng, 'me haeba le sebetsa, ho tloha lebokoseng la Kemiso ea Lock.
Mohato oa bobeli: Sebelisa Kemiso ea Sireletso ea Sireletsa ho Excel
Bohato ba bobeli ts'ebetsong - ho sireletsa leqephe ka bophara - e sebelisoa ho sebelisa lebokose la lebokose la boitsebiso la Protect Sheet.
Lebokose la lebokose le na le letoto la dikgetho tse khethileng hore na ke likarolo life tsa leqephe la lipampiri tse ka fetoloang. Lintlha tsena li kenyelletsa:
- Ho eketsa phasewete ho thibela tšireletso ea leqephe ho thiba.
- Ho khetha lisele tse koetsoeng le tse koetsoeng.
- Ho hlophisa, ho falla, kapa ho tlosa dintlha.
- Ho eketsa mela le melafo .
- Ho pata kapa ho koala molumo le mela.
- Ho fetola palo ea nomoro - matšoao a lichelete, matšoao a lekholong, libaka tsa maemo a marang-rang, joalo-joalo.
- Ho fetola mokhoa oa ho etsa mochine - ho eketsa / ho tlosa meeli , selulo kapa mebala ea mebala ea mochini, ho koahela molaetsa , joalo-joalo.
Tlhokomeliso : Ho eketsa phasewete ha ho thibele basebedisi ho bula leqephe la mosebetsi le ho shebella litaba.
Haeba mekhoa e 'meli e lumellang mochine ho totobatsa lisele tse koetsoeng le tse koetsoeng li khaotsoe, basebelisi ba ke ke ba khona ho etsa liphetoho leha e le efe leqepheng - le haeba e na le lisele tse sa koaloang.
Likgetho tse setseng, tse kang lisebelisoa tsa ho etsa likhetho le ho hlophisa lintlha, ha li sebetse hantle. Ka mohlala, haeba lisele tsa mofuta oa khetho li hlahlojoa ha letlapa le sireletsoa, lisele tsohle li ka fetisoa.
Khetho ea mofuta, ka lehlakoreng le leng, e lumella feela lisele tse 'nileng tsa koaloa pele letlapa le sireletsoa ho hlophisoa.
Mohlala: Sebelisa Kemiso ea Tšireletso ea Tšireletso
- Tlolela kapa u sireletse lisele tseo u li lakatsang lekaleng la kajeno la lipampiri.
- Tlanya tabeng ea lapeng .
- Khetha mofuta oa Fomati ka lekareche ho bula lenane le theoha.
- Tobetsa ho Sireletsa Sheet sekhetho tlasa lethathamong la ho bula lebokose la lebokose la Tšireletso ea Leqephe.
- Sheba kapa u se ke ua hlokomoloha khetho eo ue batlang.
- Tobetsa OK ho koala lebokose la lebokose mme u sireletse leqephe la mosebetsi.
Ho furalla Tshireletso ea Worksheet
Ho thibela leqephe ho etsa hore lisele tsohle li hlophisoe:
- Tlanya tabeng ea lapeng .
- Khetha mofuta oa Fomati ka lekareche ho bula lenane le theoha.
- Tobetsa Lethathamong le sa sireletsang lekhetlo le leng ka tlase la lethathamo ho thibela letlapa.
Tlhokomeliso : Ho se sireletse hoa leqephe ha ho na phello ho boemo ba lisele tse koetsoeng kapa tse sa kooloang.