Yuav ua li cas khov ib kab, kab lossis cheeb tsam hauv Excel? yog ib lo lus nug uas cov neeg siv novice nug thaum lawv pib ua hauj lwm nrog cov rooj loj. Excel muaj ntau yam cuab yeej los ua qhov no. Koj yuav kawm tag nrho cov cuab yeej no los ntawm kev nyeem zaj lus qhia no kom kawg.
Thaum ua hauj lwm nrog ntau cov ntaub ntawv, nws yuav nyuaj rau correlates cov ntaub ntawv nyob rau hauv ib tug workbook. Txawm li cas los xij, Excel muaj ntau yam cuab yeej uas ua rau nws yooj yim los saib cov ntsiab lus ntawm ntau ntu ntawm phau ntawv ua haujlwm tib lub sijhawm, xws li pinning panes thiab splitting windows.
Kho cov kab hauv Excel
Qee zaum koj yuav xav pom qee qhov chaw ntawm koj daim ntawv ua haujlwm Excel txhua lub sijhawm, tshwj xeeb yog cov npe. Los ntawm pinning kab lossis kab, koj yuav muaj peev xwm scroll los ntawm cov ntsiab lus, thaum lub pinned hlwb yuav nyob twj ywm nyob rau hauv saib.
- Muab cov kab hauv qab ntawm qhov koj xav pin. Hauv peb qhov piv txwv, peb xav ntes kab 1 thiab 2, yog li peb xaiv kab 3.
- nias lub Saib ntawm daim kab xev.
- Push command Txhim kho thaj chaw thiab xaiv cov khoom ntawm tib lub npe los ntawm cov ntawv qhia zaub mov.
- Kab yuav raug pinned, thiab qhov chaw pinning yuav qhia los ntawm kab grey. Tam sim no koj tuaj yeem scroll Excel daim ntawv ua haujlwm, tab sis cov kab pinned yuav nyob twj ywm hauv qhov pom ntawm sab saum toj ntawm daim ntawv. Hauv peb qhov piv txwv, peb tau scrolled daim ntawv mus rau kab 18.
Kho cov kab hauv Excel
- Xaiv lub kem rau sab xis ntawm kem koj xav kom khov. Hauv peb qhov piv txwv, peb yuav khov kab A, yog li peb yuav hais txog kab B.
- nias lub Saib ntawm daim kab xev.
- Push command Txhim kho thaj chaw thiab xaiv cov khoom ntawm tib lub npe los ntawm cov ntawv qhia zaub mov.
- Cov kab yuav docked thiab qhov chaw docking yuav qhia los ntawm kab grey. Tam sim no koj tuaj yeem scroll Excel daim ntawv ua haujlwm, tab sis cov kab pinned yuav nyob twj ywm hauv saib ntawm sab laug ntawm daim ntawv ua haujlwm. Hauv peb qhov piv txwv, peb tau txav mus rau kab E.
Txhawm rau tshem tawm kab lossis kab, nyem Txhim kho thaj chaw, thiab tom qab ntawd los ntawm cov ntawv qhia zaub mov xaiv Unpin cov cheeb tsam.
Yog tias koj xav kom khov tsuas yog kab saum toj kawg nkaus (Row1) lossis thawj kab (Kem A), koj tuaj yeem xaiv cov lus txib tsim nyog los ntawm cov ntawv qhia zaub mov nco.
