Gwiritsani Ntchito Zowonjezera Kuti Muwonjezere Tsiku Loyamba / Nthawi mu Excel

Inde, mungathe kuwonjezerapo mwatsatanetsatane tsiku lomwe likugwiritsidwa ntchito ku Excel pogwiritsa ntchito makina osatsekera pa makiyi.

Kuwonjezera pa kufulumira, pamene tsiku likuwonjezeredwa pogwiritsira ntchito njirayi silinasinthe nthawi iliyonse tsamba lamasamba litatsegulidwa monga likuchitira ndi ntchito zina za tsiku la Excel.

Kuwonjezera Tsiku Lachidule mu Excel Pogwiritsa Ntchito Zowonjezera Zake

Kuti mukhale ndi ndondomeko ya tsiku nthawi iliyonse tsamba lamasamba likatsegulidwa, gwiritsani ntchito ntchito YA MASIKU ano .

Kuphatikizira kwakukulu kwa kuwonjezera tsikuli ndi:

Ctrl + ; (key-colon key)

Chitsanzo: Kugwiritsa Ntchito Njira Zowonjezera Kuti Muwonjezere Tsiku Lino

Kuwonjezera tsiku lamakono ku tsamba lolemba pogwiritsa ntchito kamphindi:

1. Dinani pa selo komwe mukufuna tsikulo.
2. Dinani ndi kusunga makiyi a Ctrl pa makiyi.
3. Dinani ndi kumasula fungulo lachimake (;) pa kibokosi popanda kumasula makiyi a Ctrl.
4. Tulutsani makiyi a Ctrl.
5. Tsiku lamakono liyenera kuwonjezeredwa pa tsamba la ntchito mu selo losankhidwa.

Maonekedwe osasinthika a tsiku lolembedwera ndi mawonekedwe a tsiku lalifupi monga momwe tawonetsera pa chithunzi pamwambapa. Gwiritsani ntchito njira yina yachinsinsi kuti musinthe mtunduwu kwa mtundu wa chaka cha mwezi.

Onjezani Nthawi Yamakono pogwiritsira Ntchito Zowonjezera Keys

Ngakhale kuti sizinagwiritsidwe ntchito mofanana monga masiku m'masamba, kuwonjezera nthawi yeniyeni ndi njira yotsatirali iyi ingagwiritsidwe ntchito, mwazinthu zina, ngati nthawi yosamalidwa - popeza yosasintha imodzi yalowa - ikhoza kulowa ndi mgwirizano wotsatirawu:

Ctrl + Shift +: (key key)

Chitsanzo: Kugwiritsa Ntchito Zowonjezera Zowonjezera Kuwonjezera Nthawi Yamakono

Kuwonjezera nthawi yeniyeni ku tsambali pogwiritsa ntchito khibodiyi:

1. Dinani mu selo kumene mukufuna nthawi yoti mupite.
   Dinani ndi kugwirizira makina a Ctrl ndi Shift pa makiyi.
2. Dinani ndi kumasula makiyi a colon (:) pa kibokosi popanda kumasula makiyi a Ctrl ndi Shift.
3. Nthawi yowonjezera idzawonjezeredwa pa tsamba la ntchito.

Kuti mukhale ndi nthawi yatsopano nthawi iliyonse yomwe tsambalo lidatsegulidwa, mugwiritseni ntchito MASIKU ano .

Kukonzekera Masiku mu Excel ndi Zowonjezera Zowonjezera

Nthano iyi ya Excel ikukuwonetsani momwe mungapangire mwamsanga masabata pogwiritsira ntchito tsiku -momwe -mapangidwe a chaka (monga 01-Jan-14) mu tsamba la Excel pogwiritsira ntchito makina osinthana pa makiyi.

Mgwirizano wofunikira wa masiku ojambula ndi:

Ctrl + Shift + # (chizindikiro cha chikhomo kapena chizindikiro cha nambala)

Chitsanzo: Kupanga Tsikulo pogwiritsa Ntchito Njira Zowonjezera

1. Onjezerani tsikulo ku selo muzomwe mukulemba.
2. Ngati ndi kotheka, dinani selo kuti mupange selo yogwira ntchito .
3. Dinani ndi kugwira Ctrl ndi Shift mafungulo pa makiyi.
4. Dinani ndi kumasula fungulo la hashtag (#) pa kibokosi popanda kumasula makiyi a Ctrl ndi Shift.
5. Tulutsani makiyi a Ctrl ndi Shift.
6. Tsikulo lidzapangidwe mu maonekedwe a chaka cha mwezi monga momwe zikusonyezedwera mu chithunzi pamwambapa.

Kupanga nthawi mu Excel ndi Zowonjezera Zowonjezera

Nthano iyi ya Excel ikuwonetsani momwe mungapangire mwamsanga nthawi mu tsamba la Excel pogwiritsira ntchito makiyi a njira zachinsinsi pa makiyi.

• Nthawi zimapangidwa ndi ora: mphindi: yachiwiri ndi AM / PM maonekedwe (monga 10:33:00 AM)

Mgwirizano wofunikira pa nthawi zoyika maonekedwe ndi:

Ctrl + Shift + @ (pa chizindikiro)

Kukonza Nthawi Yamakono pogwiritsa Ntchito Zowonjezera Keys

1. Onjezerani nthawi ku selo mu pepala lolemba.
2. Ngati ndi kotheka, dinani selo kuti mupange selo yogwira ntchito.
3. Dinani ndi kugwira Ctrl ndi Shift mafungulo pa makiyi.
4. Sindikizani ndi kumasula fayilo yamtundu wa hashi (@) pa khibhodi - yomwe ili pamwamba pa nambala 2 - popanda kumasula makiyi a Ctrl ndi Shift.
5. Tulutsani makiyi a Ctrl ndi Shift.
6. Nthawi idzapangidwe kuti isonyeze nthawi yeniyeni mu ora: miniti ndi AM / PM mawonekedwe monga momwe tikuwonera pa chithunzi pamwambapa.