Excel Shortcuts

Excel Shortcut Key Combinations rau cov cuab yeej thiab nta

Kawm tag nrho cov kev daws teeb meem, nrog rau kev ua ke kom coj kom zoo dua ntawm Excel mus rau nws cov peev txheej.

01 ntawm 27

Ntxig ib Daim Ntawv Sau Npe Tshiab hauv Excel

Hom ntawv Excel no qhia tias koj yuav ua li cas rau daim ntawv khij nyiab tshiab rau hauv ib phau ntawv siv cov keyboard shortcut. Ntxig ib Daim Ntawv Qhia Tshiab Tshiab Siv Cov Keyboard Shortcut Nias thiab tuav lub khawm SHIFT rau cov keyboard. Nias thiab tso F11 yawm ntawm cov keyboard. Daim ntawv ua haujlwm tshiab yuav muab tso rau hauv phau ntawv ua haujlwm tam sim no. Txhab ntxiv cov ntawv khom nqi ntxiv mus nias thiab tso F11 yawm sij thaum tuav ntawm qhov tseem ceeb SHIFT. Ntau »

02 ntawm 27

Qhwv Ntawv ntawm Ob Kab hauv Excel

Sau cov ntawv xov xwm hauv xovtooj Yog tias koj xav kom ntawv sau rau ntau hom kab hauv ib lub xovtooj, koj tuaj yeem tsim lub xovtooj ntawm lub xovtooj kom cov ntawv sau tau cia, lossis koj tuaj yeem nkag mus rau ntawm daim ntawv qhia kab. Koj xav ua dab tsi? Muab cov ntawv sau cia tuaj Nkag mus rau hauv kab ntawv Khwv tau kab ntawv Sau ntawv hauv daim ntawv ua haujlwm, xaiv lub hlwb uas koj xav tau. Nyob rau hauv lub Tsev tab, nyob hauv Pab Pawg Txheej Txheem, nias Hloov Phau Ntawv Khawm cov duab. Excel Ribbon Image Sau ntawv Cov ntaub ntawv nyob rau hauv lub xovtooj ntawm hnav kom haum rau qhov dav dav. Thaum koj hloov qhov dav dav, cov ntaub ntawv wrapping adjusts txiav. Yog hais tias tag nrho cov ntawv qhwv tsis pom, nws yuav yog vim hais tias kab yog teem rau ib qhov siab lossis cov ntawv nyeem yog nyob rau hauv ib chav ntawm cov hlwb uas tau muab ua ke. Ua kom tag nrho cov ntawv qhwv ntsej muag, ua cov hauv qab no kom tswj tau qhov siab ntxiv: Xaiv lub xov tooj ntawm tes los yog qhov chaw uas koj xav hloov kho qhov siab. Nyob hauv lub Tsev tab, hauv cov Pab Pawg, ntaus cim. Excel Ribbon Image Hauv Qhov Hwj Hov, ua ib yam ntawm cov nram qab no: Yuav tsum kho qhov siab qhov kab, nws pib AutoFit siab qhov siab. Qhia kom meej rau qhov siab, nws nias qhov siab, thiab tom qab ntawd ces ntaus qhov siab uas koj xav tau ntawm qhov siab ntawm lub npov siab. Tswv yim Koj tseem tuaj yeem rub tus ciam teb hauv qab ntawm kab mus rau qhov siab uas qhia tag nrho qhwv ntawv. Top of Page Page Top of Page Nkag mus rau ib kab kev poob qaum Koj tuaj yeem pib cov kab ntawv tshiab ntawm txhua qhov chaw hauv xovtooj. Ob-nias lub xov tooj ntawm tes uas koj xav nkag mus rau ib kab txuas. Keyboard shortcut Koj tuaj yeem xaiv lub xov tooj ntawm tes, thiab tom qab ntawd nias F2. Hauv xovtooj, nyem qhov chaw uas koj xav ua txhaum txoj kab, ces nias ALT + ENTER.

Excel's qhwv ntawv cov ntawv nyeem yog ib qho kev siv rau kev ua kom haum uas ua rau koj tswj kev saib cov ntawv lo thiab cov npe nyob hauv koj qhov spreadsheet .

Cov ntawv sau ntawv tso cai rau koj muab cov ntawv sau rau ntau kab hauv ib lub xov tooj xwb es tsis muaj cov ntawv nyeem ua ntau lub hlwb nyob hauv daim ntawv ua haujlwm .

Cov "technical" lub sij hawm rau qhov kev ua yeeb yam no yog muab cov ntawv nyeem thiab cov ntsiab lus tseem ceeb rau cov ntawv nyeem yog:

Alt + Sau

Piv txwv: Siv Shortcut Ability to Wrap Text

Piv txwv li siv Excel's qhwv ntawv sau:

1. Hauv xov tooj ntawm tes D1 ntaus ntawv: Cov Nyiaj Tau Los Txhua Hli thiab nias lub Nkag Mus rau ntawm cov keyboard.
2. Txij li thaum lub ntsiab lus ntev dhau los rau ntawm tes, nws yuav tsum txeej mus rau hauv lub cell E1.
3. Hauv Cell E1 cov ntawv nyeem: Cov Nyiaj Siv Txhua Hli thiab nias tus Enter nkag rau ntawm cov keyboard.
4. Thaum nkag mus rau hauv cov ntaub ntawv hauv E1 daim ntawv lo ntawm D1 yuav tsum tau txiav tawm ntawm qhov kawg ntawm tes D1. Zoo li, cov ntawv hauv E1 yuav tsum txeej mus rau hauv lub xovtooj mus rau sab xis.
5. Txhawm rau kho qhov teeb meem nrog cov ntawv lo no, qhia lub hlwb D1 thiab E1 hauv daim ntawv ua haujlwm.
6. Ndliv lub tsev tab.
7. Nias rau ntawm pob ntawv khawm ntawm daim ntawv sau .
8. Cov ntawv hauv hlwb D1 thiab E1 yuav tsum tam sim no ob leeg pom nrog cov ntawv nyeem tawg ua ob kab uas tsis muaj txeej mus rau hauv cov hlwb uas nyob ib sab.

Excel's qhwv ntawv cov ntawv nyeem yog ib qho kev siv rau kev ua kom haum uas ua rau koj tswj kev saib cov ntawv lo thiab cov npe nyob hauv koj qhov spreadsheet. Es tsis txhob ua daim ntawv sau ua haujlwm txhua lub sijhawm kom pom cov ntawv luv luv, cov ntawv qhwv ntawv tso cai rau koj sau cov ntawv rau ntau hom kab hauv ib lub xov tooj ntawm tes. Excel's Wrap Text Example Rau kev pab nrog qhov kev piv txwv no, saib daim duab saum toj no. Hauv xov tooj ntawm tes G1 cov ntawv nyeem: Nyiaj Tau Los Txhua Hli thiab nias qhov ENTER yawm ntawm cov ntawv. Txij li thaum Cov Nyiaj Khwv Tau Los Ib Ntus ntev rau nws lub cell, nws yuav txeej mus rau hauv H1 cell. Hauv cell H1 hom ntawv nyeem: Cov Nyiaj Siv Txhua Hli thiab nias qhov ENTER yawm ntawm cov ntawv. Thaum cov ntaub ntawv muab nkag rau hauv H1 lub npe ntawm thawj daim ntawv txhua hli yuav tsum tau txiav tawm. Txhawm rau kho qhov teeb meem, luag xaiv lub hlwb G1 thiab H1 ntawm daim ntawv khom nqi los ua rau lawv. Ndliv lub tsev tab. Nias rau ntawm pob ntawv khawm ntawm daim ntawv sau. Cov ntawv nyob rau hauv hlwb G1 thiab H1 yuav tsum tam sim no ob leeg yuav pom nrog cov ntawv nyeem tawg mus rau hauv ob kab uas tsis muaj txeej mus rau hauv lub hlwb uas nyob ib sab.

Cov ntawv nyeem no qhia txog yuav ua li cas rau ntau hom kab hauv ib daim ntawv khom nqi ntawm tes.

Cov "technical" lub sij hawm rau qhov kev ua yeeb yam no yog muab cov ntawv nyeem thiab cov ntsiab lus tseem ceeb rau cov ntawv nyeem yog:

Alt + Sau

Piv txwv: Siv Shortcut Ability to Wrap Text

Siv Excel's qhwv ntawv cov ntawv siv uas yog siv cov keyboard xwb:

1. Nias ntawm lub xov tooj ntawm tes uas koj xav kom cov ntawv nyeem
2. Ntaus thawj kab ntawm cov ntawv nyeem
3. Nias thiab tuav lub pob hauv qab ntawm cov keyboard
4. Nias thiab tso Tus Ntaus Yav Nias rau ntawm cov keyboard tsis tso cov Alt yuam
5. Tshem tus yuam sij Alt
6. Cov ntsiab lus ntxig yuav tsum tsiv mus rau kab hauv qab cov ntawv nyeem xwb
7. Nias thib ob kab ntawv ntawm phau ntawv
8. Yog tias koj xav nkag rau ntau tshaj li ob kab ntawm cov ntawv nyeem, txuas mus rau Alt + Nkag ntawm qhov kawg ntawm txhua kab
9. Thaum tag nrho cov ntawv tau raug ntaus, nias tus Sau rau ntawm tus keyboard lossis nias nrog nas mus rau lwm lub xov tooj

Ntau »

03 ntawm 27

Ntxiv Hnub Tim

Cov ntawv nyeem no qhia txog yuav ua li cas kom sai rau hnub no rau ib daim ntawv hais txog kev siv cov keyboard xwb.

Qhov kev sib txuam tseem ceeb rau kev ntxiv hnub yog:

Ctrl + ; (qhov tseem ceeb hauv lub vev xaib)

Piv txwv: Siv Cov Yuam Sij Ntaus Nkag Mus Ntxiv Hnub Tamsis No

Ntxiv rau hnub tim rau ib daim ntawv uas siv cov keyboards xwb:

1. Nias ntawm lub xovtooj uas koj xav kom lub sijhawm mus.
2. Nias thiab tuav lub Ctrl qhov tseem ceeb ntawm cov keyboard.
3. Nias thiab tso lub pob nyem ( ; ) ntawm cov keyboard tsis tso tus yuam sij Ctrl.
4. Tso Ctrl yuam.
5. Cov hnub tim yuav tsum muab ntxiv rau daim ntawv ua haujlwm hauv xaiv lub xov tooj.

Lus Cim: Cov keyboard shortcut no tsis ua kom siv cov hnub ua haujlwm ces lub hnub tsis hloov txhua zaus ntawm cov ntawv ua haujlwm tau qhib los yog rov ua dua. Ntau »

04 ntawm 27

Sum Cov Ntaub Ntawv hauv Excel Siv Shortcut Daws

Sum Cov Ntaub Ntawv hauv Excel Siv Shortcut Daws

Cov lus no qhia txog yuav ua li cas kom sai sai rau Excel lub SUM muaj nuj nqi ntxiv cov ntaub ntawv siv cov yaum sij luv ntawm cov keyboard.

Txoj kev sib txuam tseem ceeb kom nkag mus rau SUM ua haujlwm:

" Alt " + " = "

Piv Txwv: Nkag mus rau SUM Function siv Shortcut Keys

1. Sau cov ntaub ntawv nram qab no rau hauv hlwb D1 rau D3 ntawm daim ntawv ua haujlwm Excel: 5, 6, 7
2. Yog tias tsim nyog, nias ntawm tes D4 los ua nws lub xovtooj ntawm tes
3. Nias thiab tuav lub pob hauv qab ntawm cov keyboard
4. Nias thiab tso daim ntawv sib npaug ( = ) ntawm cov keyboard tsis tso tus yuam kev Alt
5. Tshem tus yuam sij Alt
6. Cov kev ua haujlwm SUM yuav tsum muab tso rau hauv D4 cell nrog rau ntau yam D1: D3 tseem ceeb raws li qhov kev ua haujlwm qhov sib cav
7. Nias tus yuam sij nkag rau hauv cov keyboard kom tiav qhov kev ua haujlwm
8. Cov lus teb 18 yuav tsum tshwm sim hauv xov tooj ntawm tes D4
9. Thaum koj nias rau ntawm tes D4 qhov ua tiav tiav = SUM (D1: D3) tshwm nyob hauv qhov qauv mis saum toj sau nplooj ntawv.

Qhov shortcut no yuav muab siv los sau cov ntsiab lus hauv kab thiab txhua kab.

Lus Cim : Lub NUM yog tsim los nkag rau hauv qab ntawm ib kem ntawm cov ntaub ntawv los sis ntawm txoj cai kawg ntawm kab kev qhia.

Yog hais tias lub SUM kev ua haujlwm nkag mus rau hauv ib qho chaw tsis yog cov ob, qhov ntau ntawm cov hlwb xaiv tau tias qhov kev ua haujlwm qhov kev sib cav yuav tsis muaj tseeb.

Hloov cov npuaj uas raug xaiv, siv tus pointer nas mus rau ntau qhov tseeb ua ntej nias tus Sau yuam mus ua kom tiav qhov haujlwm ntxiv »

05 ntawm 27

Ntxiv rau lub sijhawm tam sim no

Cov ntawv nyeem no qhia txog yuav ua li cas kom sai dua lub sij hawm tam sim no rau ib daim ntawv uas siv cov keyboards xwb:

Lub sijhawm tseem ceeb rau kev ntxiv sijhawm yog:

Ctrl + Ua haujlwm + : (tus nyom yawm sij)

Piv txwv: Siv Shortcut Key to Add Current Time

Ntxiv rau lub sij hawm tam sim no rau ib daim ntawv uas siv cov keyboard xwb:

1. Nias ntawm lub xovtooj uas koj xav kom lub sijhawm mus.
   
   
2. Nias thiab tuav lub Ctrl thiab cov ua haujlwm khawm ntawm cov keyboard.
   
   
3. Nias thiab tso cov nyuv qhov tseem ceeb ( :) ntawm cov keyboard tsis tso cov Ctrl thiab cov kauj vuam txav.
   
   
4. Lub sij hawm tam sim no yuav muab ntxiv rau daim ntawv khom nqi.
   
   

