Sebenzisa Izinkinobho Zokunqamulela Ukwengeza Usuku Lwangempela / Isikhathi ku-Excel

Yebo, ungangeza ngokushesha usuku lwamanje ku-Excel usebenzisa izinkinobho zokunqamulela ekhibhodi.

Ngaphezu kokusheshisa, uma usuku lengeziwe ngokusebenzisa le ndlela alishintsha njalo uma ishidi lomsebenzi livuliwe njengalokhu lisebenza ngeminye imisebenzi yosuku lwe-Excel.

Ukwengeza Usuku Lwanamuhla ku-Excel Ukusebenzisa Amakhadi Okunciphisa Okufushane

Ukuze ube nokuvuselelwa kwedethi njalo uma ishidi lokusebenzela livuliwe, sebenzisa umsebenzi we-TODAY .

Inhlanganisela ebalulekile yokwengeza usuku:

Ctrl + ; (ukhiye we-colon wamaminithi)

Isibonelo: Ukusebenzisa Amathanga Ashothikhathi Ukwengeza Usuku Lwanamuhla

Ukwengeza usuku lwamanje kushidi lokusebenzela usebenzisa ikhibhodi kuphela:

1. Chofoza kuseli lapho ufuna khona usuku.
2. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
3. Cindezela bese ukhulula ukhiye we-colon (;) kukhibhodi ngaphandle kokukhipha ukhiye we-Ctrl.
4. Khipha ukhiye we-Ctrl.
5. Usuku lwamanje kufanele lufakwe kushidi lomsebenzi esitokisini esikhethiwe.

Ifomethi ezenzakalelayo yosuku olufakelwe yifomethi yosuku olufushane njengoba kuboniswe esithombeni ngenhla. Sebenzisa esinye isinqamuleli sekhibhodi ukuze ushintshe ifomethi kusakhiwo sonyaka wenyanga.

Engeza isikhathi samanje usebenzisa izinqamuleli zezinqamuleli

Nakuba kungasetshenzisiwe njengamanje kuma-spreadsheet, ukungeza isikhathi samanje nalokhu kunqamulela kwekhibhodi kungasetshenziswa, phakathi kwezinye izinto, njengesitembu sesikhathi - njengoba kungashintshi eyodwa ukungena - kungangenwa ngenhlanganisela eyinhloko elandelayo:

I-Ctrl + Shift +: ((ukhiye wekhaloni)

Isibonelo: Ukusebenzisa Izinkinobho Zesinqamuleli Ukwengeza Isikhathi Sanje

Ukwengeza isikhathi samanje kushidi lokusebenzela usebenzisa nje ikhibhodi:

1. Chofoza kuseli lapho ufuna khona isikhathi.
   Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi.
2. Cindezela bese ukhulula ukhiye wekhaloni ( :) ekhibhodi ngaphandle kokukhipha okhiye be-Ctrl ne-Shift.
3. Isikhathi samanje sizofakwa ekhasini lokusebenzela.

Ukuze uvuselelwe isikhathi njalo uma ishidi lokusebenzela livuliwe, sebenzisa umsebenzi we-MANJE .

Ukufometha Amadokhumenti ku-Excel ne-Shortcut Keys

Leli phuzu le-Excel likukhombisa indlela yokufometha ngokushesha izinsuku usebenzisa isakhiwo se-day -month (njengama-01-Jan-14) kuphepha lokusebenzela le-Excel usebenzisa izinkinobho zokunqamulela ekhibhodi.

Inhlanganisela eyinhloko yamalanga wokufometha yi:

I-Ctrl + Shift + # (umaki we-hashi noma ukhiye wezinombolo)

Isibonelo: Ukufometha Usuku usebenzisa Amathanga Ashothikhathi

1. Engeza usuku esitokisini kushidi lokusebenzela.
2. Uma kunesidingo, chofoza kuseli ukuze wenze iseli esebenzayo .
3. Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi.
4. Cindezela bese ukhulula ukhiye we- hashtag (#) kukhibhodi ngaphandle kokukhipha okhiye be-Ctrl ne-Shift.
5. Khipha okhiye be-Ctrl ne-Shift.
6. Idethi izofomathwa kwifomethi yonyaka wenyanga njengoba kuboniswa esithombeni ngenhla.

Ukufometha ama-Times ku-Excel ne-Shortcut Keys

Leli phuzu le-Excel likukhombisa indlela yokufometha ngokushesha izikhathi esikhwameni sokusebenzela se-Excel usebenzisa izinkinobho zokunqamulela ekhibhodi.

• I-Times ihlelwe ngehora: iminithi: ifomethi yesibili kanye ne-AM / PM (njenge-10:33:00 AM)

Inhlanganisela eyinhloko yezikhathi zokufometha yi:

I-Ctrl + Shift + @ (esithombeni)

Ukufometha isikhathi samanje usebenzisa izinqamuleli zezinqamuleli

1. Engeza isikhathi esitokisini kwiphepha lokusebenzela.
2. Uma kunesidingo, chofoza kuseli ukuze wenze iseli esebenzayo.
3. Cindezela bese ubamba izinkinobho ze- Ctrl ne- Shift ekhibhodi.
4. Cindezela bese ukhulula ukhiye we-hash (@) ekhibhodi - etholakala ngaphezu kwenombolo 2 - ngaphandle kokukhulula ukhiye we-Ctrl ne-Shift.
5. Khipha okhiye be-Ctrl ne-Shift.
6. Isikhathi sizofomatha ukukhombisa isikhathi samanje ngehora: iminithi kanye nefomethi ye-AM / PM njengoba kuboniswe esithombeni ngenhla.