Yuav kom yooj yim rau kev ua hauj lwm rau ntawm qhov kev txhim kho no yuav pab kom tau Excel hotkeys. Ntau zaus koj yuav siv lawv, qhov yooj yim tshaj koj yuav tsum hloov tej ntxhuav.
Excel hotkeys
Thaum ua hauj lwm nrog Excel nws yog yooj yim los siv keyboard shortcuts es tsis txhob siv tus nas. Cov lus sib tham ntawm qhov kev zov me nyuam muaj ntau lub zog thiab nta kom ua hauj lwm nrog cov txheej txheem ntau thiab cov ntaub ntawv. Ib qho ntawm cov yawm sij tseem ceeb yuav tsum yog Ctrl, nws cov ntaub ntawv muaj kev sib raug zoo nrog txhua tus neeg.
Siv cov keyboard shortcuts hauv Excel, koj tuaj yeem qhib, kaw cov ntawv txheeb, los ntawm cov ntaub ntawv, ua cov lus teb thiab ntau ntxiv.
Yog tias koj tsis ua hauj lwm hauv Excel txhua lub sijhawm, nws yog qhov zoo dua tsis txhob siv sij hawm rau kev kawm thiab cim cov kub tuav.
Cov Ntaub Ntawv: Pab Tau Txiaj Ntsig Zoo
| Tseem ceeb ua ke | Yuav tau ua dab tsi |
| Ctrl + rho tawm | Cov ntawv xaiv tau muab deleted. |
| Ctrl + Nres + V | Kev tshwj xeeb zoo tshwm sim |
| Ctrl + kos npe + | Cov kab tuav pov tseg thiab kab yog ntxiv. |
| Ctrl + kos npe - | Cov kab xaiv lossis kab yog rho tawm. |
| Ctrl + D | Qhov qis qis dua lawm muaj cov ntaub ntawv los ntawm cov xov tooj ntawm tes xaiv. |
| Ctrl + R | Qhov ntau ntawm sab xis yog sau nrog cov ntaub ntawv ntawm lub xov tooj ntawm tes xaiv. |
| Ctrl + H | Lub Tshawb Nrhiav Tshawb Pom. |
| Ctrl + Z | Tshem tawm haujlwm kawg |
| Ctrl + Y | Kev txiav txim kawg yog rov ua dua. |
| Ctrl + 1 | Lub hom xov tooj ntawm tes editor opens. |
| Ctrl + B | Bold text |
| Ctrl + Kuv | Kev hloov kho ntawm txoj kev kho yog qhov kev kawm. |
| Ctrl + U | Cov ntawv sau tseg |
| Ctrl + 5 | Cov ntawv xaiv tau raug tso tawm |
| Ctrl + Sau | Sau tag nrho cov hlwb xaiv |
| Ctrl +; | Hnub tau qhia |
| Ctrl + ua haujlwm +; | Lub sij hawm stamped |
| Ctrl + Backspace | Cursor rov qab mus rau yav dhau los ntawm tes. |
| Ctrl + Spacebar | Sawv ntsug |
| Ctrl + A | Cov khoom uas pom tau hais tseem ceeb. |
| Ctrl + kawg | Tus cursor yog teem rau ntawm lub xeem ntawm tes. |
| Ctrl + ua haujlwm + kawg | Lub xeem cell yog tseem ceeb. |
| Ctrl + Sub | Tus cursor tsiv ntawm cov npoo ntawm kem hauv cov kev taw qhia ntawm cov xib xub |
| Ctrl + N | Ib tug tshiab phau ntawv tshwm. |
| Ctrl + S | Cov ntaub ntawv tseg |
| Ctrl + O | Cov ntaub ntawv tshawb nrhiav opens. |
| Ctrl + L | Ntse Cov Hom Pib pib. |
| Ctrl + F2 | Kev saib ua ntej yog muaj. |
| Ctrl + K | Hyperlink tso |
| Ctrl + F3 | Tus neeg saib xyuas lub npe pib. |
Daim ntawv uas tsis yog-Ctrl ob peb ua ke rau kev ua hauj lwm hauv Excel kuj yog qhov tseem ceeb heev:
- F9 yuav pib lub recalculation ntawm cov qauv, thiab nrog Shift nws yuav ua nws tsuas rau ib daim ntawv pom;
- F2 yuav hu tus editor rau ib lub xov tooj ntawm tes, thiab khub nrog ua haujlwm - nws cov lus sau;
- cov mis "F11 + Shift" yuav tsim ib daim ntawv dawb paug;
- Ua ke nrog ua haujlwm thiab cov xub mus rau sab xis yuav pab txhua yam uas tau xaiv. Yog hais tias lub xub taw rau sab laug, ces ungrouping yuav tshwm sim;
- Tshem nrog lub xub xub yuav qhib cov ntawv teev npe ntawm qhov teev ntawm tes;
- tus kab yuav tsiv thaum koj nias lub npe + Nkag mus;
- Ua haujlwm nrog ib qhov chaw yuav qhia txog tus kab hauv lub rooj.
Tej zaum koj tseem yuav nyiam ua cov keyboard shortcuts koj siv tau hauv Photoshop:
Ntiv tes, coj lub chaw ntawm cov khawv koob hauv qhov chaw, yuav tso lawv qhov muag los ua haujlwm ntawm daim ntawv. Thiab ces qhov ceev ntawm koj txoj kev ua ub ua no hauv lub computer yuav ua rau yoo mov tiag tiag.
