Los ntawm xaiv ntau lub hlwb nyob hauv Excel koj tuaj yeem lwv cov ntaub ntawv, siv cov kev teeb tsa xws li ciam teb los yog shading, los yog siv lwm cov kev xaiv rau cov cheeb tsam loj ntawm daim ntawv ua haujlwm tas ib zaug.
Thaum uas dragging nrog tus nas kom ceev nrooj highlight lub nplhaib ntawm cov uas nyob ib sab yog qhov kev xav paub ntau tshaj kev xaiv ntawm ntau tshaj ib lub xov tooj, muaj qee lub sij hawm thaum lub hlwb koj xav ua kom pom tseeb tsis nyob ntawm ib sab.
Thaum qhov no tshwm sim, nws muaj peev xwm xaiv tau cov hlwb uas tsis yog-uas nyob ib sab. Txawm hais tias xaiv cov hlwb uas tsis yog-uas nyob ib sab yuav ua tau nrog cov keyboard raws li qhia hauv qab no, nws yog qhov yooj yim ua siv cov keyboard thiab nas ua ke.
Xaiv Cov Txheej Txheem Tsis Txuas Mob Hauv Excel nrog Keyboard thiab Nas
- Nias ntawm thawj lub xovtooj uas koj xav xaiv nrog tus pointer pointer kom nws lub xovtooj ntawm tes .
- Nias thiab tuav lub Ctrl qhov tseem ceeb ntawm cov keyboard.
- Nias hauv seem ntawm cov hlwb uas koj xav xaiv lawv tsis tso qhov tseem ceeb Ctrl.
- Thaum tag nrho cov hlwb xav tau xaiv, tso tus yuam sij Ctrl.
- Tsis txhob nyem qhov twg ntxiv nrog tus pointer pointer thaum koj tso tus yuam sij Ctrl los sis koj yuav tshem qhov tseem ceeb ntawm lub hlwb xaiv.
- Yog tias koj tso Ctrl yuam dhau sai sai thiab xav pom ntau lub hlwb, nyem nias thiab puag hauv Ctrl qhov tseem ceeb dua thiab nias rau ntawm tus xov tooj ntxiv (s)
Xaiv Non-Adjacent Cells hauv Excel Siv Xwb Keyboard
Cov kauj ruam hauv qab no npog xaiv cov hlwb uas siv cov keyboard xwb.
Siv cov Keyboard nyob hauv kev Ntxav
Xaiv cov hlwb uas tsis yog nyob ze nrog cov keyboards xwb kom koj siv cov keyboard hauv kev Ntxuas Muas.
Extended hom activated yog nias lub F8 yawm sij ntawm cov keyboard. Koj tuaj yeem kaw hom kev nias ntawm nias ntawm qhov ua haujlwm ua haujlwm thiab F8 ntawm cov keyboard.
Xaiv Ib Cov Txheej Txheem Tsis Muaj Mob Hauv Excel Siv cov Keyboard
- Tshem tus cursor cell rau thawj lub cell uas koj xav xaiv.
- Nias thiab tso tus yuam sij F8 ntawm cov keyboard kom pib Extended Mode thiab los ua kom pom cov thawj ntawm tes.
- Tsis tau hloov tus cursor ntawm tes, nias thiab tso tawm cov haujlwm hauv Fift + F8 rau ntawm tus keyboard ua kom kaw hom qis dua.
- Siv cov xub tuav ntawm cov keyboard tshem tus cursor cell mus rau tom ntej ntawm tes koj xav highlight.
- Thawj lub xovtooj ntawm tes yuav tsum nyob twj ywm.
- Nrog tus cursor cell rau ntawm tus xovtooj ntawm tom ntej kom highlighted, rov ua cov kauj ruam 2 thiab 3 saum toj no.
- Ntxiv mus ntxiv cov hlwb kom muaj ntau yam siv los ntawm kev siv F8 thiab ua haujlwm + F8 yawm sij los pib thiab nres ncua kev hom.
Kev Xaiv Cov Txheej Txheem thiab Cov Txheej Txheem Tsis Xeem hauv Excel Siv cov Keyboard
Ua raws li cov kauj ruam hauv qab no yog tias qhov ntau yam koj xav xaiv yuav muaj sib xyaw kom haum ntawm cov uas nyob ib sab thiab ib tus neeg raws li muaj nyob hauv daim duab saum toj no.
- Txav mus rau tus cursor cell rau thawj lub cell rau cov pab pawg ntawm cov hlwb koj xav highlight.
- Nias thiab tso tawm F8 yawm sij ntawm cov keyboard kom pib Extended Mode.
- Siv cov xub tuav ntawm cov keyboard los rub lub ntau yam tseem ceeb kom muaj tag nrho cov hlwb hauv pawg.
- Nrog rau tag nrho cov hlwb hauv cov pab pawg xaiv xaiv thiab tso tawm haujlwm + F8 yawm sij nyob rau hauv cov keyboard ua ke kom kaw tau hom.
- Siv cov xub tuav ntawm cov keyboard tshem tus cursor ntawm tes kom deb ntawm cov xaiv ntawm cov hlwb.
- Thawj pab pawg ntawm lub hlwb yuav tsum nyob twj ywm.
- Yog tias muaj ntau ntau pawg hlwb uas koj xav ua kom pom tseeb, tsiv mus rau thawj lub xov tooj ntawm cov pab pawg thiab rov ua dua cov kauj ruam 2 mus rau 4 sab sauv.
- Yog tias muaj qee tus hlwb uas koj xav ntxiv rau ntau yam tseem ceeb, siv thawj txheej lus qhia saum toj no rau qhov tseem ceeb ntawm cov qe ntshav dawb.