Cov xov xwm yog cov ua haujlwm, los ntawm kev sau ib qho tseem ceeb ua ke ntawm cov keyboard, muaj kev nkag yooj yim rau qee qhov nta ntawm qhov kev khiav hauj lwm, los yog ib qho kev kawm cais. Qhov cuab yeej no kuj muaj rau Microsoft Excel. Cia peb saib seb cov hotkeys nyob hauv Excel, thiab koj yuav ua li cas nrog lawv.
Cov lus qhia dav dav
Ua ntej tshaj plaws, nws yuav tsum raug sau tseg tias nyob hauv daim ntawv teev cov kub tuav hauv qab no, ib qho "+" kos npe yuav yog ib lub cim uas qhia tias kev sib txuam tseem ceeb. Yog hais tias tus kos npe "++" yog qhia - qhov no txhais tau hais tias ntawm tus keyboard koj yuav tsum nias qhov "+" key nrog rau lwm qhov tseem ceeb uas tau hais tseg. Lub npe ntawm tus yuam sij muaj qhia raws li lawv tau teev nyob rau hauv cov keyboard: F1, F2, F3, thiab lwm yam.
Tsis tas li ntawd, nws yuav tsum tau hais tias thawj zaug xav tau kev pabcuam yuam sij. Cov no suav nrog Shift, Ctrl thiab Alt. Thiab tom qab ntawd, thaum tuav cov yawm sij, nias ntawm qhov muaj nuj nqi tuav, khawm nrog ntawv, zauv, thiab lwm yam cim.
General Settings
Cuab yeej tswj cov cuab yeej ntawm Microsoft muaj cov txheej txheem yooj yim ntawm qhov kev pab cuam: qhib, txuag, tsim cov ntaub ntawv, thiab lwm yam. Cov hauv siab kub uas muab rau cov haujlwm no muaj xws li hauv qab no:
- Ctrl + N - tsim cov ntaub ntawv;
- Ctrl + S - tseg phau ntawv;
- F12 - xaiv hom ntawv thiab qhov chaw ntawm phau ntawv khaws tseg;
- Ctrl + O - qhib phau ntawv tshiab;
- Ctrl + F4 - kaw phau ntawv;
- Ctrl + P - luam saib ua ntej;
- Ctrl + A - xaiv tag nrho daim ntawv.
Navigation tuav
Yog xav txheeb cov ntawv lossis cov phau ntawv, dhau lawm, kom lawv muaj cov yuam sij kub.
- Ctrl + F6 - tsiv ntawm ob peb phau ntawv uas qhib;
- Tab - txav mus rau tom ntej ntawm tes;
- Shift + Tab - tsiv mus rau yav dhau los ntawm tes;
- Page Up - txav mus rau qhov luaj li cas ntawm lub monitor;
- Page Down - txav mus rau kev saib loj;
- Ctrl + Page Up - txav mus rau yav dhau los lub npe;
- Ctrl + Page Down - txav mus rau daim ntawv tom ntej;
- Ctrl + Xaus - txav mus rau lub xeem cell;
- Ctrl + Home - txav mus rau tus thawj ntawm tes.
Hotkeys rau kev ua ub no
Microsoft Excel siv tsis yog siv yooj yim ntawm cov ntxhuav xwb, tab sis kuj yog rau kev ua raws li cov txheej txheem hauv lawv, thaum nkag mus hauv cov qauv. Rau kev nkag tau ceev cov kev ua no, muaj cov yuam sij kub.
- Alt + = - ua kom avtosummy;
- Ctrl + ~ - tso tawm cov kev tshwm sim hauv hlwb;
- F9 - recalculation ntawm tag nrho cov qauv hauv cov ntaub ntawv;
- Ua haujlwm + F9 - recalculation ntawm cov qauv ntawm cov ntawv sau;
- Shift + F3 - hu rau qhov haujlwm ua haujlwm.
Cov ntaub ntawv editing
Cov ntawv txhim kho rau kev kho cov ntaub ntawv tso cai rau koj kom sai sai rau hauv ib lub rooj nrog cov ntaub ntawv.
- F2 - kho kom raug hom kev xaiv ntawm tes;
- Ctrl ++ - ntxiv kab lossis kab;
- Ctrl + - - tshem tawm txhua kab los yog kab rau ntawm ib daim ntawv ntawm Microsoft Excel cov lus;
- Ctrl + rho tawm - rho tawm cov ntawv nyeem;
- Ctrl + H - Tshawb nrhiav / hloov qhov rai;
- Ctrl + Z - undo qhov kev nqis tes ua tas los;
- Ctrl + Alt + V - tshwj xeeb ntxig.
Formatting
Ib qho tseem ceeb ntawm cov qauv ntawm cov ntxhuav thiab ntau hom qe tsim tawm. Tsis tas li ntawd, formatting kuj cuam tshuam rau cov txheej txheem hauv Excel.
- Ctrl + Ua haujlwm +% - xam ntawm feem pua hom;
- Ctrl + ua haujlwm + $ - hom ntawv tus nqi;
- Ctrl + Ua haujlwm + # hnub hom;
- Ctrl + ua haujlwm +! - hom ntawm cov lej;
- Ctrl + Ua haujlwm + ~ - ntau hom;
- Ctrl + 1 - activates lub xovtooj ntawm hom ntawv lub tshuab.
Lwm cov hotkeys
Ntxiv rau cov hotkeys uas tau muab teev tseg rau hauv cov pawg saum toj no, Excel muaj cov ntsiab lus nram qab no ntawm cov keyboard rau kev hu xov tooj ua haujlwm:
- Alt + '- qhov kev xaiv ntawm style;
- F11 - tsim ib daim ntawv rau ntawm daim ntawv tshiab;
- Ua haujlwm + F2 - hloov cov lus hauv cell;
- F7 - ntawv tshawb nrhiav cov teeb meem.
Tau kawg, tsis tag nrho cov kev xaiv rau kev siv khawm kub hauv Microsoft Excel tau qhia saum toj no. Txawm li cas los xij, peb tau ua tib zoo saib xyuas rau cov neeg nyiam, cov tseem ceeb, thiab xav tau ntawm lawv. Tau kawg, kev siv cov hauv siab kub kuj yooj yim li thiab ua kom cov hauj lwm hauv Microsoft Excel.
