Dab neeg zoo li cov ntaub ntawv, cov ntsiab lus ntawm uas tau tshwm sim thaum luam ntawv ntawm cov nplooj ntawv sib txawv hauv tib qho chaw. Nws yog qhov tshwj xeeb tshaj yog yooj yim siv cov cuab yeej no thaum ua cov npe ntawm cov ntxhuav thiab lawv lub kaus mom. Nws kuj tseem siv tau rau lwm lub hom phiaj. Cia peb mus saib li cas koj tuaj yeem npaj cov kev nkag tau zoo hauv Microsoft Excel.
Thov hla cross-cutter
Txhawm rau tsim kab kawg uas yuav muab tso rau txhua nplooj ntawv ntawm cov ntaub ntawv, koj yuav tsum tau ua qee yam kev ntxias.
- Mus rau lub tab "Nplooj ntawv Markup". Ntawm daim kab xev hauv "nplooj ntawv tsis muaj" Tool Thaiv los ntawm txhaj rau "lub npe luam tawm" khawm.
- Lub parameter qhov rais qhib. Mus rau "ntawv" tab yog lub qhov rais qhib hauv lwm lub tab. Hauv cov "luam tawm rau txhua nplooj ntawv" chaw, tso tus cursor hauv kab "cuam".
- Tsuas yog xaiv ib lossis ntau cov kab ntawm ib daim ntawv uas koj xav ua los ntawm. Lawv txoj kev sib koom tes yuav tsum tau cuam tshuam hauv daim teb hauv parameter qhov rai. Nyem rau ntawm "OK" khawm.
XIM! Yog tias koj tab tom kho qee lub cell, tom qab ntawd lub pob no yuav tsis ua haujlwm. Yog li ntawd, koj yuav tawm ntawm hom hloov kho. Nws yuav tsis ua haujlwm yog tias lub tshuab luam ntawv tsis raug ntsia rau lub khoos phis tawm.
Tam sim no cov ntaub ntawv teev nyob rau hauv thaj chaw uas raug xaiv tseg yuav raug tso tawm rau lwm nplooj ntawv piv txwv li yog tias koj tau sau tseg (muab tso rau (muab tso rau (muab tso rau) cov khoom siv luam tawm tau manually.
Txhawm rau saib seb cov ntaub ntawv yuav zoo li cas thaum xa mus rau luam ntawv, mus rau "cov ntaub ntawv" tab thiab txav mus rau ntu ". Nyob rau hauv sab xis ntawm lub qhov rais, scrolling down qhov chaw cia, saib ntau npaum li cas ua tiav tau tiav, uas yog, yog tias cov ntaub ntawv tau tshwm sim los ntawm cov kab ntawm txhua nplooj ntawv.
Ib yam li ntawd, koj tuaj yeem tsim tsis tau tsuas yog cov hlua, tab sis kuj cov kab ntawv. Tsuas yog nyob rau hauv cov ntaub ntawv no, cov kev sib koom tes yuav tau ua nyob rau hauv tshooj "los ntawm kab ntawv" nyob rau nplooj ntawv ntawm nplooj ntawv ntawm page tsis.
Cov algorithm no tau siv tau rau Microsoft Excel 2007, 2010, 2013 thiab 2016 versions. Cov txheej txheem rau kev nqis tes ua hauv lawv yog tib yam nkaus.
Raws li koj tuaj yeem pom, qhov kev pab cuam Excel muab lub sijhawm rau kev npaj los ntawm kab hauv phau ntawv. Qhov no yuav tso tawm cov npe kev rov ua dua rau cov nplooj ntawv sib txawv ntawm cov ntaub ntawv, sau lawv ib zaug xwb, uas yuav cawm tau lub zog thiab lub sijhawm.