Yi amfani da gajerar hanyar da ke danna don Ƙara Ranar Kwanan Wata / Lokacin a Excel

Ee, zaka iya ƙara kwanan wata zuwa Excel ta amfani da maɓallin gajeren hanya a kan keyboard.

Baya ga yin azumi, lokacin da aka ƙara kwanan wata ta amfani da wannan hanya ba zai canja kowane lokaci ana bude aikin aiki kamar yadda yake ba tare da wasu ayyukan kwanakin Excel.

Ƙara Ranar Kwanan Wata a Excel Yin Amfani da Ƙananan Maɓalli

Don samun sabunta kwanan wata a duk lokacin da aka bude aikin aiki, yi amfani da aikin yau da kullum .

Babban haɗin don ƙara kwanan wata shine:

Ctrl + ; (key-colon key)

Misali: Yin amfani da gajerar hanya don ƙarawa kwanan wata

Don ƙara kwanan wata zuwa aikin aiki ta amfani da keyboard kawai:

1. Danna kan tantanin halitta inda kake so kwanan wata zai je.
2. Latsa ka riƙe ƙasa maɓallin Ctrl akan keyboard.
3. Latsa kuma saki maɓallin yanki-ma'aunin (;) a kan keyboard ba tare da bar maɓallin Ctrl ba.
4. Saki da maɓallin Ctrl.
5. Dole ne a ƙara kwanan wata zuwa aikin aiki a cikin cell da aka zaɓa.

Tsarin tsoho don kwanan wata da aka shigar shi ne tsarin kwanan gajeren lokaci kamar yadda aka nuna a cikin hoto a sama. Yi amfani da gajeren gajeren hanya na keyboard don canja yanayin zuwa tsarin kwanan wata.

Ƙara lokaci na yanzu ta amfani da gajeren hanya

Ko da yake ba kamar yadda ake amfani da shi a kwanakin rubutu ba, ana iya amfani da wannan lokaci tare da wannan gajerar hanya ta hanya ta hanya, a tsakanin wasu abubuwa, a matsayin lokacin hatimi - tun da ba ta canza wanda aka shigar - za a iya shigar da wannan haɗin da ke biyowa ba:

Ctrl + Shift +: (maballin key)

Misali: Yin amfani da gajerar hanya yana danna don ƙara lokaci na yanzu

Don ƙara lokaci na yanzu zuwa wata takardar aiki ta amfani da keyboard kawai:

1. Danna kan tantanin halitta inda kake so lokaci zuwa.
   Latsa ka riƙe ƙasa da Ctrl da maɓallin Shift a kan keyboard.
2. Latsa kuma saki maɓallin mallaka (:) a kan keyboard ba tare da saki Ctrl da Shift keys ba.
3. A halin yanzu za a kara da shi zuwa takardar aiki.

Don samun sabunta lokaci a duk lokacin da aka bude aikin aiki, yi amfani da aikin NOW .

Tsarin Dates a Excel tare da Hanyar Hanya

Wannan matsala na Excel ya nuna maka yadda za a tsara kwanakin sauri ta amfani da tsarin kwanan wata (kamar 01-Jan-14) a cikin takardar aikin Excel ta amfani da maɓallin gajeren hanya a kan keyboard.

Maɓallin haɗin haɗe don tsara kwanakin shi ne:

Ctrl + Shift # # (alamar hash ko alamar alamar lambar)

Misali: Tsarin kwanan wata ta yin amfani da maɓallin Hanya

1. Ƙara kwanan wata zuwa tantanin halitta a cikin takardun aiki.
2. Idan ya cancanta, danna kan tantanin halitta don yin sautin mai aiki .
3. Latsa ka riƙe ƙasa Ctrl da Shift keys a kan keyboard.
4. Latsa kuma saki maɓallin hashtag (#) a kan keyboard ba tare da saki Ctrl da Shift keys ba.
5. Saki Ctrl da makullin Shift.
6. Za'a tsara kwanan wata a cikin tsarin kwanan wata kamar yadda aka nuna a cikin hoto a sama.

Tafiyar Magana a Excel tare da Hanyar Hanya

Wannan hoton na Excel ya nuna maka yadda za'a tsara lokaci a cikin takarda ta Excel ta amfani da makullin gajeren hanyoyi akan keyboard.

• Ana tsara lokaci tare da sa'a: minti: na biyu da AM / PM (kamar 10:33:00 AM)

Maɓallin haɗakarwa don tsara lokaci shine:

Ctrl + Shift @ @ (a alama)

Tsarin lokaci na yanzu ta amfani da matakan hanya ta hanya

1. Ƙara lokaci zuwa cell a cikin takarda.
2. Idan ya cancanta, danna kan tantanin halitta don yin sautin mai aiki.
3. Latsa ka riƙe ƙasa Ctrl da Shift keys a kan keyboard.
4. Latsa kuma saki maɓallin alamar hash (@) a kan keyboard - located a sama da lambar 2 - ba tare da bar Ctrl da Shift keys ba.
5. Saki Ctrl da makullin Shift.
6. Lokaci zai tsara domin nuna halin yanzu a cikin sa'a: minti daya da AM / PM kamar yadda aka gani a hoton da ke sama.