Excel yog dynamic tables, thaum ua hauj lwm nrog cov ntsiab lus yog txav chaw, chaw hloov, thiab lwm yam. Tab sis qee kis, koj yuav tsum txhim kho ib yam khoom los yog, raws li lawv hais lwm yam, khov nws kom nws tsis hloov nws qhov chaw. Cia peb pom tias yam dab tsi pub koj ua qhov no.
Hom kev kho kom zoo
Nyob rau hauv ib zaug nws yuav tsum tau hais tias lub hom fixation nyob rau Excel yuav ua txawv kiag li. Nyob rau hauv dav dav, lawv muaj peev xwm raug muab faib ua peb pawg loj:
- Chaw nyob khov;
- Kho cov hlwb;
- Kev tiv thaiv ntawm cov ntsiab lus ntawm kev kho.
Thaum twg qhov chaw nyob yog khov, qhov siv rau cov xov tooj ntawm tes tsis hloov thaum nws tau theej, uas yog, nws ceases mus txheeb ze. Pinning lub hlwb tso cai rau koj mus saib lawv tas li ntawm qhov kev tshuaj ntsuam, tsis muaj teeb meem pes tsawg tus neeg siv scrolls daim ntawv los yog rau sab xis. Kev tiv thaiv ntawm cov ntsiab lus ntawm kev hloov cov ntawv tawm cov kev hloov hauv cov ntaub ntawv hauv nqe lus teev. Cia peb los saib xyuas txhua yam ntawm cov kev xaiv no.
Txoj Cai 1: Qhov Chaw Nyob Khov
Ua ntej, cia peb nres ntawm qhov chaw nyob ntawm tes. Los khov nws, los ntawm ib tus txheeb ze, uas yog txhua qhov chaw nyob hauv Excel los ntawm lub neej ua ke, koj yuav tsum ua kom muaj qhov txuas uas tsis hloov chaw haujlwm thaum luam. Yuav kom ua tau li no, koj yuav tsum tau sau ib daim ntawv sau qhia rau ntawm txhua qhov chaw nyob ($).
Tus cim sau nqi yog teem los ntawm tus cim rau ntawm tus cwj pwm. Nws nyob ntawm tus yuam sij tib yam nrog tus naj npawb. "4", tab sis mus tso tawm ntawm qhov screen koj yuav tsum nias qhov tseem ceeb no nyob rau hauv cov lus Askiv keyboard layout nyob rau hauv lub rooj plaub (nrog lub ntsiab tseem ceeb Ua haujlwm). Muaj kev yooj yim thiab ceev dua. Xaiv qhov chaw nyob ntawm lub caij nyob rau hauv ib lub xovtooj ntawm tes lossis cov kab ua haujlwm thiab nias lub khoos phais F4. Thawj zaug uas koj nias lub cim kos npe tshwm rau ntawm qhov chaw nyob thiab kab, zaum thib ob koj nias qhov tseem ceeb, nws yuav nyob ntawm qhov chaw nyob, ntawm qhov thib peb nias nws yuav nyob ntawm qhov chaw nyob sab saud. Fourth keystroke F4 tshem tawm daim ntawv kos npe tag nrho, thiab cov nram qab no xa cov txheej txheem no ua ib txoj hauv kev tshiab.
Cia peb saib seb qhov chaw nyob khov kho li cas nrog ib qho piv txwv.
- Ua ntej no, cia peb luam cov txheej txheem li qub rau lwm lub ntsiab ntawm kem. Ua li no, siv tus cim kos npe. Teem tus cursor hauv qab ntawm sab xis ntawm tus xovtooj, cov ntaub ntawv uas koj xav luam. Nyob rau tib lub sij hawm, nws yog hloov mus rau hauv ib tug ntoo khaub lig, uas yog hu ua filling marker. Tuav lub khawm nas khawm thiab cab no khij mus rau qhov kawg ntawm lub rooj.
- Tom qab ntawd, xaiv qhov qis tshaj plaws ntawm lub rooj thiab saib nyob rau hauv lub voj voos vim tias qhov mis tau hloov thaum luam. Raws li koj tau pom, tag nrho cov hauj lwm uas nyob hauv thawj kem kem thawj zaug txav thaum luam. Yog li, cov mis no ua rau muaj qhov tsis zoo. Qhov no yog vim lub fact qhov chaw nyob ntawm tus thib ob multiplier, tsis zoo li thawj, kev txheeb xyuas kom yog tsis hloov, uas yog, nws yuav tsum tau ua meej lossis tsau.
- Peb rov qab mus rau lub caij xub thawj ntawm cov kem thiab muab cov cim sau npe nyob ze ntawm cov kev sib tw ntawm ob txoj hauv kev ntawm ib qho uas peb tau tham txog saum toj no. Qhov txuas yog tam sim no khov.
- Tom qab ntawd, siv tus cim kos npe, luam mus rau ntau qhov ntawm cov lus hauv qab no.
- Tom qab ntawd xaiv lub caij kawg ntawm kem. Raws li peb pom tau los ntawm cov kab hauv cov qauv, qhov chaw khiav dej num ntawm qhov zoo tshaj plaws tseem hloov pauv thaum luam, tab sis qhov chaw nyob hauv ob yam, uas peb tau ua, tsis hloov.
- Yog tias koj tau sau ib daim ntawv sau qhia rau ntawm qhov chaw sab nraud xwb, ces qhov no yog qhov chaw nyob ntawm kem ntawm daim ntawv thov, thiab qhov chaw ua haujlwm ntawm cov kab yog txav thaum luam.
- Hloov siab, yog tias koj teev ib daim ntawv sau nyiaj nyob ze ze qhov chaw nyob, ces thaum luam nws yuav tsis hloov, tsis zoo li qhov chaw nyob sab saud.
Qhov no yog siv los khov cov kwj hauv lub hlwb.
Zaj Lus Qhia: Kawm Lus Mis Thaj hauv Excel
Txoj kev 2: Pinning Cells
Tam sim no peb kawm tau kho lub hlwb kom lawv tas li nyob rau ntawm qhov screen, qhov twg tus neeg siv mus rau hauv thaj tsam ntawm daim ntawv. Nyob rau tib lub sijhawm, nws yuav tsum tau muab sau tseg tias nws tsis tuaj yeem kho cov khoom cais, tiam sis nws tseem tuaj yeem txhim kho cheeb tsam uas nws nyob.
Yog hais tias lub xov tooj ntawm tes yog nyob rau hauv cov kab saum toj kawg nkaus ntawm daim ntawv los yog sab sab qab kawg ntawm daim ntawv, ces tus pinning tsuas yog qib elementary.
- Txhim kho txoj kab no ua cov kauj ruam nram qab no. Mus rau lub tab "Saib" thiab nyem rau ntawm lub pob "Pem lub cheeb tsam"uas yog nyob hauv lub block ntawm cov cuab yeej "Qhov rai". Ib cov npe ntawm cov pinning ntau txoj kev qhib opens. Xaiv lub npe "Pin rau sab saum toj kab".
- Tam sim no txawm hais tias koj nqes mus rau hauv qab ntawm daim ntawv, thawj kab, thiab yog li ntawd lub caij koj xav tau, uas yog nyob rau hauv nws, tseem yuav nyob rau sab saum toj ntawm lub qhov rais hauv pom meej.
Ib yam li ntawd, koj tuaj yeem khov phab sab kawg.
- Mus rau lub tab "Saib" thiab nyem rau ntawm lub pob "Pem lub cheeb tsam". Lub sijhawm no peb xaiv qhov kev xaiv "Pim thawj kab".
- Raws li koj pom, sab sab leftmost yog tam sim no tsau.
Hauv kwv yees li tib txoj kev, koj tuaj yeem txhim kho tsis tau tsuas yog thawj kem thiab kab, tab sis feem ntau tag nrho cheeb tsam mus rau sab laug thiab sab saum toj ntawm qhov khoom tau xaiv.
- Lub algorithm rau kev ua txoj hauj lwm no txawv me ntsis ntawm ob yav dhau los. Ua ntej tshaj, koj yuav tsum xaiv ib qho ntawm cov ntawv, thaj tsam saum toj thiab rau sab laug uas yuav kho. Tom qab ntawd mus rau ntawm tab "Saib" thiab nyem rau ntawm tus paub zoo "Pem lub cheeb tsam". Nyob rau hauv cov ntawv qhia zaub mov uas qhib, xaiv cov khoom nrog lub caij nyoog tib lub npe.
- Tom qab qhov kev txiav txim no, tag nrho cheeb tsam ntawm sab laug thiab sab saum toj ntawm lub caij xaiv yuav raug muab tso rau ntawm daim ntawv.
Yog hais tias koj xav kom tshem tawm qhov khov, ua nyob rau hauv no txoj kev, yog yooj yim heev. Kev tua algorithm yog tib yam rau txhua tus neeg uas tus neeg siv tsis txhim kho: ib txoj kab, kem lossis cheeb tsam. Txav mus rau tab "Saib", nyem rau ntawm lub cim "Pem lub cheeb tsam" thiab hauv cov npe uas tau qhib, xaiv qhov kev xaiv "Tsis muaj qhov chaw". Tom qab ntawd, txhua yam tas li ntawm daim ntawv tam sim no yuav tsum ua kom tiav.
Tshooj: Yuav ua li cas pin cheeb tsam hauv Excel
Method 3: Kev Txhim Kho Kev Txhim Kho
Thaum kawg, koj tuaj yeem tiv thaiv lub xovtooj ntawm kev kho los ntawm kev thaiv qhov kev muaj peev xwm hloov cov neeg siv. Yog li, tag nrho cov ntaub ntawv uas nyob hauv nws yuav ua tau khov.
Yog tias koj cov lus tsis dynamic thiab tsis muaj kev hloov rau nws lub sijhawm, ces koj tuaj yeem tiv thaiv tsis tau tsuas yog lub hlwb, tab sis tag nrho daim ntawv tag nrho. Nws yog ntau zuj zus.
- Txav mus rau tab "Cov Ntaub Ntawv".
- Nyob rau hauv lub qhov rais qhib nyob rau hauv sab laug ntsug zaub mov, mus rau seem "Cov ntsiab lus". Hauv nruab nrab ntawm lub qhov rai peb nyem rau ntawm lub tshuab "Tiv thaiv phau ntawv". Nyob rau hauv cov npe qhib kev ua kom pom tseeb tias kev ruaj ntseg ntawm phau ntawv peb xaiv "Tiv thaiv daim ntawv tam sim no".
- Khiav lub qhov rais qhib me me "Daim Ntawv Tiv Thaiv". Ua ntej tshaj plaws, nws yog ib qhov tsim nyog yuav tsum tau nkag mus rau hauv ib qho kev txuag arbitrary nyob hauv ib qho tshwj xeeb dab tsi, uas tus neeg siv yuav tsum tau yog tias nws xav kom tsis txhob tiv thaiv yav tom ntej kom hloov tau daim ntawv. Tsis tas li, yog tias xav tau, koj tuaj yeem tsim lossis tshem tawm ntau cov kev txwv ntxiv los ntawm kev tshawb xyuas lossis tshawb xyuas cov ntawv kos npe ntawm cov khoom sib thooj hauv cov npe hauv qhov rai no. Tab sis feem ntau, lub neej ntawd muaj kev ua haujlwm zoo sib xws, yog li koj tuaj yeem nias ntawm khawm tom qab nkag mus rau lo lus zais "OK".
- Tom qab ntawd, lwm qhov rais qhib, uas tus password nkag dhau los yuav tsum rov qab. Qhov no tau ua tiav los xyuas kom meej tias tus neeg siv tau paub tseeb tias nws nkag mus rau lo lus zais uas nws nco txog thiab sau tau rau hauv cov keyboard siv thiab sau npe tawm, txwv tsis pub nws yuav poob kev nkag mus rau editing daim ntawv. Tom qab rov qab nkag rau lo lus zais nias ntawm khawm "OK".
- Tam sim no thaum koj sim hloov tej lub caij ntawm daim ntawv, qhov kev txiav txim no yuav raug thaiv. Cov ntaub ntawv qhov rai yuav qhib, qhia koj tias cov ntaub ntawv ntawm daim ntawv tiv thaiv tsis tuaj yeem hloov tau.
Muaj lwm txoj kev los thaiv cov kev hloov rau cov ntsiab lus ntawm daim ntawv.
- Mus rau ntawm qhov rais "Kev Tshawb Xyuas" thiab nyem rau ntawm lub cim "Tiv thaiv daim ntawv"uas yog muab tso rau ntawm daim kab xev hauv lub nras cov cuab yeej "Hloov".
- Daim ntawv tiv thaiv qhov rais, uas yog twb paub txog peb, qhib. Tag nrho cov kev nqis tes ntxiv yog ua tau ib yam nkaus li tau piav nyob rau hauv lub dhau los.
Tab sis yuav ua li cas yog hais tias nws yuav tsum khov tsuas yog ib qho los yog ntau lub hlwb, thiab lwm tus neeg yuav tsum, raws li ua ntej, sau cov ntaub ntawv dawb? Muaj ib txoj kev tawm ntawm qhov teeb meem no, tab sis nws txoj kev daws teeb meem yog me ntsis nyuab tshaj qhov teeb meem yav dhau los.
Nyob rau hauv tag nrho cov ntaub ntawv hlwb, los ntawm neej ntawd, cov khoom tau tiv thaiv enabled thaum activating thaiv ntawm daim ntawv raws li ib tug los ntawm cov kev xaiv hais saum toj no. Peb yuav tsum tshem tawm cov kev thaiv kev tiv thaiv nyob rau hauv cov khoom ntawm tag nrho cov ntsiab ntawm cov ntawv, thiab tom qab ntawd muab nws rov los rau hauv cov ntsiab lus uas peb xav khov ntawm kev hloov.
- Nias rau ntawm daim duab, uas nyob ntawm qhov chaw ntawm kab rov tav thiab ntsug panels ntawm cov hauj lwm. Koj tuaj yeem ua tau, yog tias tus cursor nyob hauv txhua cheeb tsam ntawm daim ntawv sab nraum lub rooj, nias lub sijhawm kub ntawm cov keyboards Ctrl + A. Cov nyhuv yuav zoo li qub - tag nrho cov ntsiab lus ntawm nplooj ntawv yog qhov tseem ceeb.
- Tom qab ntawd nias rau ntawm thaj chaw xaiv nrog tus nas khawm. Hauv cov ntawv qhia ua cov ntawv teb qhib, xaiv qhov khoom "Qib hlwb ...". Xwb, siv cov txheej luv Ctrl + 1.
- Kaw lub qhov rais "Qib hlwb". Tam sim ntawd peb mus rau ntawm tab "Kev Tiv Thaiv". Ntawm no koj yuav tsum tsis khij lub npov ntawm ib sab ntawm lub parameter "Kev tiv thaiv cell". Ndliv lub khawm "OK".
- Tom ntej no, peb rov qab mus rau ntawm daim ntawv thiab xaiv lub caij los sis pab pawg uas peb yuav muab cov ntaub ntawv khov kho. Nias lub khawm txoj kev khawm ntawm tus xaiv lub voj voog thiab mus rau lub ntsiab lus teb los ntawm lub npe "Qib hlwb ...".
- Tom qab qhib lub qhov rais formatting, ib zaug rov mus rau tab "Kev Tiv Thaiv" thiab zuam lub thawv "Kev tiv thaiv cell". Tam sim no koj tuaj yeem nias ntawm khawm "OK".
- Tom qab ntawd peb tau npaj cov ntawv tiv thaiv nyob rau hauv ib qho ntawm ob txoj kev uas tau piav qhia ua ntej.
Tom qab ua tiav tag nrho cov txheej txheem uas tau piav qhia nyob rau hauv kev nthuav dav saum toj no, tsuas yog cov hlwb uas peb tau rov kho dua los ntawm cov qauv ntawm cov khoom yuav raug thaiv los ntawm cov kev hloov. Raws li ua ntej, tag nrho lwm cov ntsiab lus ntawm daim ntawv yuav pub dawb los nkag rau cov ntaub ntawv.
Tshooj: Yuav ua li cas tiv thaiv lub xovtooj ntawm kev hloov hauv Excel
Raws li koj tuaj yeem pom, muaj peb txoj hauv kev uas khov hlwb. Tab sis nws yog ib qho tseem ceeb kom nco ntsoov tias tsis tsuas yog siv tshuab rau kev ua cov txheej txheem no sib txawv hauv txhua ntawm lawv, tab sis kuj yog lub essence ntawm qhov cia nws tus kheej. Yog li, nyob rau hauv ib rooj plaub, tsuas yog qhov chaw nyob ntawm daim ntawv sau tas, nyob rau hauv ob - thaj chaw yog tsau rau ntawm qhov screen, thiab nyob rau hauv peb - kev tiv thaiv yog teem rau kev hloov mus rau cov ntaub ntawv nyob rau hauv lub hlwb. Yog li, nws tseem ceeb heev kom nkag siab ua ntej ua qhov txheej txheem qhov koj yuav mus thaiv thiab vim li cas koj ua.
