Cov txheej txheem:

Vim li cas kuv lub hlwb Excel tsis hloov kho?
Vim li cas kuv lub hlwb Excel tsis hloov kho?

Video: Vim li cas kuv lub hlwb Excel tsis hloov kho?

Video: Vim li cas kuv lub hlwb Excel tsis hloov kho?
Video: Tshuaj theem vim li cas thiaj tau nqi ?/ Siv kho mob dab tsi?/paris polyphylla use for? 2024, Hlis ntuj nqeg
Anonim

Thaum twg Excel cov qauv yog tsis hloov kho cia li, feem ntau yuav yog vim qhov kev xam qhov teeb tsa tau hloov mus rau phau ntawv hloov tsis siv neeg. Txhawm rau txhim kho qhov no, tsuas yog teeb tsa qhov kev xaiv suav rau Tsis Siv Neeg dua. Hauv Excel 2007, nyem qhov chaw ua haujlwm> Excel kev xaiv> Formulas> Workbook xam> Tsis siv neeg.

Ib sab ntawm no, vim li cas kuv cov qauv Excel tsis hloov kho tau?

Tshawb xyuas Tsis siv neeg Kev suav rov qab rau cov Formulas ribbon, saib tus farright thiab nias Kev suav Kev xaiv. Ntawm tus dropdownlist, txheeb xyuas qhov ntawd Tsis siv neeg raug xaiv. Thaum qhov kev xaiv no yog teem rau tsis siv neeg , Excel rov xam dua tus phau ntawv cov qauv thaum twg koj hloov cellvalue.

Ib sab saum toj no, koj hloov kho cov txiaj ntsig hauv Excel li cas? Hloov kho qhov txuas

  1. Tso saib cov ntaub ntawv tab ntawm ribbon.
  2. Hauv pab pawg Connections, nyem qhov Kho kom raug Txuas cov cuab yeej. Exceldisplays Edit Links dialog box (Excel 2007, Excel 2010, thiab Excel 2013).
  3. Xaiv qhov txuas koj xav hloov tshiab.
  4. Nyem rau ntawm Hloov Kho Tus Nqi.
  5. Rov ua cov kauj ruam 3 thiab 4 rau lwm qhov txuas uas koj xav hloov tshiab.
  6. Nyem rau Kaw.

Ntawm no, kuv yuav ua li cas thiaj tau Excel kom hloov kho cov hlwb?

Nws pib hloov tshiab ntawm Set Intervals Qhib phau ntawv ua haujlwm uas muaj cov ntaub ntawv sab nraud thiab nyem rau hauv ib qho cell hauv cov ntaub ntawv ntau yam. Mus rau "Data" tab. Nyem " Hloov tshiab Tag nrho" hauv "Kev Sib Txuas" pab pawg thiab xaiv "Kev Sib Txuas Khoom" hauv daim ntawv teev npe poob.

Yuav ua li cas rov suav dua hauv Excel?

2 Teb

  1. CTRL + ALT + SHIFT + F9 txhawm rau txheeb xyuas tag nrho cov qauv kev vam khom thiab rov suav tag nrho cov qauv.
  2. Xaiv ib qho ntawm tes dawb, nias F2 thiab tom qab ntawd sau.
  3. Rov nkag =: Xaiv cov hlwb uas muaj cov qauv uas koj xav hloov tshiab. Nias CTRL + H. Nrhiav dab tsi: = Hloov nrog: =

Pom zoo: