Nws tshwm sim tias ntawm daim ntawv Excel koj yuav tsum zais cov ntaub ntawv muaj nyob hauv qee lub hlwb, lossis txawm zais tag nrho kab lossis kab. Qhov no tej zaum yuav yog qee yam ntawm cov ntaub ntawv pabcuam uas lwm lub hlwb xa mus thiab koj tsis xav tso tawm.
Peb yuav qhia koj yuav ua li cas nkaum cov hlwb, kab thiab kab hauv Excel nplooj ntawv thiab tom qab ntawd ua kom lawv pom dua.
Nkaum hlwb
Tsis muaj txoj hauv kev los nkaum ib lub xovtooj ntawm tes kom nws ploj ntawm daim ntawv. Cov lus nug tshwm sim: dab tsi yuav nyob twj ywm nyob rau hauv qhov chaw ntawm lub cell? Hloov chaw, Excel tuaj yeem ua rau nws kom tsis muaj cov ntsiab lus tshwm sim hauv lub xov tooj ntawd. Xaiv ib lub xovtooj ntawm tes lossis ib pawg ntawm cov hlwb uas siv cov yuam sij ua haujlwm и Ctrl, zoo li thaum xaiv ntau cov ntaub ntawv hauv Windows Explorer. Txoj cai-nias rau ntawm ib qho ntawm cov cell xaiv thiab nyob rau hauv cov ntsiab lus ntawv qhia zaub mov nyem Cell format (Format Cells).
Lub dialog box ntawm tib lub npe yuav qhib. Mus rau lub tab Number (Number) thiab hauv daim ntawv teev npe Tus lej hom (Category) xaiv Txhua hom ntawv (Kev cai). Hauv qhov chaw nkag Ib hom (Hom) sau peb lub cim - “;;;” (tsis muaj quotes) thiab nias OK.
Nco ntsoov: Tej zaum, ua ntej siv cov hom ntawv tshiab rau cov hlwb, koj yuav tsum tau tso ib qho kev ceeb toom ntawm cov naj npawb dab tsi nyob hauv txhua lub hlwb, yog li ntawd yav tom ntej koj tuaj yeem rov qab cov ntawv qub rau ntawm tes thiab ua kom nws cov ntsiab lus pom dua.
Cov ntaub ntawv nyob rau hauv lub cell xaiv tam sim no muab zais, tab sis tus nqi lossis cov qauv tseem nyob ntawd thiab tuaj yeem pom hauv cov qauv bar.
Txhawm rau ua kom pom cov ntsiab lus ntawm lub hlwb, ua raws li tag nrho cov kauj ruam saum toj no thiab teeb tsa tus lej pib rau lub xov tooj ntawm tes.
Nco ntsoov: Txhua yam koj ntaus hauv ib lub xovtooj uas muaj cov ntsiab lus zais yuav raug muab zais thaum koj nyem Sau. Hauv qhov no, tus nqi uas nyob hauv lub xovtooj ntawm no yuav raug hloov los ntawm tus nqi tshiab lossis cov qauv uas koj nkag mus.
nkaum kab thiab kab
Yog tias koj ua haujlwm nrog lub rooj loj, koj yuav xav nkaum qee cov kab thiab kab ntawm cov ntaub ntawv uas tsis xav tau tam sim no rau kev saib. Txhawm rau nkaum tag nrho kab, right-click ntawm kab zauv (header) thiab xaiv Hide (Hide).
Nco ntsoov: Txhawm rau nkaum ntau kab, ua ntej xaiv cov kab ntawd. Txhawm rau ua qhov no, nyem rau ntawm kab header thiab, tsis tas tso lub khawm laug nas, rub tus pointer los ntawm tag nrho cov kab uas koj xav nkaum, thiab tom qab ntawd nyem rau ntawm qhov chaw xaiv thiab nyem Hide (Hide). Koj tuaj yeem xaiv cov kab uas tsis nyob ib sab los ntawm txhaj rau lawv cov npe thaum tuav tus yuam sij Ctrl.
Cov lej nyob rau hauv nqe lus ntawm cov kab zais yuav hla, thiab ob kab yuav tshwm nyob rau hauv qhov khoob.
Cov txheej txheem ntawm kev zais kab yog zoo ib yam li cov txheej txheem ntawm kev zais kab. Txoj cai-nias rau ntawm kab uas koj xav nkaum, lossis xaiv ntau kab thiab nyem rau ntawm pawg tseem ceeb. Los ntawm cov ntawv qhia zaub mov uas tshwm, xaiv Hide (Hide).
Cov ntawv nyob hauv kab ntawv zais yuav raug hla thiab ob kab yuav tshwm hauv lawv qhov chaw.
Txhawm rau rov qhia cov kab zais lossis ntau kab, xaiv kab ntawm ob sab ntawm kab zais (s), tom qab ntawd nyem rau ntawm qhov chaw xaiv thiab xaiv los ntawm cov ntawv qhia zaub mov. Qhia (Unhide).
Txhawm rau qhia ib kem zais lossis ntau kab, xaiv cov kab ntawm ob sab ntawm kem zais (s), tom qab ntawd nyem rau ntawm qhov chaw tseem ceeb thiab xaiv los ntawm cov ntawv qhia zaub mov uas tshwm. Qhia (Unhide).
Yog tias koj ua haujlwm nrog lub rooj loj tab sis tsis xav nkaum kab thiab kab, koj tuaj yeem pin lawv kom thaum koj scroll los ntawm cov ntaub ntawv hauv lub rooj, cov lus xaiv yuav nyob twj ywm.