Lus Cim: Cov keyboard shortcut no tsis ua kom siv cov NOW ua haujlwm ces hnub tsis hloov txhua zaus ntawm cov ntawv ua haujlwm tau qhib lossis rov soj ntsuam dua.

Lwm Cov Ntawv Kaw Shortcut

• Ntxiv Hnub Tim
• Xaiv Non-Adjacent Cells hauv Excel
• ALT - TAB hloov nyob rau hauv Windows

Ntau »

06 ntawm 27

Ntxig ib Hyperlink

Ntxig ib Hyperlink rau Excel Siv Cov Shortkey Daws

Nyeem cov ntawv nyeem : Ntxig Hyperlinks thiab Bookmarks hauv Excel

No cov lus Excel sau ceev nrooj ntxig hyperlink rau cov ntawv xaiv uas siv cov yaum sij hauv Excel.

Qhov tseem ceeb sib txuas ua ke uas yuav siv tau los ntxig lub hyperlink yog:

Ctrl + k

Piv txwv: Ntxig ib Hyperlink siv Shortcut Keys

Kev pabcuam ntawm cov lus qhia no nias ntawm daim duab saum toj no

1. Nyob rau hauv ib qho Excel daim ntawv khuav nias ntawm cell A1 kom nws ua haujlwm rau ntawm tes
2. Ntaus ib lo lus los ua cov ntawv nyeem xws li Spreadsheets thiab nias tus Enter nkag rau ntawm tus keyboard
3. Nias ntawm Cell A1 kom rov ua nws lub xovtooj ntawm tes
4. Nias thiab tuav lub Ctrl qhov tseem ceeb ntawm cov keyboard
5. Nias thiab tso tawm tsab ntawv ( k ) qhov tseem ceeb ntawm cov keyboard qhib lub Insert Hyperlink dialog box
6. Nyob rau hauv qhov Chaw Nyob: kab hauv qab ntawm lub thawv ntawv sib txuas ib qho URL tag nrho xws li:
   http://spreadsheets.about.com
   
7. Nyem Ok ua kom tiav lub hyperlink thiab kaw lub thawv ntawv
8. Cov xov xwm nyob hauv xov tooj ntawm tes A1 yuav tsum yog xim xiav thiab kos raws li nws muaj qhov hyperlink

Kev kuaj Hyperlink

1. Muab tus pointer poias hla lub hyperlink hauv Cell A1
2. Tus pointer arrow yuav tsum hloov mus rau lub cim cim
3. Nias ntawm qhov hyperlink thauj tog rau nkoj
4. Koj lub web browser yuav tsum qhib rau nplooj ntawv txheeb xyuas los ntawm qhov URL

Tshem tawm Hyperlink

1. Muab tus pointer poias hla lub hyperlink hauv Cell A1
2. Tus pointer arrow yuav tsum hloov mus rau lub cim cim
3. Txoj cai nias ntawm Hyperlink thauj tog rau nkoj ntawv los qhib cov ntsiab lus teb tseg cia zaub mov
4. Nias rau Tshem tawm Kev Xaiv Kab Nkag rau hauv cov ntawv qhia zaub mov
5. Cov xim xiav thiab kos kab hauv qab yuav tsum tau muab tshem tawm ntawm phau ntawv txhais cov ntawv qhia tias lub hyperlink tau raug tshem tawm

Lwm Keyboard Shortcuts

Thov Nyiaj Txiag Lus Teb

Thov Italics Formatting

Ntxiv ciam teb rau Excel

Ntau »

07 ntawm 27

Qhia Cov Qauv

