txheem
- Txheej txheem cej luam
- Feem ntau siv cov keyboard shortcuts
- Keyboard Shortcuts rau Ribbon
- Siv Access Keys rau Ribbon Tabs
- Ua haujlwm nrog ribbon tabs siv cov keyboard
- Keyboard shortcuts rau cell formatting
- Keyboard shortcuts hauv Paste Special dialog box hauv Excel 2013
- Keyboard shortcuts rau kev ua thiab xaiv
- Keyboard shortcuts rau kev ua haujlwm nrog cov ntaub ntawv, kev ua haujlwm, thiab cov qauv bar
- Keyboard shortcuts hauv Power Pivot
- Keyboard shortcuts hauv Office add-ins
- Muaj nuj nqi
- Lwm cov keyboard shortcuts muaj txiaj ntsig
- xaus
Hotkeys yog qhov tshwj xeeb ntawm cov ntawv sau ntawv uas tso cai rau koj kom nkag mus tau sai rau qee yam haujlwm. Nyob rau hauv tsab xov xwm, peb yuav tham nyob rau hauv kev nthuav dav nrog dab tsi lub spreadsheet processor muaj cov yuam sij kub, thiab cov txheej txheem twg yuav siv tau nrog lawv.
Txheej txheem cej luam
Thaum pib, nco ntsoov tias lub cim ntxiv "+" qhia txog kev sib txuas ntawm cov nyees khawm. Ob qho "++" nyob rau hauv kab txhais tau hais tias "+" yuav tsum tau nias ua ke nrog lwm tus yuam sij ntawm cov keyboard. Cov yuam sij pabcuam yog cov nyees khawm uas yuav tsum tau nias ua ntej. Cov kev pabcuam suav nrog: Alt, Shift, thiab Ctrl.
Feem ntau siv cov keyboard shortcuts
Ua ntej, cia peb txheeb xyuas cov kev sib txuas nrov:
| XAIV + TAB | Rov qab mus rau qhov chaw dhau los lossis qhov chaw kawg hauv lub qhov rais. |
| XUB ↑ | Txav mus rau sab saum toj ntawm 1 daim teb ntawm daim ntawv. |
| XUB Ncua | Txav mus rau sab hauv qab los ntawm 1 daim teb ntawm daim ntawv. |
| XUB ← | Txav mus rau sab laug los ntawm 1 daim teb ntawm daim ntawv. |
| XUB → | Txav mus rau sab xis los ntawm 1 daim teb ntawm daim ntawv. |
| CTRL + xub khawm | Txav mus rau qhov kawg ntawm cheeb tsam cov ntaub ntawv ntawm daim ntawv. |
| Thaum kawg, tus xub khawm | Txav mus rau qhov ua haujlwm hu ua "End". Disabling ua haujlwm. |
| CTRL + END | Kev txav mus rau qhov ua tiav ntawm daim ntawv. |
| CTRL + SHIFT + END | Zoom nyob rau hauv qhov chaw cim rau lub xeem siv cell. |
| LUB TSEV + SCROLL LOCK | Txav mus rau lub xovtooj ntawm tes uas nyob rau sab laug sab laug ntawm thaj chaw. |
| NPLOOJ NTAWV | Txav mus rau 1 qhov screen hauv daim ntawv. |
| CTRL + PAGE DUA | Txav mus rau lwm daim ntawv. |
| ALT+PAGE DOWNLOAD | Txav mus rau 1 lub vijtsam mus rau sab xis ntawm daim ntawv. |
| Nplooj ntawv | Txav mus 1 tshuaj ntsuam rau daim ntawv. |
| ALT + PAGE UP | Txav mus rau 1 lub vijtsam mus rau sab laug ntawm daim ntawv. |
| CTRL + PAGE UP | Rov qab mus rau daim ntawv dhau los. |
| Tab | Txav mus rau 1 daim teb mus rau sab xis. |
| ALT + XUBNcua | Qhib daim ntawv tshuaj xyuas rau ib thaj chaw. |
| CTRL + ALT + 5 ua raws li ob peb TAB nias | Kev hloov pauv ntawm cov duab txav (cov ntawv, duab, thiab lwm yam). |
| CTRL + SHIFT | Kab rov tav scroll. |
Keyboard Shortcuts rau Ribbon
Nias "ALT" qhia kev sib txuas ntawm cov nyees khawm ntawm lub toolbar. Qhov no yog ib tug hint rau cov neeg siv uas tseem tsis tau paub tag nrho cov hotkeys.
Siv Access Keys rau Ribbon Tabs
| TXHUA, F | Nkag mus rau hauv ntu "Cov ntaub ntawv" thiab siv Backstage. |
| ALT, ib | Nkag mus rau hauv ntu "Tsev", tsim cov ntawv nyeem lossis cov ntaub ntawv xov xwm. |
| TXHUA YAM, S | Nkag mus rau hauv ntu "Insert" thiab ntxig ntau yam khoom. |
| ALT + PIB | Nkag mus rau hauv seem "Page Layout". |
| ALT, L | Nkag mus rau hauv seem "Formula". |
| ALT + | Nkag mus rau ntu "Cov ntaub ntawv". |
| ALT + R | Nkag mus rau ntu "Tshawb xyuas"Cov. |
| ALT + AW | Nkag mus rau ntu "Saib". |
Ua haujlwm nrog ribbon tabs siv cov keyboard
| F10 los yog ALT | Xaiv cov ntu nquag ntawm lub toolbar thiab qhib cov khawm nkag. |
| XAIV + TAB | Nkag mus rau ribbon commands. |
| Xub nyees khawm | Kev txav mus los ntawm kev sib txawv ntawm cov khoom ntawm daim kab xev. |
| ENTER los yog qhov chaw | Qhib lub khawm xaiv. |
| XUB Ncua | Tshaj tawm cov npe ntawm pab pawg uas peb tau xaiv. |
| ALT + XUB Ncua | Qhib cov ntawv qhia zaub mov ntawm lub pob uas peb tau xaiv. |
| XUB Ncua | Hloov mus rau cov lus txib tom ntej hauv lub qhov rais nthuav dav. |
| CTRL + F1 | Folding los yog nthuav tawm. |
| Hloov + F10 | Qhib cov ntawv qhia zaub mov. |
| XUB ← | Hloov mus rau cov khoom submenu. |
Keyboard shortcuts rau cell formatting
| Ctrl + B | Qhib hom ntawv bold. |
| Ctrl + Kuv | Qhib hom ntawv italic. |
| Ctrl + U | Pab kom underlining. |
| Alt + H + H | Xaiv lub tint ntawm cov ntawv nyeem. |
| Alt + H + B | Ncej qhib. |
| Ctrl + Ua haujlwm + & | Activation ntawm contour ib feem. |
| Ctrl + Ua haujlwm + _ | Tua cov thav duab. |
| Ctrl + 9 | Nkaum kab uas xaiv. |
| Ctrl + 0 | Nkaum cov kab uas xaiv. |
| Ctrl + 1 | Qhib lub qhov rai Format Cells. |
| Ctrl + 5 | Ua kom muaj kev tawm tsam. |
| Ctrl + Ua haujlwm + $ | Kev siv nyiaj txiag. |
| Ctrl + Ua haujlwm +% | Siv ib feem pua. |
Keyboard shortcuts hauv Paste Special dialog box hauv Excel 2013
Qhov no version ntawm spreadsheet editor muaj ib tug tshwj xeeb feature hu ua Paste Special.
Cov hotkeys hauv qab no yog siv rau hauv lub qhov rais no:
| A | Ntxiv tag nrho cov ntsiab lus. |
| F | Ntxiv cov qauv. |
| V | Ntxiv qhov muaj nuj nqis. |
| T | Ntxiv tsuas yog tus thawj formatting. |
| C | Ntxiv sau ntawv thiab sau ntawv. |
| N | Ntxiv kev xaiv scan. |
| H | Ntxiv cov qauv. |
| X | Ntxiv yam tsis muaj ciam teb. |
| W | Ntxiv nrog rau qhov dav dav. |
Keyboard shortcuts rau kev ua thiab xaiv
| Shift + ARROW → / ← | Nce qhov chaw xaiv rau sab xis lossis sab laug. |
| Hloov + Space | Xaiv tag nrho cov kab. |
| Ctrl+Space | Xaiv tag nrho kem. |
| Ctrl + Ua haujlwm + Space | Xaiv tag nrho daim ntawv. |
Keyboard shortcuts rau kev ua haujlwm nrog cov ntaub ntawv, kev ua haujlwm, thiab cov qauv bar
| F2 | Teb hloov. |
| Ua haujlwm + F2 | Ntxiv ib daim ntawv. |
| Ctrl + X | Txiav tawm cov ntaub ntawv los ntawm daim teb. |
| Ctrl + C | Luam cov ntaub ntawv los ntawm ib daim teb. |
| Ctrl + V | Ntxiv cov ntaub ntawv los ntawm daim teb. |
| Ctrl + kev + V | Qhib qhov "Special Attachment" qhov rai. |
| Rho tawm | Tshem tawm qhov txhaws ntawm daim teb. |
| Alt + Nkag mus | Ntxig ib qho rov qab rau hauv ib qho chaw. |
| F3 | Ntxiv lub npe teb. |
| Alt + H + D + C | Tshem tawm ib kab. |
| Esc | Ncua tseg nkag rau hauv ib daim teb. |
| Sau | Filling nyob rau hauv lub tswv yim nyob rau hauv lub teb. |
Keyboard shortcuts hauv Power Pivot
| PCM | Qhib cov ntawv qhia zaub mov. |
| CTRL + A. | Xaiv tag nrho lub rooj. |
| CTRL + D. | Tshem tag nrho lub rooj tsavxwm. |
| CTRL + M. | Tsiv lub phaj. |
| CTRL + R. | Renaming ib lub rooj. |
| CTRL + S. | Tseg. |
| CTRL + Y | Duplication ntawm cov txheej txheem dhau los. |
| CTRL + Z ua ke | Rov qab los ntawm cov txheej txheem heev. |
| F5 | Qhib lub qhov rais "Go". |
Keyboard shortcuts hauv Office add-ins
| CTRL + ua haujlwm + F10 | Qhib ntawv qhia zaub mov. |
| CTRL + SPACE | Tshaj tawm ntawm thaj chaw ua haujlwm. |
| CTRL + SPACE thiab tom qab ntawd nyem rau ntawm Kaw | Kaw qhov chaw ua haujlwm. |
Muaj nuj nqi
| F1 | Pab kom pab. |
| F2 | Kho cov cell xaiv. |
| F3 | Txav mus rau lub npov "Npe tom kawg". |
| F4 | Rov ua dua qhov ua dhau los. |
| F5 | Mus rau lub qhov rais "Go". |
| F6 | Hloov ntawm cov ntsiab lus ntawm lub rooj editor. |
| F7 | Qhib lub qhov rais "Spelling". |
| F8 | Qhib kev xaiv txuas ntxiv. |
| F9 | Daim ntawv suav. |
| F10 | Qhib cov lus qhia. |
| F11 | Ntxiv ib daim duab. |
| F12 | Mus rau qhov "Save As" qhov rai. |
Lwm cov keyboard shortcuts muaj txiaj ntsig
| Alt +' | Qhib lub cell style kho qhov rai. |
| BACKSPACE
| Rho tawm ib tug cim. |
| Sau | Xaus ntawm cov ntaub ntawv teev. |
| ESC | Ncua tseg teeb. |
| TSEV | Rov qab mus rau qhov pib ntawm daim ntawv lossis kab. |
xaus
Tau kawg, muaj lwm cov yuam sij kub hauv daim ntawv teev cov editor. Peb tau tshuaj xyuas cov kev sib txuas uas nrov tshaj plaws thiab siv ntau tshaj plaws. Kev siv cov yuam sij no yuav pab cov neeg siv ua haujlwm sai dua hauv cov ntawv sau ua haujlwm.