Thaum ua hauj lwm nrog ib qho tseem ceeb ntawm cov ntaub ntawv rau ib daim ntawv hauv Microsoft Excel, ib qho yuav tsum tau lossi xyuas ib txhia tsis. Tab sis, yog tias muaj ntau ntau rau lawv, thiab lawv cheeb tsam txuas ntxiv tshaj qhov kev tshuaj ntsuam, tas li tsiv hauv qhov chaw scroll yog qhov tsis txaus. Cov kws tsim tawm Excel tau cia li saib xyuas cov kev yooj yim ntawm cov neeg siv los ntawm kev qhia hauv qhov kev pab cuam no los kho qhov chaw. Cia peb nrhiav seb yuav kho qhov chaw twg ntawm daim ntawv hauv Microsoft Excel.
Pinning cheeb tsam
Peb yuav xav txog kev txhim kho cov chaw hauv daim ntawv uas siv tus qauv ntawm Microsoft Excel 2010. Tab sis, tsis muaj kev ua tau zoo, cov algorithm uas yuav piav qhia hauv qab no siv tau mus rau Excel 2007, 2013 thiab 2016.
Yuav kom pib anchoring cheeb tsam, koj yuav tsum mus rau "Saib" tab. Tom qab ntawd, xaiv lub xovtooj ntawm nyob rau hauv qab no thiab mus rau ntawm sab xis ntawm qhov chaw khomob. Ntawd yog qhov, tag nrho cheeb tsam uas yuav yog saum toj thiab rau sab laug ntawm cov xovtooj ntawm no yuav raug kho.
Tom qab ntawd, nias rau khawm "Txhim kho qhov chaw", uas nyob rau ntawm daim qauv ntawm cov cuab yeej ntawm "Window". Hauv daim ntawv teev npe uas tshwm sim, kuj xaiv qhov khoom "Kho qhov chaw".
Tom qab ntawd, thaj chaw nyob thiab mus rau sab laug ntawm lub xov tooj ntawm tes xaiv yuav raug kho.
Yog tias peb xaiv thawj lub xovtooj rau sab laug, ces txhua lub hlwb uas siab saum toj no yuav raug kho.
Qhov no yog qhov tshwj xeeb tshaj yog nyob rau hauv cov rooj plaub uas lub npe ntawm lub rooj muaj ob peb kab, txij li qhov txais tos nrog cov kab saum toj kawg nkaus lub phaj tawm yuav tsum tsis raug.
Zoo sib xws, yog tias koj thov tus pin, xaiv qhov topmost cell, ces tag nrho cheeb tsam mus rau sab laug ntawm nws yuav raug tsau.
Detach cheeb tsam
Yuav kom tshem tau cov chaw pinned, koj tsis tas yuav xaiv lub hlwb. Nws yog txaus los nias rau ntawm lub khawm "Kho qhov chaw" nyob rau ntawm kab xov, thiab xaiv qhov khoom "Unpin areas".
Tom qab ntawd, txhua yam uas tau muab rau hauv daim ntawv no yuav muab cais tawm.
Raws li koj tau pom, tus txheej txheem kho thiab undoing cov chaw hauv Microsoft Excel yog yooj yim heev, thiab koj tuaj yeem txawm hais tias, intuitive. Yam nyuab tshaj plaws yog los nrhiav txoj cai tab ntawm qhov kev zov me nyuam, qhov twg cov cuab yeej los daws cov teeb meem no nyob. Tiam sis, peb tau piav saum qee yam hauv cov txheej txheem rau txoj kev ua kom tau thiab kho qhov chaw nyob hauv daim ntawv xov xwm no. Qhov no yog ib qho tseem ceeb heev feature, txij li thaum, los ntawm kev thov thaj tsam kho qhov chaw, koj tuaj yeem txhim kho cov usability ntawm Microsoft Excel, thiab txuag koj lub sijhawm.