Tšireletso ea data ho Microsoft Excel

Microsoft Excel e fa mosebelisi maemo a 'maloa a tšireletso - ho tloha ho ts'ireletso e bonolo ea lisele ka bomong ho ea ho encryption ea faele eohle ka li-ciphers tsa li-crypto-algorithms tsa lelapa la RC4. Ha re feteng ho tsona ka bonngoe ...

Mohato 0. Tshireletso kgahlanong le ho kenya data e fosahetseng ka seleng

Tsela e bonolo. E u lumella ho lekola hore na hantle-ntle mosebelisi o kenya eng liseleng tse itseng mme ha e u lumelle ho kenya data e sa sebetseng (mohlala, theko e mpe kapa palo e fokolang ea batho kapa letsatsi la Phetohelo ea Mphalane ho fapana le letsatsi la ho qetela. konteraka, joalo-joalo) Ho seta tlhahlobo e joalo ea ho kenya, o hloka ho khetha lisele ebe o khetha tab Lintlha (Letsatsi) konopo Netefatso ea data (Tiiso ea Lintlha). Ho Excel 2003 le ho feta, sena se ka etsoa ho sebelisoa menu Lintlha - netefatso (Boitsebiso - netefatso)… Ho tab ya entsprechen ho tsoa lethathamong le theoha, o ka khetha mofuta oa data o lumelletsoeng ho kenya:

Li-tab tse haufi tsa fensetere ena li lumella (haeba li lakatsa) ho seta melaetsa e tla hlaha pele e kena - tab. Molaetsa o kentsoeng (Molaetsa o kentsoeng), le ha o kenya tlhahisoleseding e fosahetseng – tab Molaetsa oa phoso (Temoso ea Phoso):

 Mohato oa 1: Ho Sireletsa Lisele tsa Leqephe ho Liphetoho

Re ka thibela ka botlalo kapa ka boikhethelo ho thibela mosebelisi ho fetola litaba tsa lisele tsa leqephe lefe kapa lefe. Ho kenya ts'ireletso e joalo, latela algorithm e bonolo:

1. Khetha lisele tse ha ho hlokahale ho sireletsa (haeba e teng), tlanya ho tsona ka ho le letona ebe u khetha taelo ho tsoa ho menyu ea litaba Sebopeho sa sele (Lisele tsa Format)… Ho tab ya Protection (Tshireletso) hlakola lebokose Sele e sirelelitsoeng ( notletsoe). Lisele tsohle tseo lebokose lena le lulang li khethiloe bakeng sa tsona li tla sireletsoa ha ts'ireletso ea leqephe e buletsoe. Lisele tsohle tseo u sa khetheng ho lekola folakha li tla khona ho feto-fetoha ho sa tsotellehe tšireletso. Ho bona hore na ke lisele life tse tla sireletsoa le tse ke keng tsa sireletsoa, ​​u ka sebelisa macro ena.
2. Ho nolofalletsa ts'ireletso ea leqephe la hajoale ho Excel 2003 le ho feta - khetha ho tsoa ho menu Tšebeletso - Tšireletso - Sireletsa Leqephe (Lisebelisoa - Tšireletso - Sireletsa leqephe la mosebetsi), kapa ho Excel 2007 le hamorao, tobetsa Sireletsa Leqephe (Sireletsa leqephe) tab ya Ho hlahloba (Tlhahlobo). Ka lebokoseng la puisano le bulang, o ka beha phasewete (e tla hlokahala e le hore ho se be motho ea ka tlosang tšireletso) 'me, u sebelisa lethathamo la li-checkbox, lokisa, haeba u lakatsa, mekhelo:

Ke hore, haeba re batla ho siea mosebelisi bokhoni, mohlala, ho fomata lisele tse sirelelitsoeng le tse sa sireletsoang, li-checkbox tse tharo tsa pele li tlameha ho hlahlojoa. U ka boela ua lumella basebelisi ho sebelisa ho hlopha, ho sefa, le lisebelisoa tse ling tse bonolo tsa litafole.

