Excel Keyboard Shortcuts

Pin
Send
Share
Send

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 shortcutDab tsi txiav txim yuav ua
Ctrl + Rho tawmXaiv kab ntawv yog deleted.
Ctrl + kev + VKev 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 + DQhov qis qis dua tau sau nrog cov ntaub ntawv los ntawm lub xovtooj xaiv
Ctrl + RQhov ntau ntawm sab xis yog ntim nrog cov ntaub ntawv los ntawm lub xovtooj xaiv.
Ctrl + HTshawb-Hloov Qhov rai tshwm.
Ctrl + ZKawg ua tau lawm os.
Ctrl + YKawg ua dua
Ctrl + 1Lub xov tooj ntawm tes hloov kho ntawv qhib.
Ctrl + BNtawv luam yog ntawv tuab
Ctrl + KuvItalic teeb
Ctrl + UCov ntsiab lus yog kos kab hauv qab.
Ctrl + 5Lub ntsiab lus tseem ceeb raug cuam tshuam tawm.
Ctrl + SauTxhua lub hlwb raug xaiv.
Ctrl +;Hnub tim qhia
Ctrl + Kev Hloov +;Lub sij hawm stamped
Ctrl + BackspaceTus cursor rov qab mus rau lub cell dhau los.
Ctrl + ChawTus ntawv sawv tawm
Ctrl + ACov khoom siv pom yog cov tseem ceeb.
Ctrl + XausTus ntsuas tus cim muab tso rau tus xovtooj kawg.
Ctrl + Ua haujlwm + Thaum KawgXeem ntawm tes yog tseem ceeb
Ctrl + XubTus cursor txav raws tus npoo ntawm kem hauv cov kev taw qhia.
Ctrl + NPhau ntawv tshiab tshwm
Ctrl + SDaim ntawv raug cawm dim
Ctrl + OLub thawv tshawb rau cov ntawv xav qhib.
Ctrl + LNtse lub rooj hom pib
Ctrl + F2Saib ua ntej nrog
Ctrl + KHyperlink ntxig
Ctrl + F3Lub 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.

Pin
Send
Share
Send