Ib qho ntawm Microsoft Excel qhov paub zoo tshaj plaws hnub ua haujlwm yog tam sim no muaj nuj nqi. Lub NOW muaj nuj nqi ntxiv hnub tam sim no lossis lub sijhawm rau daim ntawv ua haujlwm thiab tseem tuaj yeem suav tus nqi raws li hnub thiab sijhawm tam sim no, thiab muaj tus nqi hloov tshiab txhua zaus koj qhib daim ntawv ua haujlwm.
Cov ntaub ntawv hauv kab lus no siv rau Excel versions 2019, 2016, 2013, 2010, thiab 2007, nrog rau Excel rau Microsoft 365 rau Mac, thiab Excel rau Mac 2011.
NOW muaj nuj nqi syntax tsis muaj kev sib cav. Cov ntaub ntawv tau nkag mus rau hauv qhov kev ua haujlwm ntawm kab lus.
Yuav ua li cas nkag rau tam sim no muaj nuj nqi
Zoo li feem ntau Excel ua haujlwm, tam sim no muaj nuj nqi nkag mus rau hauv daim ntawv ua haujlwm siv lub luag haujlwm lub thawv sib tham. Vim tias nws tsis siv cov lus sib cav, cov haujlwm tuaj yeem nkag mus rau hauv lub xovtooj ntawm tes los ntawm ntaus ntawv =Tam sim no() thiab nias Enter Cov txiaj ntsig qhia hnub tam sim no thiab lub sijhawm.
Txhawm rau hloov cov ntaub ntawv tso tawm, kho lub xov tooj ntawm tes kom pom tsuas yog hnub lossis sijhawm siv lub Format tab.
Shortcut Keys rau Formatting Hnub thiab Sijhawm
Keyboard shortcuts pab koj sai sai format lub tam sim no muaj nuj nqi tso zis. Rau hnub tim (hnub-hli-xyoo hom), sau Ctrl + Ua haujlwm +. Rau lub sijhawm (teev-feeb-thib ob thiab a.m./p.m. hom), nkag mus Ctrl+Shift+@.
Serial Number los yog Hnub tim
Yog vim li cas tam sim no muaj nuj nqi tsis muaj kev sib cav yog tias txoj haujlwm tau txais nws cov ntaub ntawv los ntawm kev nyeem lub khoos phis tawj lub moos. Windows versions ntawm Excel khaws hnub tim ua tus lej sawv cev rau cov hnub tag nrho txij thaum ib tag hmo Lub Ib Hlis 1, 1900, ntxiv rau cov teev, feeb, thiab vib nas this rau hnub tam sim no. Tus lej no hu ua tus lej xov tooj lossis hnub tim.
Vim tias tus naj npawb txuas ntxiv nce ntxiv nrog txhua qhov thib ob dhau los, nkag mus rau hnub tam sim no lossis lub sijhawm tam sim no nrog NOW muaj nuj nqi txhais tau tias txoj haujlwm tso tawm tsis tu ncua hloov pauv.
Volatile Functions
NOW muaj nuj nqi yog tus tswv cuab ntawm Excel pab pawg ntawm cov haujlwm tsis hloov pauv, uas rov suav lossis hloov kho txhua zaus cov ntawv ua haujlwm uas lawv nyob hauv rov suav dua, ib yam li SUM thiab OFFSET ua.
Piv txwv li, cov ntawv ua haujlwm rov suav dua txhua lub sijhawm lawv qhib lossis thaum qee yam xwm txheej tshwm sim, xws li thaum koj nkag lossis hloov cov ntaub ntawv, yog li hnub lossis sijhawm hloov pauv tshwj tsis yog kev suav rov qab tsis siv neeg raug kaw.
Yuav yuam kom muaj nuj nqi hloov tshiab txhua lub sijhawm, nias Shift+ F9 txhawm rau txheeb xyuas daim ntawv ua haujlwm tam sim no lossis tam sim no, lossis nias F9 txhawm rau txheeb xyuas txhua phau ntawv qhib.
