Yuav Ua Li Cas Thiaj Li Muaj Peev Xwm Tshawb Nrhiav Cov Kev Daws Teeb Meem Hauv Excel

Cov txheej txheem:

Yuav Ua Li Cas Thiaj Li Muaj Peev Xwm Tshawb Nrhiav Cov Kev Daws Teeb Meem Hauv Excel
Yuav Ua Li Cas Thiaj Li Muaj Peev Xwm Tshawb Nrhiav Cov Kev Daws Teeb Meem Hauv Excel

Video: Yuav Ua Li Cas Thiaj Li Muaj Peev Xwm Tshawb Nrhiav Cov Kev Daws Teeb Meem Hauv Excel

Video: Yuav Ua Li Cas Thiaj Li Muaj Peev Xwm Tshawb Nrhiav Cov Kev Daws Teeb Meem Hauv Excel
Video: Tsis Muaj Peev Xwm Yuav Ua Li Cas 2024, Hlis ntuj nqeg
Anonim

Nrhiav Kev ແກ້ yog ib qho kev ntxiv rau hauv Microsoft Office Excel spreadsheet editor. Nws yog siv los nrhiav cov txiaj ntsig zoo ntawm cov nqi hauv ib qho ntawm tes ntawm daim ntawv nthuav qhia. Los ntawm lub neej ntawd, qhov no ntxiv nyob hauv kev tsis taus hauv Excel, tab sis nws tuaj yeem ua kom tiav txhua lub sijhawm los ntawm kev kho ntawm nws tus kheej, tsis tas yuav txhim kho cov ntawv thov ntxiv.

Yuav ua li cas thiaj li muaj peev xwm tshawb nrhiav cov kev daws teeb meem hauv Excel
Yuav ua li cas thiaj li muaj peev xwm tshawb nrhiav cov kev daws teeb meem hauv Excel

Nws yog qhov tsim nyog

Tabular editor Microsoft Office Excel 2007 lossis 2010

Cov Lus Qhia

Kauj ruam 1

Pib daim ntawv txheeb kev nthuav tawm thiab nthuav cov ntawv qhia zaub mov tseem ceeb. Hauv Excel 2007, qhov no yog ua los ntawm txhaj lub chaw loj, puag ncig lub khawm nyob rau sab saud sab sauv ntawm lub qhov rai, thiab hauv Excel 2010, los ntawm nyem lub khawm xiav sau tias "Cov Ntaub Ntawv" nyob hauv kwv yees li qhov chaw. Koj tuaj yeem qhib nws yam tsis muaj nas - xub nias lub pob = "Duab" qhov tseem ceeb (ib zaug lossis ob zaug), thiab tom qab ntawd nkag mus "F".

Kauj ruam 2

Qhib daim ntawv teev cov editor chaw. Hauv 2007 xyoo, Excel xaiv khawm nyob hauv qab txoj cai ntawm cov ntawv qhia zaub mov tseem ceeb tau tsim rau qhov no, thaum nyob hauv Excel 2010 cov khoom xaiv tau ntxiv rau daim ntawv teev cov lus txib hauv kab ntawv sab laug - nws yog qhov thib ob hauv qab.

Kauj ruam 3

Lub qhov rai nrog lub chaw ntawm cov tabular editor ntawm ob qho kev faib tawm tau muab faib ua ob feem ntawm cov ntas ntsug: sab laug ib daim ntawv teev cov ntu, thiab sab xis muaj cov kev teeb tsa ntsig txog ntu. Nrhiav thiab nyem "Ntxiv-ons" kab hauv kab.

Kauj ruam 4

Nyob rau hauv txoj cai thav duab, hauv qab Kev Ua Haujlwm Tsis Raug Ntxiv-xaiv, xaiv cov kab uas pib nrog cov kab ntawv Pom Kev Ua Kev Sib Cav. Nyem OK thiab qhov ntxiv rau yuav raug qhib, tab sis nws yuav tsis tshwm sim hauv Excel cov zaub mov tseem.

Kauj ruam 5

Txav mus rau "Tus tsim tawm" tab nyob rau hauv daim ntawv nthuav qhia cov tshuab raj. Yog tias nws tsis nyob ntawd, thawj nyem-khawm dawb qhov chaw ntawm cov nyees khawm hauv txhua ntu ntawm cov ntawv qhia zaub mov thiab xaiv "Customize Ribbon". Tom qab ntawd nyob rau daim ntawv "Main tabs" nrhiav kab "Tsim", muab ib qhov kos rau ntawm nws thiab nyem OK - tab yuav muab ntxiv rau "ribbon" ntawm cov ntawv qhia zaub mov.

Kauj Ruam 6

Nyem rau ntawm "Add-ons" icon thiab hauv "Muaj Ntxiv-ons" sau tso lub cim rau hauv "Tshawb nrhiav kev daws". Nyem OK thiab ib pab pawg ntxiv ntawm cov lus txib yuav tshwm sim ntawm Cov Ntaub Ntawv tab nrog lub npe Txheeb xyuas. Lub pob "Nrhiav kev daws teeb meem" yuav muab tso rau hauv nws.

Kauj Ruam 7

Lub tab "Tus tsim tawm" tsis tas yuav siv rau qhov no-ntxiv los ua haujlwm, yog li koj tuaj yeem tshem nws los ntawm cov ntawv qhia zaub mov - lov tes taw nws cov zaub tib yam li qhov koj tau qhib nws (saib qib tsib).

Pom zoo: