Sebenzisa iiNqakrazo zeeNqakrazo zokongeza Umhla wamanje / ixesha kwi-Excel

Ewe, unokongeza ngokukhawuleza umhla okhoyo kwi-Excel usebenzisa izitshixo zokungqambela kwikhibhodi.

Ukongeza kokukhawuleza, xa ixesha longeziweyo usebenzisa le ndlela ayitshintshi rhoqo xa iphepha lokusebenzela livuliwe njengoko lenzayo ngemisebenzi yamhla ka-Excel.

Ukongeza Usuku Lwangoku kwi-Excel usebenzisa ii-Short Cut Keys

Ukuze ube nomhla wokuhlaziya rhoqo xa iphepha lokusebenzela livuliwe, sebenzisa umsebenzi we-TODAY .

Intlangano ebalulekileyo yokongeza umhla:

Ctrl + ; (iqhosha le-colon elincinane)

Umzekelo: Sebenzisa iiNqamlezo zemiNqampu yokongeza Umhla wamanje

Ukongeza umhla wamanje kwiphepha lokusebenzela usebenzisa kuphela ikhibhodi:

1. Cofa kwiseli apho ufuna usuku luhambe khona.
2. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
3. Cinezela kwaye ukhulule iqhosha le -colon (;) kwikhibhodi ngaphandle kokukhipha ikhiye ye Ctrl.
4. Ukukhulula ikhiye ye Ctrl.
5. Umhla wamanje kufuneka udibaniswe kwiphepha lokusebenzela kwisisele ekhethiweyo.

Ifomathi engapheliyo ngomhla ofakweyo ifomati yosuku olufutshane njengoko kuboniswe kumfanekiso ongentla. Sebenzisa enye inqamlezo yebhobhobhodi ukutshintsha ifomathi kwifomati yenyanga yenyanga.

Yongeza ixesha langoku usebenzisa i-Shortcut Keys

Nangona kungenjalo njengokuba isetyenziswa ngokuqhelekileyo njengemihla kwizipredishithi, ukongeza ixesha langoku kunye nale ndlela yokunqumla ikhibhodi ingasetyenziselwa, phakathi kwezinye izinto, njengexesha lesitampu - ekubeni ingatshintshi enye ingenayo - ingangeniswa ngolu hlobo lwendibaniso:

I-Ctrl + Shift +: (ikhiye yekholoni)

Umzekelo: Sebenzisa iiNqamlezo zemiNqampu yokongeza Ixesha langoku

Ukongeza ixesha langoku kwiphepha lokusebenzela usebenzisa kuphela ikhibhodi:

1. Cofa kwiseli apho ufuna ixesha lokuhamba.
   Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi.
2. Cinezela kwaye ukhulule iqhosha lekholoni ( :) kwibhodibhodi ngaphandle kokukhulula iifayile zeCtrl kunye neShift.
3. Ixesha langoku liya kwongezwa kwiphepha lokusebenzela.

Ukuze uhlaziye ixesha rhoqo xa iphepha lokusebenzela livuliwe, sebenzisa umsebenzi WOWOW .

Ukufometha amaxesha kwi-Excel kunye neeNqamlezo ezifutshane

Inqaku le-Excel libonisa indlela yokufometha ngokukhawuleza imihla ngokusebenzisa ifomati-yonyaka-yeshumi (njengehora-01-Jan-14) kwiphepha lokusebenzela lase Excel usebenzisa iifotshane zokunqamla kwikhibhodi.

Inhlanganisela ebalulekileyo yokufometha imihla:

Ctrl + Shift + # (itekhi yehah okanye uphawu lokungena kwenombolo)

Umzekelo: Ukufakela uMhla usebenzisa i-Shortcut Keys

1. Yongeza usuku kwiseli kwiphepha lokusebenzela.
2. Ukuba kuyimfuneko, nqakraza kwiseli ukuze wenze iseli esebenzayo .
3. Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi.
4. Cinezela kwaye ukhulule iqhosha le- hashtag (#) kwikhibhodi ngaphandle kokukhulula iifayile zeCtrl ne-Shift.
5. Ukukhupha ii-Ctrl kunye neShift.
6. Umhla uya kufomathiwa kwifom ye-nyanga yenyanga-ntsuku njengoko kuboniswe kumfanekiso ongentla.

Ukufometha amaxesha e-Excel kunye neeNqamlezo ezifutshane

Inqaku le-Excel libonisa indlela yokufometha ngokukhawuleza amaxesha kwiphepha lokusebenzela lase Excel usebenzisa izitshixo ezinqamlekileyo kwikhibhodi.

• Ixesha lifomathiwe ngeyure: umzuzu: ifomathi yesibini kunye ne-AM / PM (njenge-10: 33: 00 AM)

Intlanganiso ebalulekileyo yokwenza ifomathi yile:

Ctrl + Shift + @ (kwisimboli)

Ukufometha Ixesha langoku usebenzisa i-Shortcut Keys

1. Yongeza ixesha kwiseli kwiphepha lokusebenzela.
2. Ukuba kuyimfuneko, nqakraza kwiseli ukuze wenze iseli esebenzayo.
3. Cinezela kwaye ubambe iqhosha le Ctrl kunye neShift kwikhibhodi.
4. Cinezela kwaye ukhulule iqhosha le-hashi (@) kwikhibhodi - ekhonzwe ngenombolo 2 - ngaphandle kokukhulula iifayile zeCtrl neeShift.
5. Ukukhupha ii-Ctrl kunye neShift.
6. Ixesha liya kufomelwa ukubonisa ixesha langoku kwihora: imfutshane kunye ne-AM / PM ifomathi njengoko kuboniswe kumfanekiso ongentla.