Lub khoos phib tawj tseem ceeb uas siv tau los qhia cov qauv yog: Ctrl + `(lub cim tseem ceeb hauv lub ntsej muag) Hauv feem ntau ntawm cov twj keyboards, lub voj voog tseem ceeb yog nyob ntawm tus xovtooj 1 ntawm sab laug ntawm sab laug ntawm cov keyboard thiab zoo nkaus li rov qab rho tawm. Qhia Cov Qauv Siv Cov Kwv Txawv Shortcut Piv Txwv Xov Xeem thiab tuav lub Ctrl yuam rau ntawm cov keyboard Nias thiab tso tawm qhov tseem ceeb ntawm cov lus siv (") ntawm lub keyboard tsis tso qhov Ctrl yawm Tawm Ctrl yuam Qhia Txog Daim Ntawv Qhia Cov qauv qhia tsis hloov daim ntawv khom nqi, tsuas yog txoj kev uas nws tshwm. Ua rau nws yooj yim mus nrhiav hlwb uas muaj cov qauv Nws tso cai rau koj nyeem ntawv ceev nrooj txhua daim qauv los xyuas cov teeb meem Thaum koj nyem rau ntawm ib lub mis, Excel cov qauv hauv cov xim uas siv los ntawm cov mis. Qhov no yuav pab koj nrhiav cov ntaub ntawv siv los ua formula. Sau cov spreadsheets nrog cov qauv qhia rau. Ua li no, yuav cia koj mus nrhiav ib daim ntawv khom nqi kom pom tseeb los ntawm kev yuam kev. Ntau »

08 ntawm 27

Excel Shortcut Daws - Undo

Qhov no Excel shortcut tseem ceeb nyeem qhia koj yuav ua li cas "undo" hloov ua rau ib qho Excel daim ntawv.

Nyeem cov ntawv nyeem: Excel 's Undo Feature .

Lus Cim: Nws tseem ceeb heev uas yuav tsum nco ntsoov tias thaum koj siv Undo, nws "tawm" koj cov kev ua raws li qhov rov qab txiav txim uas koj tau ua.

Kev sib koom ua kom nrawm nrawm siv los ua "kev hloov" hloov yog:

• Ctrl + " Z "

Piv txwv li yuav ua licas thiaj li hloov kev siv Cov Shortcuts

1. Ntaus qee cov ntaub ntawv rau hauv xovtooj , xws li A1 hauv daim ntawv khom nqi thiab nias tus Enter nkag ntawm cov keyboard.
   
   
2. Nias rau ntawm lub xovtooj ntawm nws kom ua nws lub xovtooj ntawm tes .
   
   
3. Nias ntawm Tsev tab ntawm txoj hlua .
   
   
4. Thov cov kev xaiv nram qab no rau koj cov ntaub ntawv:
   • hloov xim xim,
   • pib sab,
   • kos kab hauv qab,
   • hloov hom font hom rau Arial Dub,
   • chaw khaws cov ntaub ntawv
   
   
5. Nias thiab tuav lub Ctrl qhov tseem ceeb ntawm cov keyboard.
   
   
6. Nias thiab tso tawm tsab ntawv " Z " ntawm cov keyboard.
   
   
7. Cov ntaub ntawv nyob rau hauv xovtooj yuav tsum hloov rov qab mus rau kev sib dhos kom zoo dua li qhov kev hloov dhau (qhov chaw sib koom ua ke) yog tsis tuaj yeem.
   
   
8. Nias thiab puag hauv Ctrl qhov tseem ceeb ntawm cov keyboard dua.
   
   
9. Nias thiab tso tawm tsab ntawv " Z " ntawm cov keyboard ob zaug tsis tso qhov tseem ceeb Ctrl .
   
   
10. Tsis tsuas yuav tus kos kab hauv qab yuav raug tshem tawm tab sis daim ntawv yuav tsis muaj Arial Dub.
    
    
11. Qhov no tshwm sim vim hais tias, raws li tau hais saum toj no, lub undo feature "undoes" koj cov kev ua raws li qhov rov qab yuam kev uas koj tau thov lawv.
    
    

Lwm cov ntawv Shortcut Key Tutorials

• Ntxiv rau lub sijhawm tam sim no
• Xaiv Non-Adjacent Cells hauv Excel
• ALT - TAB Yooj Yim Hloov Hauv Qhov Ncauj

Ntau »

09 ntawm 27

Xaiv Cov Txheej Txheem Tsis Muaj Mob

Xaiv Non-Adjacent Cells hauv Excel

Nyeem Lwm Yam Lus: Xaiv Cov Txheej Txheem Tsis Txuam Nrog Kev Siv Cov Keyboard thiab Nas

Los ntawm xaiv ntau lub hlwb nyob hauv Excel koj tuaj yeem lwv cov ntaub ntawv, siv cov kev teeb tsa xws li ciam teb los yog shading, los yog siv lwm cov kev xaiv rau cov cheeb tsam loj ntawm daim ntawv ua haujlwm tas ib zaug.

Lub sijhawm no cov qe ntshav tsis nyob hauv ib qho chaw sib kis. Hauv cov xwm txheej no nws tuaj yeem xaiv cov uas tsis yog nyob ze.

Qhov no yuav ua tau kom siv cov keyboard thiab nas ua ke los yog siv cov keyboard xwb.

Siv cov Keyboard nyob hauv kev Ntxav

Xaiv cov hlwb uas tsis yog nyob ze nrog cov keyboards xwb kom koj siv cov keyboard hauv kev Ntxuas Muas .

Extended hom activated yog nias lub F8 yawm sij ntawm cov keyboard. Koj kaw hom ntev los nias lub khawm ua haujlwm thiab F8 ntawm cov keyboard ua ke.

Xaiv Ib Cov Txheej Txheem Tsis Muaj Mob Hauv Excel Siv cov Keyboard

1. Tshem tus cursor cell rau thawj lub cell uas koj xav xaiv.
2. Nias thiab tso tus yuam sij F8 ntawm cov keyboard kom pib Extended Mode thiab los ua kom pom cov thawj ntawm tes.
3. Tsis tau hloov tus cursor ntawm tes, nias thiab tso tawm cov haujlwm hauv Fift + F8 rau ntawm tus keyboard ua kom kaw hom qis dua.
4. Siv cov xub tuav ntawm cov keyboard tshem tus cursor cell mus rau tom ntej ntawm tes koj xav highlight.
5. Thawj lub xovtooj ntawm tes yuav tsum nyob twj ywm.
6. Nrog tus cursor cell rau ntawm tus xovtooj ntawm tom ntej kom highlighted, rov ua cov kauj ruam 2 thiab 3 saum toj no.
7. Ntxiv mus ntxiv cov hlwb kom muaj ntau yam siv los ntawm kev siv F8 thiab ua haujlwm + F8 yawm sij los pib thiab nres ncua kev hom.

Kev Xaiv Cov Txheej Txheem thiab Cov Txheej Txheem Tsis Xeem hauv Excel Siv cov Keyboard

Ua raws li cov kauj ruam hauv qab no yog tias qhov ntau yam koj xav xaiv yuav muaj sib xyaw kom haum ntawm cov uas nyob ib sab thiab ib tus neeg raws li muaj nyob hauv daim duab saum toj no.

1. Txav mus rau tus cursor cell rau thawj lub cell rau cov pab pawg ntawm cov hlwb koj xav highlight.
2. Nias thiab tso F8 yawm ntawm cov keyboard kom pib Extended Mode .
3. Siv cov xub tuav ntawm cov keyboard los rub lub ntau yam tseem ceeb kom muaj tag nrho cov hlwb hauv pawg.
4. Nrog txhua lub hlwb nyob rau hauv cov pab pawg xaiv, nias thiab tso tawm tus Shift + F8 yawm sij nyob rau hauv cov keyboard ua ke kaw kaw hom.
5. Siv cov xub tuav ntawm cov keyboard tshem tus cursor ntawm tes kom deb ntawm cov xaiv ntawm cov hlwb.
6. Thawj pab pawg ntawm lub hlwb yuav tsum nyob twj ywm.
7. Yog tias muaj ntau ntau pawg hlwb uas koj xav ua kom pom tseeb, tsiv mus rau thawj lub xov tooj ntawm cov pab pawg thiab rov ua dua cov kauj ruam 2 mus rau 4 sab sauv.
8. Yog tias muaj qee tus hlwb uas koj xav ntxiv rau ntau yam tseem ceeb, siv thawj txheej lus qhia saum toj no rau qhov tseem ceeb ntawm cov qe ntshav dawb.

Ntau »

10 ntawm 27

Xaiv Non-Adjacent Cells hauv Excel nrog Keyboard thiab Nas

Nyeem Lwm Yam Lus: Xaiv Cov Txheej Txheem Tsis Txuam Nrog Kev Siv Cov Keyboard

Los ntawm xaiv ntau lub hlwb nyob hauv Excel koj tuaj yeem lwv cov ntaub ntawv, siv cov kev teeb tsa xws li ciam teb los yog shading, los yog siv lwm cov kev xaiv rau cov cheeb tsam loj ntawm daim ntawv ua haujlwm tas ib zaug.

Thaum siv drag txoj kev xaiv nrog tus nas kom ceev nrooj highlight lub nplhaib ntawm cov uas nyob ib sab yog qhov kev xav paub ntau tshaj kev xaiv ntawm ntau tshaj ib lub xov tooj, muaj qee lub sij hawm thaum lub hlwb koj xav ua kom pom tseeb tsis nyob ntawm ib sab.

Thaum qhov no tshwm sim, nws muaj peev xwm xaiv tau cov hlwb uas tsis yog-uas nyob ib sab. Txawm hais tias xaiv cov hlwb uas tsis yog-uas nyob ib sab yuav ua tau los nrog cov keyboard , nws yog qhov yooj yim los ua kom siv cov keyboard thiab nas ua ke.

Kev Xaiv Cov Ntaus Pob Mob hauv Excel

Yog xav tau kev pab nrog tus qauv no, saib daim duab saum toj no.

1. Nias ntawm thawj lub xovtooj uas koj xav xaiv nrog tus pointer pointer kom nws lub xovtooj ntawm tes .
   
   
2. Tso tus nas khawm.
   
   
3. Nias thiab tuav lub Ctrl qhov tseem ceeb ntawm cov keyboard.
   
   
4. Nias rau ntawm cov seem ntawm lub hlwb koj xav xaiv lawv tsis tso tus Ctrl yuam.
   
   
5. Thaum tag nrho cov hlwb xav tau xaiv, tso tus yuam sij Ctrl .
   
   
6. Tsis txhob nyem qhov twg ntxiv nrog tus pointer pointer thaum koj tso qhov tseem ceeb Ctrl los sis koj yuav tshem qhov tseem ceeb ntawm lub hlwb xaiv.
   
   
7. Yog tias koj tso Ctrl tseem ceeb sai sai thiab xav pom ntau lub hlwb, nyem nias thiab puag hauv Ctrl qhov tseem ceeb dua thiab mam li nyem rau ntawm tus xov tooj ntxiv (s).
   
   

Lwm Cov Ntawv Kaw Shortcut

• Ntxiv rau lub sijhawm tam sim no
• Ntxiv Hnub Tim
• ALT - TAB Yooj Yim Hloov Hauv Qhov Ncauj

Ntau »

11 ntawm 27

ALT - TAB hloov nyob rau hauv Windows

Tsis yog ib qho Shortcut Excel, ALT - TAB Hloov yog txoj kev ceev ceev ntawm txhua qhov qhib cov ntaub ntawv hauv qhov rais (Yawm sij + Tab hauv Windows vista).

Siv cov keyboard ua kom tiav rau kev ua haujlwm ntawm lub computer yog feem ntau siv ntau dua li siv tus nas lossis lwm tus taw tes, thiab ALT - TAB Hloov yog ib qho ntawm feem ntau siv cov keyboard shortcuts.

Siv ALT - TAB Hloov

1. Qhib tsawg kawg ob qhov hauv Windows. Cov no yuav yog ob daim Excel lossis ib daim Excel thiab ib qho ntaub ntawv Microsoft Word piv txwv.
   
   
2. Nias thiab tuav lub pob hauv qab ntawm cov keyboard.
   
   
3. Nias thiab tso tus Tab key on the keyboard tsis pub mus rau tus yuam sij Alt .
   
   
4. Qhov ALT - TAB Tsaus Hloov lub qhov rai yuav tsum tshwm sim hauv nruab nrab ntawm koj lub computer.
   
   
5. Lub qhov rai no yuav tsum muaj lub cim rau txhua daim ntawv qhib tam sim no rau hauv koj lub computer.
   
   
6. Thawj lub cim ntawm sab laug yuav yog rau daim ntawv tam sim no - ib qho pom ntawm qhov screen.
   
   
7. Qhov thib ob lub cim ntawm sab laug yuav tsum tau qhia los ntawm ib lub thawv.
   
   
8. Hauv qab no cov cim yuav tsum yog lub npe ntawm cov ntaub ntawv tseem ceeb los ntawm lub thawv.
   
   
9. Tso tus yuam sij hauv Alt thiab cov qhov rai qhib koj cov ntaub ntawv tseem ceeb.
   
   
10. Txav mus rau lwm cov ntaub ntawv qhia hauv ALT - TAB Ceev Hloov lub qhov rais, tuav twj ywm hauv Hli tapping tus Tab key. Txhua tus kais mom yuav tsum tsiv lub thawv rau ntawm sab xis kom txog ntawm ib daim ntawv mus rau lwm qhov.
    
    
11. Tshem tus yuam sij thaum lub npe yam tseem ceeb.
    
    
12. Thaum ALT - TAB Yoojyim hloov qhov rais qhib, koj tuaj yeem hloov txoj kev taw qhia ntawm lub thawv highlight - tsiv nws ntawm sab xis mus rau sab laug - los ntawm kev tuav hauv qhov tseem ceeb ua haujlwm thiab tus yuam sij thiab tom qab khawm qhov Tab tseem ceeb.

Lwm Keyboard Shortcuts

• Ntxiv rau lub sijhawm tam sim no
• Ntxiv Hnub Tim
• Nkaum Txhua Yam Hauv Excel

Ntau »

12 ntawm 27

Excel tus mus Feature

Hais txog kev nyeem ntawv: Excel Lub Thawv Box Navigation .

Cov Go mus feature hauv Excel siv tau los mus ceev nrooj rau ntau lub hlwb hauv ib qho kev tshaj tawm . Tsab ntawv xov xwm no muaj xws li ib qho piv txwv ntawm kev siv Tus Mus Mus feature kom txav mus rau lwm lub hlwb siv lub keyboard shortcut.

Txawm hais tias tsis tsim nyog rau cov ntawv ua haujlwm uas tsuas siv ob peb kab thiab kab xwb , rau cov ntawv ua haujlwm loj nws yuav pab tau yooj yim kom dhia tawm ntawm ib thaj tsam ntawm koj daim ntawv rau ib daim ntawv.

Mus qhib Tus Mus Mus feature siv cov keyboard, nias lub F5 qhov tseem ceeb

Piv txwv uas siv cov Excel mus rau qhov feature rau Kev Qhia:

1. Nias lub F5 qhov tseem ceeb ntawm cov keyboard kom coj mus rau Mus Rau cov lus sib tham.
2. Ntaus nyob hauv xovtooj ntawm qhov kev xav tau ntawm qhov chaw hauv kab Siv ntawm lub thawv ntawv sib txuas lus. Hauv qhov no: HQ567 .
3. Nias ntawm qhov tseem ceeb khawm los yog nias qhov ENTER yawm ntawm cov ntawv.
4. Lub npov dub uas nyob ib ncig ntawm lub xovtooj ntawm tes yuav tsum dhia mus rau ntawm tes HQ567 ua nws lub zog tshiab ntawm tes.
5. Yuav tsiv mus rau lwm lub xov tooj, rov qab ua cov kauj ruam 1 mus rau 3.

Related Tutorials

• Excel lub npe Box Navigation
• Xov tooj ntawm tes hauv cov qauv
• Ntxiv Hyperlinks thiab Bookmarks hauv Excel

Ntau »

13 ntawm 27

Excel Puv Ua Kom Ua

Yog tias koj xav tau cov ntaub ntawv qub - cov ntawv nyeem lossis cov zauv - mus rau cov kab uas nyob ib sab ntawm ib sab , Cov Sau Tsiaj Ntawv hais kom sai ua qhov no rau koj los ntawm qhov siv cov keyboard.

No cov tswv yim Excel qhia tau hais tias koj yuav tsum ua li cas thiaj li sau cov lus Fill Down hais kom ua hauv Excel spreadsheet siv lub keyboard shortcut.

Txoj kev sib txuam tseem ceeb uas siv qhov Fill Down command yog:

• Ctrl + D

Piv Txwv: Siv Ua Puv Lawm nrog Keyboard Shortcut

Yog xav tau kev pab nrog tus qauv no, saib daim duab saum toj no.

1. Ntaus tus lej, xws li 395.54 rau hauv D1 hauv Excel.
   
   
2. Nias thiab tuav tus yuam sij ua haujlwm ntawm cov keyboard
3. Nias thiab tuav lub khawm Down rau ntawm tus keyboard kom cuag lub xovtooj ntawm tes ntawm D1 rau D7.
4. Tso tawm ob qho tib si.
5. Nias thiab tuav lub Ctrl qhov tseem ceeb ntawm cov keyboard.
6. Nias thiab tso " D " key rau ntawm cov keyboard.
7. Cov hlwb D2 rau D7 yuav tsum tam sim no tau sau nrog cov ntaub ntawv tib yam li ntawm tes D1.

Lwm Keyboard Shortcuts

• Excel Undo
• Ntxiv Hnub Tim
• Sau Hnub Tim

Ntau »

14 ntawm 27

Thov Italics Formatting

No cov tswv yim Excel qhia koj yuav ua li cas thiaj li tau siv qhov kev ua cov ntawv luam kev siv cov Shortcut key rau cov keyboard.

Muaj ob qho tseem ceeb ua ke uas tuaj yeem siv los ntxiv los sis tshem tawm cov italics formatting rau cov ntaub ntawv:

• Ctrl + " Kuv "
• Ctrl + " 3 "

Piv Txwv: Siv Cov Yuam Sij Ntaus Nkag kom Siv Tau Cov Ntawv Teev Tseg

Yog xav tau kev pab nrog tus qauv no, saib daim duab mus rau sab xis.

1. Ntaus qee cov ntaub ntawv rau hauv xov tooj ntawm tes , xws li E1 hauv tsab ntawv khom nqi thiab nias tus Enter nkag rau ntawm tus keyboard.
   
   
2. Nias rau ntawm lub xovtooj ntawm nws kom ua nws lub xovtooj ntawm tes .
   
   
3. Nias thiab tuav lub Ctrl qhov tseem ceeb ntawm cov keyboard.
   
   
4. Nias thiab tso tawm tsab ntawv " I " rau ntawm tus keyboard.
   
   
5. Italics formatting yuav tsum tau mus thov cov ntaub ntawv hauv xov tooj cua.
   
   
6. Nias thiab tso tawm Ctrl + " Kuv " yawm sij tawm kom tshem tau qhov italics formatting.
   
   

Lwm Keyboard Shortcuts

• Ntxiv rau lub sijhawm tam sim no
• Xaiv Non-Adjacent Cells hauv Excel
• ALT - TAB Yooj Yim Hloov Hauv Qhov Ncauj

15 ntawm 27

Thov Cov Naj Npawb Qhia Ntawv

Cov ntawv nyeem no qhia txog yuav ua li cas thov cov naj npawb formatting kom xaiv cov hlwb siv cov keyboard xwb:

Cov zauv naj npawb siv rau cov ntaub ntawv xaiv tau yog:

• ob zauv chaw
• tus comma li txhiab separator (,)
• daim ntawv rho npe (-) rau qhov tsis pom qhov tseem ceeb

Cov tseem ceeb ua ke uas siv tau los siv cov txiaj ntsig rau cov ntaub ntawv rau cov ntaub ntawv yog:

Ctrl + ua haujlwm + ! (exclamation point)

Piv txwv: Siv Shortcut Key to Apply Number Numberatting

Qhov piv txwv no muaj nyob hauv daim duab saum toj no

1. Ntxiv cov ntaub ntawv txuas mus rau hlwb A1 rau A4:
   4578.25102 45782.5102 457825.102 4578251.02
2. Highlight hlwb A1 rau A4 xaiv lawv
3. Nias thiab tuav lub Ctrl thiab Shift tuav ntawm cov keyboard
4. Nias thiab tso cov ntsiab lus taw qhia exclamation ( ! ) Ntawm cov keyboard tsis tso cov Ctrl thiab cov ua haujlwm tuav
5. Tso Ctrl thiab Shift tuav
6. Cov zauv nyob rau hauv hlwb A1 rau A4 yuav tsum tag nrho yuav formatted mus tso saib tsuas yog ob decimal chaw txawm tias ob peb ntawm tus lej muaj ntau tshaj ob
7. Lub hlwb yuav tsum tau muaj lub duab ntxiv nrog ib txhiab separator
8. Txhawm rau ib qho ntawm lub hlwb qhia txog tus naj npawb unformatted nyob hauv lub mis ntawm daim ntawv saum toj no

Lwm Keyboard Shortcuts

• Ntxiv Hnub Tim
• Ntxiv rau lub sijhawm tam sim no
• ALT - TAB Yooj Yim Hloov Hauv Qhov Ncauj

Ntau »

16 ntawm 27

Thov Nyiaj Txiag Lus Teb

Cov ntawv nyeem no qhia txog yuav ua li cas kom sai nrig formatting kom xaiv hlwb uas siv cov keyboard xwb:

Cov tseem ceeb ua ke uas siv tau los siv cov txiaj ntsig rau cov ntaub ntawv rau cov ntaub ntawv yog:

• Ctrl + ua haujlwm + 4

Piv txwv: Siv Shortcut Key to Apply Formatting Txiaj Ntsig

Yog xav tau kev pab nrog tus qauv no, saib daim duab mus rau sab xis.

1. Ntxiv cov ntaub ntawv txuas mus rau hlwb A1 rau B2: 7.98, 5.67, 2.45, -3.92
   
   
2. Tsav xaiv lub hlwb A1 B2 mus rau lawv.
   
   
3. Nias thiab tuav lub Ctrl thiab Shift tuav ntawm cov keyboard.
   
   
4. Nias thiab tso tus naj npawb plaub qhov tseem ceeb ( 4 ) ntawm cov keyboard tsis tso cov Ctrl thiab Shift tuav.
   
   
5. Hauv cov hlwb A1, A2, thiab B1 cov cim nyiaj ( $ ) yuav tsum muab ntxiv rau cov ntaub ntawv.
   
   
6. Hauv cell B2, vim tias cov ntaub ntawv yog ib tus neeg tsis zoo, nws yuav tsum muaj xim liab thiab surrounded los ntawm cov khab hlua ntxiv nrog rau cov cim nyiaj ( $ ) ntxiv.
   
   

Lwm Keyboard Shortcuts

• Ntxiv Hnub Tim
• Ntxiv rau lub sijhawm tam sim no
• ALT - TAB Yooj Yim Hloov Hauv Qhov Ncauj

Ntau »

17 ntawm 27

Siv Qhov Ntsuas Txog Feem Pua

Daim ntawv Excel no piav txog kev siv tus txheej txheem ntawm lub cim rau cov kab ntawv xaiv hauv Excel spreadsheet uas siv cov yuam sij ntawm cov keyboard.

Cov tseem ceeb ua ke uas siv tau los siv cov txiaj ntsig rau cov ntaub ntawv rau cov ntaub ntawv yog:

• Ctrl + Ua haujlwm + 5

Piv txwv ntawm yuav thov li cas Feem saib ntawm kev siv Tus Kheej Shortcut

Yog xav tau kev pab nrog tus qauv no, saib daim duab saum toj no.

1. Muab cov ntaub ntawv txuas ntxiv rau hlwb A1 rau B2: .98, -38, 1.23, .03
   
   
2. Tsav xaiv lub hlwb A1 B2 mus rau lawv.
   
   
3. Nias thiab tuav lub Ctrl thiab Shift tuav ntawm cov keyboard.
   
   
4. Nias thiab tso tus naj npawb tsib yaum ( 5 ) ntawm cov keyboard tsis tso cov Ctrl thiab Shift tuav.
   
   
5. Hauv cov hlwb A1 los B2 cov ntaub ntawv yuav tsum raug hloov mus rau ib feem pua ​​nrog rau feem pua ​​ntawm cov lus sau ( % ) ntxiv rau cov ntaub ntawv.

Lwm Cov Ntawv Kaw Shortcut

• Thov Nyiaj Txiag Lus Teb
• Thov Italics Formatting
• Ntxiv ciam teb rau Excel

Ntau »

18 ntawm 27

Xaiv Txhua Haiv Neeg hauv ib qho Excel Data Table

No Excel hau npog yuav xaiv txhua lub hlwb li cas hauv Excel cov ntaub ntawv uas siv cov keyboard shortcut. Ua li no yuav ua rau koj hloov cov kev hloov xws li kev teeb tsa, txoj kab sab nrauv, thiab lwm yam rau ib daim ntawv ua haujlwm txhua zaug.

Related Tshooj: Tsim kom tau ib cov ntaub ntawv hauv Excel .

Ceebtoom: Yog xav tau kev pabcuam rau tus qauv no, saib daim duab mus rau sab xis.

Piv txwv li cas xaiv Xaiv Txhua Kab hauv Cov Ntaub Ntawv Qhia

1. Qhib ib daim ntawv ua haujlwm Excel uas muaj cov ntaub ntawv los yog tsim cov lus qhia .
   
   
2. Nyem ntawm txhua lub xov tooj ntawm cov lus qhia.
   
   
3. Nias thiab tuav lub Ctrl qhov tseem ceeb ntawm cov keyboard.
   
   
4. Nias thiab tso cov ntawv " A " rau ntawm cov keyboard tsis tso tus Ctrl yuam.
   
   
5. Txhua lub hlwb nyob hauv cov ntaub ntawv yuav tsum tau muab teev tseg.
   
   
6. Nias thiab tso tawm tsab ntawv " A " ib zaug dua zaum ob.
   
   
7. Cov kab lus ntawm cov lus qhia yuav tsum muab qhia ua ke nrog rau cov lus qhia.
   
   
8. Nias thiab tso tawm tsab ntawv " A " rau peb zaug.
   
   
9. Txhua lub hlwb nyob rau hauv daim ntawv khij nyiab yuav tsum tau qhia.

Lwm Keyboard Shortcuts

• Xaiv Non-Adjacent Cells hauv Excel
• Ntxiv ciam teb rau Excel
• Nkaum Txhua Yam Hauv Excel

Ntau »

19 ntawm 27

Xaiv Ib Qig Tshaj hauv Excel Siv Cov Shortkey Daws

Xaiv cov kab hauv cov ntawv sau

No cov lus Excel sau hais txog kev ceev nrooj los sis ua kom pom tseeb tag nrho hauv kab ntawv hauv cov ntawv ua haujlwm uas siv cov yaum sij hauv cov keyboard hauv Excel.

Qhov ua ke tseem ceeb uas yog siv los xaiv ib tug kab yog:

SHIFT + SPACEBAR

Piv txwv: Siv Cov Shortkey Keys los Xaiv Sau Tag Nrho Cov Ntawv Sau Npe

1. Qhib ib Daim Ntawv Xam Nyiaj Pej Xeem (Excel Worksheet) - tsis tas yuav tsum muaj cov ntaub ntawv tam sim no
2. Nias ntawm ib lub xovtooj rau hauv daim ntawv ua haujlwm - xws li A9 - kom nws ua haujlwm ntawm tes
3. Nias thiab tuav lub khawm SHIFT rau hauv keyboard
4. Nias thiab tso tus yuam sij rau SPACEBAR ntawm cov keyboard tsis tso qhov tseem ceeb SHIFT
5. Tshem tawm qhov tseem ceeb SHIFT
6. Txhua lub hlwb nyob rau hauv cov kab xaiv yuav tsum muaj highlighted - nrog rau cov kab taub uake

Ntau »

20 ntawm 27

Txuag hauv Excel

Excel Txuag Shortcut Keys

No cov tswv yim Excel yuav ua li cas kom ceev ceev cov ntaub ntawv uas siv cov yuam sij shortcut rau cov keyboard hauv Excel.

Qhov ua ke tseem ceeb uas yuav siv los khaws cov ntaub ntawv yog:

Ctrl + S

Piv txwv: Siv Shortcut Daws Tuav Tseg Daim Ntawv Foos

1. Nias thiab tuav lub Ctrl qhov tseem ceeb ntawm cov keyboard
2. Nias thiab tso tawm tsab ntawv ( S ) qhov tseem ceeb ntawm cov keyboard tsis tso tus Ctrl yuam
3. Tso Ctrl yuam

Thawj Lub sij hawm Txuag

Yog tias koj tau txais kev cawmdim dhau los ntawm daim ntawv khij tsuas yog tias Excel khaws tseg koj cov ntaub ntawv yuav yog tus nas pointer hloov me ntsis mus rau hauv ib lub cim iconglass thiab tom qab ntawd rov qab rau qhov kev qhia ntxiv dawb thiab kos npe.

Qhov ntev ntawm lub sij hawm ntawm lub sij hawm ntawm lub sij hawm xuas phom sij yog nyob ntawm seb tus nqi ntawm Excel yuav tsum tseg. Qhov ntau ntau ntawm cov ntaub ntawv los cawm, ntev lub sij hawm ntawm cov teev ntawv yuav pom.

Yog tias koj khaws ib daim ntawv rau thawj zaug rau lub sij hawm qhib Lub Tuam Sib Tham yuav qhib.

Thaum cov ntaub ntawv tseg rau thawj lub sij hawm ob daim ntawm cov ntaub ntawv yuav tsum tau muab teev rau hauv Txuag Kev Sib Tham Xov Xwm:

• lub npe ntawm cov ntaub ntawv (txog 255 cim nrog rau cov chaw)
• qhov chaw (nplaub tshev) nyob qhov twg cov ntaub ntawv yuav muab khaws cia

Txuag Nquag

Txij li thaum siv Ctrl + S shortcut keys yog ib qho yooj yim uas yuav tau khaws cov ntaub ntawv nws yog ib lub tswv yim zoo kom txuag nquag - tsawg kawg txhua tsib feeb - kom tsis txhob poob ntawm cov ntaub ntawv thaum muaj kev sib tsoo computer. Ntau »

21 ntawm 27

Hide thiab Unhide Columns thiab Natures hauv Excel

22 ntawm 27

Sau Hnub Tim

Hom ntawv Excel no qhia koj txog hnub (hnub, hli, xyoo hom) hauv Excel spreadsheet siv keyboard shortcut.

Sau lub Hnub Siv cov Keyboard Shortcut

1. Ntxiv cov hnub xav tau mus rau ib lub xovtooj rau hauv Excel spreadsheet.
   
   
2. Nias ntawm lub xov tooj ntawm tes kom nws ua txoj haujlwm ntawm tes .
   
   
3. Nias thiab tuav lub Ctrl thiab Shift tuav ntawm cov keyboard.
   
   
4. Nias thiab tso tus naj npawb kos npe ( # ) rau ntawm cov keyboard tsis tso cov Ctrl thiab Shift tuav.
   
   
5. Lub hnub nyob hauv lub xovtooj ntawm tes yuav muab teeb tsa rau hnub, hli, xyoo hom ntawv.
   
   

Lwm Keyboard Shortcuts

• Ntxiv Hnub Tim
• Ntxiv rau lub sijhawm tam sim no
• ALT - TAB Yooj Yim Hloov Hauv Qhov Ncauj

Ntau »

23 ntawm 27

Formatting lub sijhawm tam sim no

Hom ntawv Excel no qhia koj li cas tam sim no (teev, feeb, thiab AM / PM hom) nyob rau hauv ib qho Excel spreadsheet uas siv cov keyboard shortcut.

Formatting lub sij hawm tam sim no siv lub Keyboard Shortcut

1. Siv qhov tam sim no muaj nuj nqi ntxiv rau hnub tim thiab lub sijhawm tam sim no rau ntawm tes D1.
   
   
2. Nias ntawm tes D1 kom nws ua haujlwm ntawm tes .
   
   
3. Nias thiab tuav lub Ctrl thiab Shift tuav ntawm cov keyboard.
   
   
4. Nias thiab tso tus naj npawb ob ( 2 ) ntawm cov keyboards tsis tso cov Ctrl thiab Shift tuav.
   
   
5. Qhov tam sim no muaj nuj nqi hauv xov tooj ntawm D1 yuav muab tso tawm kom pom tam sim no hauv lub xuab moos, feeb, thiab AM / PM hom ntawv.
   
   

Lwm Keyboard Shortcuts

• Excel Undo
• Ntxiv Hnub Tim
• Sau Hnub Tim

Ntau »

24 ntawm 27

Hloov ntawm Cov Ntawv Xaus

Raws li lwm txoj siv los siv tus nas, nws yog ib qho yooj yim mus siv lub keyboard shortcut hloov ntawm daim ntawv khij hauv Excel.

Cov yuam sij siv yog cov tseem ceeb hauv CTRL ntxiv rau PGUP (nplooj ntawv) los yog PGDN (nplooj ntawv) qhov tseem ceeb

Piv Txwv - Hloov Ntawm Cov Ntawv Xab Thev hauv Excel

Yuav tsiv mus rau sab xis:

1. Nias thiab tuav lub khawm CTRL rau ntawm cov keyboard.
2. Nias thiab tso tawm cov PGDN (nplooj ntawv) ntawm tus keyboard.
3. Txav mus rau lwm daim ntawv mus rau sab xis thiab tso tawm tus yuam sij PGDN zaum ob.

Txav mus rau sab laug:

1. Nias thiab tuav lub khawm CTRL rau ntawm cov keyboard.
2. Nias thiab tso lub PGUP (nplooj ntawv sab nraud) ntawm tus keyboard.
3. Txav lwm cov ntawv rau sab laug xovxwm thiab tso tus yuam sij PGUP zaum ob.

Lwm Keyboard Shortcuts

• Nkaum Txhua Yam Hauv Excel
• Hide natwm hauv Excel
• Ntxiv Hnub Tim

Lus Cim: Yuav xaiv ntau daim ntawv khij nyiab uas siv cov keyboard, nias: Ctrl + Ua haujlwm + PgUp los xaiv cov nplooj ntawv rau sab laug Ctrl + Ua haujlwm + PgDn xaiv nplooj ntawv mus rau sab xis

25 ntawm 27

Hloov cov kaus mom nrog F2 Qhov Tseem Ceeb Tshuam

Excel Kho Cells Shortcut Qhov Tseem Ceeb

Qhov tseem ceeb F2 muaj peev xwm ua rau koj sai thiab yooj yim kho cov ntaub ntawv ntawm lub xov tooj ntawm tes los ntawm activating Excel cov kev kho kom raug thiab muab cov ntsiab lus ntxig rau qhov kawg ntawm lub xovtooj ntawm cov khoom qub.

Piv txwv: Siv F2 Key to Edit a Cell's Contents

Qhov piv txwv no npog yuav hloov mis li cas hauv Excel

1. Nkag mus rau cov ntaub ntawv nram no rau hauv hlwb 1 mus rau D3: 4, 5, 6
2. Nyem ntawm tes E1 kom nws ua haujlwm ntawm tes
3. Sau cov qauv hauv qab no rau hauv cell E1:
   = D1 + D2
4. Nias tus yuam sij Nkag rau ntawm tus keyboard ua kom tiav cov mis - cov lus teb 9 yuav tsum tshwm sim hauv cell E1
5. Nias ntawm tes E1 kom rov ua nws lub xovtooj ntawm tes
6. Nias lub khawm F2 rau ntawm tus keyboard
7. Excel nkag rau hom kho kom raug thiab muab cov ntsiab lus ntxig rau tom kawg ntawm tus qauv tam sim no
8. Hloov lub mis los ntawm kev ntxiv + D3 mus rau qhov kawg ntawm nws
9. Nias tus yuam sij nkag rau ntawm cov keyboard ua kom tiav cov mis thiab tawm cov kev hloov kho tshiab - qhov tshiab tag nrho rau qhov formula - 15 - yuav tsum tshwm sim hauv cell E1

Ceeb toom: Yog qhov kev tso cai rau kev tsim kho nyob rau hauv lub hlwb, muab qhov tseem ceeb ntawm F2 tseem yuav muab tso rau Excel kho kom raug, tiam sis qhov ntxig rau qhov yuav raug tsiv mus rau ntawm qhov qauv hauv qab ntawm daim ntawv ua haujlwm thiaj li hloov tau tus xov tooj ntawm tes. Ntau »

26 ntawm 27

Xaiv cov kab ntawv hauv cov ntawv Excel

27 ntawm 27

Ntxiv Ciam Tebchaws

No cov lus Excel sau ntxiv yuav ua li cas ntxiv ib qho ciam teb mus xaiv hlwb hauv Excel spreadsheet siv lub keyboard shortcut.

Lwm cov ntawv nyeem: Ntxiv / Formatting Ciam teb rau hauv Excel .

Lub sijhawm tseem ceeb rau kev ntxiv sijhawm yog:

Ctrl + Ua haujlwm + 7

Piv txwv ntawm Yuav ua li cas ntxiv Ntxiv Ciam teb siv lub Keyboard Shortcut

Yog xav tau kev pab nrog tus qauv no, saib daim duab mus rau sab xis.

1. Sau cov zauv 1 mus rau 9 rau hauv hlwb D2 mus rau F4.
   
   
2. Luag xaiv hlwb D2 rau F4 los qhia lawv.
   
   
3. Nias thiab tuav lub Ctrl thiab cov ua haujlwm khawm ntawm cov keyboard.
   
   
4. Nias thiab tso tus naj npawb xya ( 7 ) ntawm cov keyboard tsis tso cov Ctrl thiab cov kauj vuam txav.
   
   
5. Cov hlwb D2 mus rau F4 yuav tsum tau nyob ib ncig ntawm lub ciam teb dub.
   
   

Lwm Keyboard Shortcuts

• Ntxiv Hnub Tim
• Xaiv Non-Adjacent Cells hauv Excel
• Ntxiv rau lub sijhawm tam sim no

Ntau »