txheem
Microsoft Office Excel feem ntau tsim cov ntxhuav nrog ntau cov ntaub ntawv uas muaj teeb meem kom haum rau ib daim ntawv ua haujlwm. Vim tias qhov xwm txheej no, nws nyuaj rau tus neeg siv los sib piv cov ntaub ntawv nyob rau ntawm qhov sib txawv ntawm cov ntaub ntawv, thiab nws yuav siv sij hawm ntau heev los scroll los ntawm lub rooj mus nrhiav cov ntaub ntawv tsim nyog. Txhawm rau zam qhov teeb meem zoo li no, thaj chaw tseem ceeb hauv Excel tuaj yeem hloov kho txhua lub sijhawm, kho qhov pom ntawm cov ntaub ntawv, kom tus neeg siv tuaj yeem nrhiav cov ntaub ntawv txaus siab rau nws. Kab lus no yuav tham txog txoj hauv kev rau pinning thiab unpinning thaj chaw hauv Excel.
Yuav ua li cas pin thaj chaw
Muaj ntau ntau txoj hauv kev los ua kom tiav txoj haujlwm, txhua qhov cuam tshuam rau ib qho tshwj xeeb ntawm qhov program. Cov txheej txheem sib txawv ntawm Microsoft Excel yuav txawv me ntsis. Feem ntau, cov txheej txheem ntawm kev kho qhov tsim nyog hauv qhov kev zov me nyuam tau muab faib ua cov kauj ruam hauv qab no:
- Xaiv thawj lub xovtooj ntawm lub rooj. Lub xovtooj ntawm no yuav tsum nyob hauv qab ntawm thaj chaw uas koj xav pin hauv qhov pom ntawm qhov screen. Ntxiv mus, cov ntaub ntawv nyob rau saum toj thiab sab laug ntawm cov khoom xaiv yuav raug kho los ntawm qhov kev pab cuam.
- Tom qab ua qhov kev tswj hwm yav dhau los, koj yuav tsum tau hloov mus rau "Saib" tab. Nws yog nyob rau hauv cov kev xaiv kab nyob rau sab saum toj ntawm Excel interface.
- Tom ntej no, hauv kab qhib ntawm qhov tseem ceeb, koj yuav tsum nyem LMB ntawm "Qhov rai" khawm ib zaug.
- Ob peb lub cuab yeej yuav raug tso tawm kom pom, uas koj yuav tsum tau nyem rau ntawm "Qhib panes" icon. Ntawm cov saib dav dav nrog cov zaub siab daws teeb meem, Saib ntu tam sim qhia cov kev xaiv rau pinning ntsiab. Cov. Koj tsis tas yuav nyem rau ntawm lub qhov rais khawm.
- Xyuas kom meej tias thaj chaw uas tau xaiv yav dhau los raug kho rau ntawm daim ntawv ua haujlwm. Tam sim no txhua yam uas tau hais saum toj no thiab sab laug ntawm lub xov tooj ntawm tes yuav tshwm sim hauv lub rooj thaum koj scroll down, thiab yuav tsis ploj ntawm qhov pom.
- Tus neeg siv kuj tuaj yeem pin tag nrho cov hlwb uas nyob saum cov kab xaiv. Txhawm rau ua qhov no, nws yuav tsum xaiv lub xovtooj uas xav tau hauv nruab nrab ntawm lub rooj, thiab tom qab ntawd tib txoj kev mus rau "Saib" tab, qhov twg nyem rau ntawm lub pob "Qhib thaj chaw". Txoj kev kho no yog qhov tseem ceeb tshaj plaws thaum tus neeg yuav tsum tau kho lub rooj array header ntawm txhua daim ntawv ua haujlwm.
Ua tib zoo mloog! Txhawm rau txhim kho cov ntaub ntawv uas nyob rau sab laug ntawm lub xov tooj ntawm tes xaiv, koj yuav tsum xaiv lub ntsiab lus saum toj kawg nkaus ntawm kem nyob rau sab xis ntawm thaj chaw uas xav tau, thiab tom qab ntawd ua tib yam.
Yuav ua li cas cov cheeb tsam yog unpinned
Cov neeg siv tsis paub dhau los ntawm Microsoft Office Excel tsis paub yuav ua li cas tshem tawm cov chaw kaw yav dhau los. Txhua yam yooj yim ntawm no, qhov tseem ceeb tshaj plaws yog ua raws qee cov lus pom zoo:
- Qhib ib daim ntawv Excel. Tom qab qhov pom ntawm qhov chaw ua haujlwm hauv lub phaj, koj tsis tas yuav xaiv cov cell.
- Mus rau "Saib" tab nyob rau hauv cov kev xaiv ribbon nyob rau sab saum toj ntawm lub qhov rais program.
- Tam sim no koj yuav tsum nyem rau ntawm "Qhov rai" khawm kom qhib ib ntu nrog pinning ntsiab.
- LMB nyem rau ntawm cov ntawv sau "Unpin regions".
- Txheeb xyuas qhov tshwm sim los ntawm scrolling hauv lub rooj. Kev kho ntawm cov hlwb uas tau xaiv yav dhau los yuav tsum tau muab tso tseg.
Cov ntaub ntawv ntxiv! Detaching thaj chaw hauv Excel yog ua tiav raws nraim qhov kev txiav txim rov qab piv rau kho lawv.
Yuav ua li cas khov ib cheeb tsam los ntawm kab
Qee zaum hauv Excel koj yuav tsum khov tsis yog kab, tab sis kab. Txhawm rau tiv nrog txoj haujlwm sai, koj tuaj yeem siv cov algorithm hauv qab no:
- Txiav txim siab txog cov kab uas yuav tsum tau kho, nrhiav lawv tus lej, uas tau sau rau saum cov array hauv daim ntawv A, B, C, D, thiab lwm yam.
- Siv tus nas khawm sab laug los xaiv kab ke uas ua raws li qhov kev xaiv. Piv txwv li, yog tias koj xav kho kab A thiab B, ces koj yuav tsum xaiv kab C.
- Tom ntej no, koj yuav tsum zoo ib yam mus rau "Saib" tab thiab nyem rau ntawm "Tswj Thaj Chaw" khawm txhawm rau txhim kho cov kab uas xav tau ntawm txhua daim ntawv ua haujlwm.
- Nyob rau hauv cov ntsiab lus teb hom qhov rais, koj yuav tau xaiv thawj qhov kev xaiv rau kho kab thiab kab ntawm cov ntxhuav.
- Tshawb xyuas qhov tshwm sim. Nyob rau theem kawg, koj yuav tsum tau nqes mus rau hauv cov ntaub ntawv thiab xyuas kom meej tias qhov chaw xaiv tsis ploj ntawm daim ntawv ua haujlwm, piv txwv li txuas rau nws.
xaus
Cov cuab yeej kho qhov chaw hauv Excel txuag lub sijhawm rau cov neeg siv uas ua haujlwm nrog ntau cov ntaub ntawv. Ib yam khoom pinned yuav ib txwm tshwm sim ntawm daim ntawv ua haujlwm thaum koj scroll los ntawm nws. Txhawm rau kom ua haujlwm sai sai, koj yuav tsum ua tib zoo nyeem cov ntaub ntawv saum toj no.