Yog, koj tuaj yeem nrawm ntxiv hnub tam sim no rau Excel siv cov yuam sij tawm ntawm cov keyboard.
Ntxiv nrog rau kev ceev, thaum hnub ntxiv ntxiv uas siv hom no nws tsis hloov txhua zaus ntawm cov ntawv ua haujlwm qhib li nws nrog qee lub sijhawm Excel hnub.
Ntxiv Hnub Tim Hnub tim Tsav Hloov Siv Luv Luv Luv Luv
Kom muaj hnub hloov tshiab txhua lub sijhawm qhib daim ntawv ua haujlwm, siv cov hnub ua haujlwm .
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:
- Nias ntawm lub xovtooj uas koj xav kom lub sijhawm mus.
- Nias thiab tuav lub Ctrl qhov tseem ceeb ntawm cov keyboard.
- Nias thiab tso lub pob nyem (;) ntawm cov keyboard tsis tso tus yuam sij Ctrl.
- Tso Ctrl yuam.
- Cov hnub tim yuav tsum muab ntxiv rau daim ntawv ua haujlwm hauv xaiv lub xov tooj.
Lub hom phiaj ua ntej rau hnub kos npe yog hom hnub luv saud raws li muaj nyob hauv daim duab saum toj no. Siv lwm qhov kev siv keyboard los hloov cov hom ntawv rau hom ntawv nruab hnub-hli-xyoo.
Ntxiv rau lub sij hawm tam sim no siv Shortcut Keys
Txawm hais tias tsis yog siv cov hnub hauv spreadsheets, ntxiv lub sij hawm tam sim no nrog cov keyboard shortcut yuav siv, nrog rau lwm yam, raws li lub sij hawm stamp - txij li nws tsis hloov ib nkag - tuaj yeem nkag nrog qhov sib lawv liag nram qab no:
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:
- Nias ntawm lub xovtooj uas koj xav kom lub sijhawm mus.
Nias thiab tuav lub Ctrl thiab cov ua haujlwm khawm ntawm cov keyboard. - Nias thiab tso cov nyuv qhov tseem ceeb (:) ntawm cov keyboard tsis tso cov Ctrl thiab cov kauj vuam txav.
- Lub sijhawm tam sim no yuav muab ntxiv rau hauv daim ntawv ua haujlwm.
Yuav kom muaj sij hawm hloov tshiab txhua zaus ntawm daim ntawv sau qhia tau qhib, siv cov NOW ua haujlwm .
Formatting Cov Hnub hauv Excel nrog Shortcut Keys
Cov lus qhia Excel no qhia tau hais tias koj yuav ua li cas sai sai rau cov hnub dhau hnub-txhua xyoo - ib xyoos twg (xws li 01-Jan-14) nyob rau hauv ib qho Excel daim ntawv khij siv cov yaum sij rau ntawm cov keyboard.
Txoj kev cai sib sau ua ke rau kev teev cia hnub yog:
Ctrl + ua haujlwm + # (hash lossis lossis tus yuam sij kos npe)Piv Txwv: Teeb Meem Siv Hnub Siv cov Shortcut Laws
- Ntxiv hnub tim rau ib lub xov tooj ntawm tes hauv daim ntawv ua haujlwm.
- Yog tias tsim nyog, nyem rau ntawm lub xov tooj ntawm tes kom nws ua haujlwm hauv lub xov tooj .
- Nias thiab tuav lub Ctrl thiab Shift tuav ntawm cov keyboard.
- Nias thiab tso tus yuam sij hashtag (#) ntawm cov keyboard tsis tso cov Ctrl thiab cov ua haujlwm hauv lub lag luam.
- Tso Ctrl thiab Shift tuav.
- Lub hnub yuav muab teeb tsa rau hauv hom ntawv nruab hnub-hli-xyoo raws li muaj nyob hauv daim duab saum toj no.
Formatting zaug hauv Excel nrog Shortcut tuav
No cov tswv yim Excel qhia tau hais tias koj yuav ua li cas kom sai lub sij hawm hauv kev ua haujlwm Excel uas siv cov yaum sij luv ntawm cov keyboard.
- Cov sij hawm tau muab teev nrog lub teev: feeb: feeb thib ob thiab AM / PM (xws li 10:33:00 AM)
Cov tseem ceeb ua ke rau kev teev lus sij hawm yog:
Ctrl + Ua haujlwm + @ (ntawm lub cim)Formatting lub sij hawm tam sim no siv Shortcut tuav
- Ntxiv cov sij hawm mus rau ib lub xov tooj ntawm tes hauv daim ntawv ua haujlwm.
- Yog tias tsim nyog, nyem rau ntawm lub xov tooj ntawm tes kom nws ua haujlwm hauv lub xov tooj.
- Nias thiab tuav lub Ctrl thiab Shift tuav ntawm cov keyboard.
- Nias thiab tso tawm cov hash lossis yawm sij (@) ntawm cov keyboard - nyob saum tus naj npawb 2 - tsis tau tso cov Ctrl thiab Shift tuav.
- Tso Ctrl thiab Shift tuav.
- Lub sijhawm yuav muab teeb tsa los qhia lub sij hawm tam sim no hauv lub teev: feeb thiab AM / PM hom raws li pom hauv daim duab saum toj no.