Yog tias koj xav kom Excel tso saib cov ntaub ntawv tsuas yog ua tau raws li qee yam, ces siv lub lim. Rau qhov no:
- Nyem rau ntawm txhua lub xov tooj ntawm tes hauv cov ntaub ntawv.
- Hauv Advanced tab Cov ntaub ntawv (Cov ntaub ntawv) nyem Lim ( Lim ). Cov xub tshwm nyob rau hauv kab kab ntawv.
- Nyem rau ntawm tus xub nyob ib sab ntawm lub npe Lub teb chaws.
- Nyem rau ntawm kab Xaiv tag nrho (Xaiv Tag Nrho) kom tshem tag nrho cov checkboxes, ces kos lub thawv TEB CHAWS USA.
- Xovxwm OK.Qhov tshwm sim: Excel tsuas qhia US cov ntaub ntawv muag khoom.
- Nyem rau ntawm tus xub nyob ib sab ntawm lub npe Quarter.
- Nyem rau ntawm kab Xaiv tag nrho (Xaiv Tag Nrho) kom tshem tag nrho cov checkboxes, ces kos lub thawv qtr 4.
- Xovxwm OK.Qhov tshwm sim: Excel tsuas qhia peb lub quarter thib plaub US cov ntaub ntawv muag khoom.
- Txhawm rau tshem tawm cov lim dej, ntawm lub tab Cov ntaub ntawv (Cov ntaub ntawv) nyem Ntxuav (ntshiab). Txhawm rau tshem tawm cov lim kom tiav, piv txwv li tshem cov xub, nias lub pob dua Lim ( Lim ).