Cov txheej txheem:

Qhov kev tiv thaiv tab nyob qhov twg hauv Excel?
Qhov kev tiv thaiv tab nyob qhov twg hauv Excel?

Video: Qhov kev tiv thaiv tab nyob qhov twg hauv Excel?

Video: Qhov kev tiv thaiv tab nyob qhov twg hauv Excel?
Video: Tshuaj theem vim li cas thiaj tau nqi ?/ Siv kho mob dab tsi?/paris polyphylla use for? 2024, Tej zaum
Anonim

Ua haujlwm tiv thaiv daim ntawv

  1. Hauv koj Excel cov ntaub ntawv, xaiv daim ntawv ua haujlwm tab uas koj xav tau tiv thaiv .
  2. Xaiv cov hlwb uas lwm tus tuaj yeem hloov kho.
  3. Right-click nyob qhov twg hauv qhov daim ntawv thiab xaiv FormatCells (lossis siv Ctrl + 1, lossis Command + 1 ntawm Mac), thiab tom qab ntawd mus rau qhov Kev tiv thaiv tab thiab Clear Locked.

Ntawm no, koj puas tuaj yeem lo lus zais tiv thaiv tab hauv Excel?

Rau tiv thaiv ib daim ntawv, xaiv a tab hauv koj Excel phau ntawv ua haujlwm, nyem rau ntawm Kev Tshawb Fawb tab thiab xaiv Tiv thaiv Daim ntawv qhia zaub mov xaiv. Qhov kev xaiv no tso cai rau kev tiv thaiv tshwj xeeb ntawm koj phau ntawv . Los ntawm lub neej ntawd, theoptions yuav luag tag nrho kaw qhov phau ntawv . Wb sadd a tus password thiaj li hais tias daim ntawv yog tiv thaiv.

Qhov thib ob, yuav ua li cas kuv thiaj tsis tiv thaiv daim ntawv ua haujlwm Excel yog tias kuv tsis nco qab lo lus zais? Yuav ua li cas unprotect ib lo lus zais tiv thaiv worksheet.

  1. Kauj ruam 1 Nias ALT + F11 los yog nyem Saib Code ntawm DevelopersTab.
  2. Kauj ruam 2 Ob npaug nyem rau ntawm daim ntawv ua haujlwm uas tiv thaiv tus password.
  3. Kauj ruam 3 Luam thiab paste cov cai hauv qab no rau hauv (Code) qhov rai.
  4. Kauj Ruam 4 Nyem rau ntawm Khiav Khawm lossis nias F5.

Ua raws li qhov no, Kuv yuav tiv thaiv phau ntawv Excel li cas los ntawm kev kho?

Txhawm rau tiv thaiv koj phau ntawv ua haujlwm:

  1. Nyem qhov File tab kom nkag mus saib Backstage.
  2. Los ntawm cov ntaub ntawv pane, nyem qhov Protect Workbook hais kom ua.
  3. Hauv cov ntawv qhia zaub mov nco-down, xaiv qhov kev xaiv uas haum koj xav tau.
  4. Ib lub dialog box yuav tshwm sim, qhia koj kom txuag tau.
  5. Lwm lub dialog box yuav tshwm sim.
  6. Phau ntawv ua haujlwm yuav raug cim tias yog qhov kawg.

Kuv yuav tiv thaiv hlwb li cas hauv Excel 2010 yam tsis muaj kev tiv thaiv?

Ua li no, xaiv tag nrho cov kab thiab kab hauv koj daim ntawv . Right-click rau ces xaiv "Format Cells " los ntawm cov ntawv qhia zaub mov popup. Thaum hom ntawv Cells qhov rais tshwm, xaiv qhov Kev tiv thaiv tab. Uncheck lub "Locked" checkbox.

Pom zoo: