Yuav ua li cas kho qhov chaw hauv Excel

Thaum ua haujlwm nrog tus naj npawb tseem ceeb ntawm cov ntaub ntawv ntawm ib daim ntawv ntawm cov ntawv nthuav tawm, koj yuav tsum tau txheeb xyuas qee qhov tsis tas li. Tab sis yog tias muaj ntau ntau ntawm lawv, thiab lawv thaj chaw mus dhau ntawm ciam teb ntawm qhov screen, txuas ntxiv txav cov kab ntawv kos yog qhov tsis yooj yim. Excel cov neeg tsim tawm tsuas yog saib xyuas cov neeg siv ntawm cov neeg siv, qhia rau hauv cov program no ua rau muaj kev pab pawg. Cia peb nrhiav kom paub li cas cov nta no tau ua thiab yuav ua li cas siv Microsoft Excel txoj haujlwm.

Fastening thaj chaw hauv Excel

Kev daws ntawm peb txoj haujlwm niaj hnub no yuav pom muaj tseeb ntawm qhov Program Program tau yog ib feem ntawm Microsoft Office lossis tshiab (2019), cov kauj ruam tsim nyog rau kev kho thaj chaw tau ua nyob rau hauv tib yam txoj kev.

Qhov Xaiv 1: Thaj chaw ntawm cov hlua

Ntau zaus nyob rau hauv lub e-lub rooj excel, nws yog ib qho yuav tsum tau kho thaj chaw los ntawm ntau cov kab sab saum toj, uas yog cov thiaj li hu ua Cap. Qhov no yog ua tiav raws li hauv qab no:

1. Kev tsom mus rau cov lej kab ntawm sab (sab laug) Pawg Neeg Pab Pawg, xaiv sab laug khawm los ntawm nias lub khawm laug (LKM) raws li cov kab, uas yuav yog cov hauv qab no rau cov hauv qab no. Hauv peb qhov piv txwv, peb yuav nrawm dua thawj peb kab, uas yog qhov tsim nyog los faib ua cov ntaub ntawv plaub.



2. Mus rau "Saib" tab thiab hauv "Qhov rai" Toolbar, nthuav tawm cov ntawv qhia zaub mov ntawm "thaj chaw nyab xeeb" khoom.



3. Hauv cov npe tso tawm cov npe ntawm cov kev xaiv, xaiv cov kev xaiv nkaus xwb haum rau peb lub hom phiaj - "nrawm nroos".



Qhov no yooj yim koj tuaj yeem kho cov kab tav toj hauv thaj chaw muaj ob peb kab, hauv lub rooj zoo nkauj.

Qhov Xaiv 2: Thaj chaw ntawm txhua

Nws tseem tshwm sim hais tias nws yog ib qho tsim nyog los ua kom nrawm sab saum toj ntawm lub rooj, tab sis sab, uas yog, cov kab nyob ntawm sab laug. Lub algorithm ntawm kev ua nyob rau hauv cov ntaub ntawv no yog tib yam, tab sis muaj kev hloov kho luv luv.

1. Tshaj tawm cov kem tom qab cov kab ke ntawm cov kev npaj kho. Hauv peb qhov piv txwv, C sab yog, uas yog, peb yuav kho qhov ntau-b.



2. Qhib cov tab saib tab thiab siv qhov "nyab xeeb thaj tsam" khoom.



3. Xaiv thawj qhov kev xaiv los ntawm cov npe uas luam tawm lub npe ntawm cov khoom tseem ceeb thiab twb tau hais los ntawm peb hauv ntu dhau los.



Txij lub sijhawm no, thaj chaw tsim (sab laug) yuav raug muab kho, thiab thaum scrolling lub rooj nyob rau hauv kab rov tav, nws yuav nco ntsoov nyob hauv nws qhov chaw.

Qhov Xaiv 3: Thaj tsam ntawm kab thiab txhua

Raws li qhov tseeb tias cov ntaub ntawv muaj nyob hauv cov hlwb, uas feem ntau xav tau los ua ntej ntawm lub qhov muag thiab sab saud, nws tsis xav tsis thoob tias tus excel spoilkit tso cai rau koj los kho ob qho tib si Thawj thiab thib ob. Rau qhov no:

1. Cov ntsiab lus los ntawm nias lub LCM uas yog nyob hauv qab cov kab uas koj xav kho, thiab tom qab ntawd mus rau "Saib" tab.

   

   Piv txwv li: Txhawm rau txhim kho ob kab thawj (12) Thiab Kem (A, b) , xaiv lub cell nrog chaw nyob C3.

   .

2. Hauv thaj teb ntawm "Window" cov cuab yeej tabs, siv cov khoom "ua kom nrawm dua thaj chaw"

   

   Thiab nyob rau hauv cov npe uas qhib, xaiv tib qho kev xaiv.



3. Tam sim no, nrog ib ntsug scrolling ntawm lub rooj, cov kab ruaj khov yuav nyob hauv qhov chaw,

   

   Thiab nrog cov kab rov tav tsau cov kab yuav nyob.



Cov version ntawm kev txiav txim txiav txim siab nyob rau hauv no yog kev txhais lus ntawm cov kab lus "consolidate thaj tsam". Ua ib qho zoo li qub los ntawm cov kab thiab cov kab mob sab qaum ntawm cov Excel lub kaus mom yog lub kaus mom, thiab sab, ua kab ke ntawm cov neeg ua haujlwm.

Xaiv 4: ib sab lossis ib kab

Yog hais tias nyob rau hauv kev sib sau ua ke ntawm thaj av, koj hais tias ib qho kev txhim kho ntawm tsuas yog ib qho ntawm lub rooj, uas yog, ib qho ntawm nws kab lossis ib kem, txhua yam yog yooj yim dua. Koj tsuas yog hais txog qhov uas xav tau, thiab tom qab ntawd xaiv cov khoom uas sib haum rau koj txoj haujlwm hauv qhov chaw "Kev nyab xeeb" khawm. Xwb, koj tsis tuaj yeem faib ib yam dab tsi txhua, thiab tsuas yog xaiv ib txoj hlua txuas ntxiv - "Muaj kev nyab xeeb rau sab saum toj kem" lossis "nrawm rau ntawm txoj haujlwm ua ntej ntawm koj. Cov txheej txheem no, nrog rau qhov nuances uas txhais tau tias nws txoj kev siv, tau pom zoo los ntawm peb nyob rau hauv cov khoom lus cais, thiab peb pom zoo lawv tus kheej.

Nyeem ntxiv: Yuav ua li cas kom ruaj ntseg ib kab lossis ib kab

Pov tseg ntawm thaj chaw muaj txiaj ntsig

Nyob rau hauv qhov kev tshwm sim uas yuav tsum tau consolidate thaj chaw (cov hlua, txhua yam tsis muaj teeb meem, nws yuav tsim nyog los ua qhov tseeb, raws li nyob rau hauv cov rooj plaub, raws li nyob rau hauv cov xwm txheej txiav txim siab saum toj no. Qhov sib txawv tsuas yog qhov "kho thaj chaw" cov ntawv qhia zaub mov yuav tsum xaiv thawj zaug thiab cov khoom pom tseeb tshaj plaws hauv cov cheeb tsam no kom "tshem tawm cov cheeb tsam ruaj khov".

Tag

Snap cov hlua, kab lossis nthuav dav lawv cov kab hauv Microsoft Excel daim ntawv yog yooj yim. Qhov loj tshaj plaws nyob rau hauv cov ntaub ntawv no kom nkag siab dab tsi lub caij ntawm lub rooj yuav tsum tau faib, thiab peb tau qhia hauv kev nthuav dav hauv cov lus hauv hnub no.