Txhawm rau kom yooj yim rau kev ua haujlwm ntawm qhov project, Excel tus ntses yuav pab txhua lub sijhawm. Qhov ntau koj siv lawv, qhov yooj yim dua nws yuav yog rau koj los kho txhua lub rooj.
Excel Keyboard Shortcuts
Thaum ua haujlwm nrog Excel, nws yooj yim siv cov keyboard shortcuts tsis siv nas. Cov txheej txheem ua rooj ntawm cov kev pab cuam suav nrog ntau txoj haujlwm thiab kev ua haujlwm rau kev ua haujlwm nrog txawm tias cov feem ntau cov rooj thiab cov ntawv. Ib qho ntawm cov tseem ceeb yuav yog Ctrl, nws tsim cov kev siv sib txuas ua ke nrog txhua lwm tus.
Siv cov ntawv qhia siv keyboard nyob hauv Excel, koj tuaj yeem qhib, kaw cov ntawv, txav ib puag ncig ntawm ib daim ntawv, ua kev suav, thiab ntau ntxiv
Yog tias koj tsis ua haujlwm hauv Excel txhua lub sijhawm, ces nws zoo dua tsis txhob nkim koj lub sijhawm kawm thiab nco txog cov yuam sij kub.
Cov lus: pab sib txuas ua ke hauv Excel
Keyboard shortcut | Dab tsi txiav txim yuav ua |
Ctrl + Rho tawm | Xaiv kab ntawv yog deleted. |
Ctrl + kev + V | Kev teeb meem tshwj xeeb tshwm sim |
Ctrl + xee + | Hauv seem thiab kab ntxiv tau ntxiv. |
Ctrl + kos npe - | Xaiv kab los yog kab yog tshem tawm. |
Ctrl + D | Qhov qis qis dua tau sau nrog cov ntaub ntawv los ntawm lub xovtooj xaiv |
Ctrl + R | Qhov ntau ntawm sab xis yog ntim nrog cov ntaub ntawv los ntawm lub xovtooj xaiv. |
Ctrl + H | Tshawb-Hloov Qhov rai tshwm. |
Ctrl + Z | Kawg ua tau lawm os. |
Ctrl + Y | Kawg ua dua |
Ctrl + 1 | Lub xov tooj ntawm tes hloov kho ntawv qhib. |
Ctrl + B | Ntawv luam yog ntawv tuab |
Ctrl + Kuv | Italic teeb |
Ctrl + U | Cov ntsiab lus yog kos kab hauv qab. |
Ctrl + 5 | Lub ntsiab lus tseem ceeb raug cuam tshuam tawm. |
Ctrl + Sau | Txhua lub hlwb raug xaiv. |
Ctrl +; | Hnub tim qhia |
Ctrl + Kev Hloov +; | Lub sij hawm stamped |
Ctrl + Backspace | Tus cursor rov qab mus rau lub cell dhau los. |
Ctrl + Chaw | Tus ntawv sawv tawm |
Ctrl + A | Cov khoom siv pom yog cov tseem ceeb. |
Ctrl + Xaus | Tus ntsuas tus cim muab tso rau tus xovtooj kawg. |
Ctrl + Ua haujlwm + Thaum Kawg | Xeem ntawm tes yog tseem ceeb |
Ctrl + Xub | Tus cursor txav raws tus npoo ntawm kem hauv cov kev taw qhia. |
Ctrl + N | Phau ntawv tshiab tshwm |
Ctrl + S | Daim ntawv raug cawm dim |
Ctrl + O | Lub thawv tshawb rau cov ntawv xav qhib. |
Ctrl + L | Ntse lub rooj hom pib |
Ctrl + F2 | Saib ua ntej nrog |
Ctrl + K | Hyperlink ntxig |
Ctrl + F3 | Lub Npe Tus Thawj Tswj tau pib |
Daim ntawv ntawm Ctrl-kev tso ua ke dawb rau kev ua haujlwm hauv Excel los kuj tseem zoo siab:
- F9 yuav pib rov ua cov lej ib qho ntawm cov qauv, thiab hauv kev sib xyaw nrog Kev Hloov yuav ua qhov no tsuas yog nyob ntawm daim ntawv pom;
- F2 yuav hu rau tus kws sau ntawv rau lub xov tooj ntawm tes, thiab ua khub nrog Shift - nws cov ntawv;
- tus qauv "F11 + Shift" yuav tsim daim ntawv tshiab;
- Alt ua ke nrog ua haujlwm thiab tus xub xub yuav pab pawg txhua yam uas tau xaiv. Yog tias tus taw qhia taw mus rau sab laug, tom qab ntawv yauv sib tsoo yuav tshwm sim;
- Alt nrog ib tug xub tso yuav qhib daim ntawv teev cia nyob hauv lub cell;
- cov kab muab qhwv yuav ua los ntawm kev nias Alt + Enter;
- Kev ua haujlwm nrog qhov chaw seem yuav qhia txog lub rooj teeb.
Koj tseem yuav xav paub txog cov keyboard shortcuts uas koj tuaj yeem siv tau hauv Photoshop: //pcpro100.info/goryachie-klavishi-fotoshop/.
Lub nrig ntiv tes, tau kawm paub qhov chaw nyob ntawm cov yawm sij yuam, yuav tso koj lub qhov muag los ua haujlwm ntawm daim ntawv. Thiab tom qab ntawd qhov nrawm ntawm koj lub khoos phis tawj yuav dhau los ua lub nrawm.