txheem
Thaum peb yuav tsum tau ua cov ntaub ntawv ntau, nws tsis yog qhov tsis yooj yim rau peb yuav tsum tau ua raws cov npe ntev. Txhawm rau khaws thawj kab pom, muaj qhov tshwj xeeb hu ua pinning kab. Qhov no tso cai rau koj kom nkag siab, piv txwv li, cov qeb twg ib lub xov tooj ntawm tes yog, yam tsis tas yuav ntxiv scroll daim ntawv. Tib qhov ua tau yog hais txog cov kab lus ntawm lub rooj. Kev kho ntawm thaj chaw yog ua los ntawm lub tab lossis cov ntawv qhia zaub mov "Saib", nyob ntawm qhov version ntawm chav ua haujlwm suite siv.
Tab sis sai dua los yog tom qab, tus neeg siv tau ntsib nrog qhov yuav tsum tau tshem tawm cov kab fastening. Qhov no yuav yog rau ntau yam. Piv txwv li, kev kho tau ua rau lub hom phiaj technical. Tom qab ua haujlwm ntawm lub rooj tiav lawm, pinning tej zaum yuav tsis tsim nyog. Hauv qhov no, koj yuav tsum muaj peev xwm tshem tawm nws.
Yuav ua li cas unfreeze kab hauv Excel
Yog li, dab tsi yuav tsum tau ua kom unfreeze ib kab hauv qhov tseeb versions ntawm Excel? Ua ntej koj yuav tsum nrhiav qhov "Saib" tab ntawm lub vaj huam sib luag loj thiab nyem rau ntawm nws nrog tus nas. Ntxiv rau ntawm ribbon, koj tuaj yeem pom tib lub pob los ntawm qhov uas peb yav tas los pinned cov cheeb tsam. Koj yuav tsum tau nyem rau ntawm nws. Ib daim ntawv qhia pop-up yuav tshwm sim. Muaj ib lub pob "Unpin thaj chaw". Tom qab peb nyem rau ntawm nws, peb cov kab yog unpinned.
Cov kab ke dav dav ntawm kev ua txawv nyob ntawm qhov version ntawm Excel ib tus neeg siv. Hauv 2003 version, qhov no yooj yim me ntsis, hauv 2007 thiab laus dua nws nyuaj dua.
Yuav ua li cas unfreeze ib kab hauv Excel
Lub tshuab rau unpinning ib kem hauv Excel zoo ib yam li siv rau kab. Ib yam li ntawd, peb yuav tsum nrhiav qhov "Saib" tab ntawm lub ntsiab Excel vaj huam sib luag, tom qab ntawd peb pom "Qhov rai" ntu nyob ntawd thiab nyem rau ntawm tib lub pob uas nyob saum toj no (los ntawm qhov uas peb tshem tawm cov kab nrawm). Thiab cov kab tsis khov yog ua tiav tib yam li kab - dhau ntawm "Unfreeze regions" khawm.
Yuav ua li cas unpin ib cheeb tsam yav dhau los pinned hauv Excel spreadsheet
Yog tias tag nrho cheeb tsam tau kho yav dhau los, tom qab ntawd tshem tawm nws yuav tsis yooj yim. Txhawm rau ua qhov no, ua raws li cov lus qhia ua ntu zus uas tau piav qhia saum toj no. Qhov tseeb ua ntu zus ntawm cov kauj ruam yuav txawv nyob ntawm qhov version ntawm Excel, tab sis cov logic feem ntau yog tib yam. Piv txwv li, nyob rau hauv version 2007 thiab tshiab dua, qhov ua ntu zus ntawm kev ua no yog siv los ntawm toolbar, uas feem ntau hu ua ribbon.
Thiab nyob rau hauv version 2003, qhov no yog ua nyob rau hauv ib tug me ntsis txawv txoj kev, uas peb yuav tham nyob rau hauv ntau yam hauv qab no.
Nws yog ib qho tseem ceeb kom nco ntsoov tias pheej yig dua versions ntawm Excel tsis muab lub peev xwm los khov thiab tshem tawm kab thiab kab. Yog tias nws dheev hloov tawm tias qhov kev xaiv no tsis nyob ntawm daim kab xev hauv qhov chaw tsim nyog, tsis txhob ntshai. Tej zaum koj yuav tau them nyiaj rau qhov kev pab cuam spreadsheet ntau dua.
Contrary to nrov kev ntseeg, muas ib tug pirated version yuav tsis daws qhov teeb meem nyob rau hauv lub sij hawm ntev. Qhov tshaj plaws yog tias software muaj ntawv tso cai tuaj yeem siv hauv chaw ua haujlwm yam tsis muaj kev pheej hmoo ntawm kev teeb meem nrog txoj cai. Tsis tas li ntawd, Microsoft niaj hnub tshuaj xyuas cov kev pab cuam uas cov neeg siv siv rau qhov muaj cov yuam sij tawg. Yog tias pom qhov tseeb, qhov ua kom ploj mus.
Yuav ua li cas unfreeze kab thiab kab
Cov neeg siv feem ntau txaus siab rau dab tsi tuaj yeem ua rau unpin yav tas los kab thiab kab. Qhov no tuaj yeem ua tiav nrog ib txoj haujlwm yooj yim. Tsis tas li ntawd, qhov ua ntu zus ntawm kev ua yuav ua rau xav tsis thoob nrog nws yooj yim. Yog li peb yuav tsum ua li cas?
Ua ntej tshaj plaws, qhib cov ntaub ntawv Excel xav tau. Tom qab ntawd, qhib lub "Saib" tab, thiab pom qhov "Qhov rai" ntu ntu. Tom ntej no, koj yuav pom "Lock Panes" ntu koj pom ua ntej.
Tom qab ntawd, nws tsuas yog nyem rau ntawm "Unpin thaj chaw" khawm. Raws li koj tuaj yeem pom, cov yeeb yam zoo ib yam li yav dhau los.
Yuav ua li cas unpin hlwb hauv Excel 2003
Excel 2003 tau siv los ua qhov kev pab cuam nrov uas ntau tus tsis xav hloov mus rau qhov niaj hnub thiab ua haujlwm ntau dua 2007 version. Tam sim no qhov teeb meem yog vice versa, xws li ib tug tsis yooj yim nyob rau hauv thawj glance interface tam sim no zoo li yooj yim heev rau cov neeg siv nruab nrab. Yog li ntawd, lub interface ntawm 2003 version ntawm daim ntawv nthuav qhia yog tsis intuitive.
Li no, ntau tus neeg xav paub dab tsi tuaj yeem ua tau txhawm rau txhawm rau tshem tawm cov hlwb hauv Excel 2003 version?
Cov txheej txheem ntawm kev ua yog raws li nram no:
- Qhib qhov rai ntawv qhia zaub mov.
- Nyem rau ntawm "Unpin thaj chaw" khawm.
Raws li koj tuaj yeem pom, tam sim no paub meej tias vim li cas xyoo 2003 ntawm Excel tau nrov heev. Nws yog txaus tsuas yog ua ob clicks nrog rau sab laug nas khawm, thiab qhov xav tau ua tiav. Txhawm rau ua qhov haujlwm zoo sib xws hauv Excel 2007, koj yuav tsum ua 3 nyem. Nws zoo nkaus li tsis yooj yim, tab sis thaum koj yuav tsum ua cov haujlwm no tsis tu ncua, ces cov vib nas this ntxiv mus rau teev. Ntxiv mus, lub moos tiag tiag tsis yog qhov piv txwv. Nws yooj yim txaus los xam. Ntawm cov hoob kawm, tus tshiab Excel interface yog heev yooj yim, tab sis nyob rau hauv xws li cov yam nws tsis hnov tsw zoo li ergonomics.
Feem ntau, peb tau txav deb ntawm lub ncauj lus me ntsis. Wb tham kom ntxaws ntxiv txog yuav ua li cas rho tawm ib cheeb tsam pinned. Ntau precisely, cia peb sau cov ntaub ntawv uas twb paub lawm.
Tshem tawm ib cheeb tsam pinned
Yog li, peb nkag siab yuav ua li cas tshem tawm qhov chaw pinned. Txhawm rau ua qhov no, siv cov ntawv qhia zaub mov "Saib", uas nyob rau hauv Excel 2003 nyob rau hauv lub ntsiab pop-up zaub mov ncaj qha hauv qab lub npe bar, thiab nyob rau hauv cov laus versions - ntawm ib tug tshwj xeeb tab nrog tib lub npe.
Tom qab ntawd, koj yuav tsum xaiv cov khoom "Qhib thaj chaw" thiab tom qab ntawd nyem rau ntawm "Unfreeze thaj chaw" lossis nyem lub pob tam sim no (qhov kev xaiv tom kawg yog qhov qub rau cov laus ntawm Excel interface).
Tom qab ntawd, lub pinning ntawm cov hlwb yuav raug tshem tawm. Txhua yam yog yooj yim heev, tsis muaj teeb meem pes tsawg clicks koj ua tau.