Boemo ba 2. Tšireletso e khethehileng ea mekhahlelo bakeng sa basebelisi ba fapaneng

Haeba ho nahanoa hore basebelisi ba 'maloa ba tla sebetsa le faele,' me e mong le e mong oa bona o tlameha ho fumana sebaka sa hae sa maqephe, joale o ka beha tšireletso ea lakane ka li-password tse fapaneng bakeng sa mefuta e fapaneng ea lisele.

Ho etsa sena, khetha ho tab Ho hlahloba (tekolo botjha) konopo Dumella ho fetola mabala (Lumella basebelisi ho fetola mekhahlelo). Ho Excel 2003 le hamorao, ho na le taelo ea menu bakeng sa sena Tšebeletso - Tšireletso - Lumella ho fetola mekhahlelo (Lisebelisoa - Tšireletso - Lumella basebelisi ho fetola mekhahlelo):

Ka fensetere e hlahang, tobetsa konopo Create (e ncha) 'me u kenye lebitso la sebaka, liaterese tsa lisele tse kenyellelitsoeng lethathamong lena le phasewete ho fihlella mofuta ona:

Pheta mehato ena bakeng sa mefuta e fapaneng ea basebelisi ho fihlela kaofela e thathamisitsoe. Joale o ka tobetsa konopo Sireletsa Leqephe (sheba serapa se fetileng) 'me u lumelle tšireletso ea leqephe lohle.

Joale, ha u leka ho fihlella leha e le efe ea libaka tse sirelelitsoeng lethathamong, Excel e tla hloka password bakeng sa mofuta ona o itseng, ke hore, mosebelisi e mong le e mong o tla sebetsa "serapeng sa hae".

Boemo ba 3. Ho sireletsa maqephe a buka

Haeba u hloka ho itšireletsa ho:

• ho phumula, ho reha bocha, ho suthisa maqephe bukeng ya mosebetsi
• liphetoho libakeng tse hatisitsoeng ("lihlooho", joalo-joalo)
• liphetoho tse sa batleheng tsa sebopeho (mela/likholomo tse putlang ho sebelisa likonopo tsa ho kopanya le ho tlosa)
• bokhoni ba ho nyenyefatsa/ho sutisa/ho fetola boholo ba fensetere ea buka ea mosebetsi ka hare ho fensetere ea Excel

joale o hloka ho sireletsa maqephe ohle a buka, ho sebelisa konopo Sireletsa buka (Sireletsa Buka ea Mosebetsi) tab ya Ho hlahloba (Tlhahlobo) kapa - liphetolelong tsa khale tsa Excel - ka menu Tšebeletso - Tšireletso - Sireletsa buka (Lisebelisoa - Tšireletso - Sireletsa buka ea mosebetsi):

Boemo ba 4. Feela encryption

Haeba ho hlokahala, Excel e fana ka bokhoni ba ho koala faele eohle ea buka ea mosebetsi ho sebelisa mekhoa e mengata e fapaneng ea RC4 ea malapa. Tšireletso ena e bonolo haholo ho e beha ha u boloka buka ea mosebetsi, ke hore, khetha lihlopha Faele - Boloka Joalo (Faele - Boloka Joalo), ebe fensetereng ea ho boloka, fumana le ho atolosa lenane la ho theoha Tšebeletso - Likhetho tse akaretsang (Lisebelisoa - Likhetho tse akaretsang). Ka fensetere e hlahang, re ka kenya li-password tse peli tse fapaneng - ho bula faele (bala feela) le ho e fetola:

• Mokhoa oa ho beha / ho sireletsa maqephe ohle a buka hang-hang (tlatsetso ea PLEX)
• Totobatsa lisele tse sa sireletsehang ka mebala
• Tšireletso e nepahetseng ea maqephe ka macro