Shandisa Shortcut Keys kuti uwedzere Current Date / Time mu Excel

Hongu, iwe unogona kuwedzera nokukurumidza zuva razvino rekuenda kune Excel uchishandisa zvidzitiro zviduku pane keyboard.

Mukuwedzera pakukurumidza, kana zuva racho richiwedzerwa uchishandisa nzira iyi harina kuchinja nguva dzose kana pepa rekushanda richizarurirwa sezvinoitwa nemamwe mabasa ezuva reExcel.

Kuwedzera Kwemazuva Ano Mazuva Eku Excel Using Short Cut Keys

Kuti uve nehuwandu hunovandudzwa nguva dzose kana pepa rekushandura richizarurirwa, shandisa basa reTODAY .

Iko kusanganiswa kwekuwedzera kwezuva ndechekuti:

Ctrl + ; (key semi-colon key)

Muenzaniso: Kushandisa Zvidhori ZveKutsvaga kuwedzera Mazuva Ano

Kuti uwedzere zuva razvino kumushandisi wepaji uchishandisa chete keyboard:

1. Dzvanya pane sero apo iwe uchida kuti zuva riende.
2. Dhinda uye ubatisise kamba Ctrl pane keyboard.
3. Shingairira uye musunungure kiyi-colon key (;) pane keyboard asi musununguri Ctrl.
4. Bvisa Ctrl.
5. Zuva rezuva rino rinofanira kuwedzerwa kushizha rinoshandiswa mumusero wakasarudzwa.

Nzira isina kuitika yezuva rakapinda ndiyo pfupi yakarongerwa zuva sezvaratidzwa mumufananidzo uri pamusoro. Shandisa imwe nzira yechitsinhanisi yebhobhoji kuti uchinje mafaira kusvika pamwedzi wemwedzi wegore.

Wedzera Iko nguva Ino kushandisa Shortcut Keys

Kunyange zvazvo zvisingaiti sezvinowanzoshandiswa sezvenhare mumapaparishiti, kuwedzera nguva yemazuva iri nekunotswa kwebhokisi kwekombiyuta inogona kushandiswa, pakati pezvimwe zvinhu, sechitanhatu nguva - sezvo isingashanduki imwe inopinda - inogona kuiswa nehukuru hunotevera:

Ctrl + Shift +: ((key koron)

Muenzaniso: Kushandisa Zvimedu Zvitsva Zvokuwedzera Maawa Ano

Kuwedzera nguva yemazuva ano kune pepa rekushandisa uchishandisa chete keyboard:

1. Dzvanya pane sero apo iwe unoda nguva yekuenda.
   Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard.
2. Dhinda uye ubudise kiyi yekoloni (:) pane keyboard asi isunungure Ctrl uye Shift keys.
3. Nguva yemazuva ano ichawedzerwa pane pepa rekushanda.

Kuti uve nenguva yekudzokorora nguva dzose apo pepa rekushandura rakazarurirwa, shandisa IYO basa iri .

Kugadzira Dates muExpcel ne Shortcut Keys

Iyi Excel tip inokuratidza kuti ungakurumidza sei kuronga mazuva uchishandisa zuva -mwedzi-format format (yakadai sa 01-Jan-14) mune pepa rekushanda Excel uchishandisa zvidzitiro zviduku pane keyboard.

Iko kuunganidzwa kwekufambisa mazuva ndiyo:

Ctrl + Shift + #

Muenzaniso: Kugadzirisa zuva raKushandisa Shortcut Keys

1. Wedzera zuva kune keseti mune pepa rekushanda.
2. Kana zvichidikanwa, chengetera pane sero kuti uite sero rinoshanda .
3. Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard.
4. Dhinda uye ubudise hashtag key (#) pabhobhoyo pasina kusunungura Ctrl uye Shift keys.
5. Bvisa Ctrl uye Shift keys.
6. Zuva racho richagadziridzwa mumwedzi wegore-mwedzi mafaira sezvaratidzwa mumufananidzo uri pamusoro.

Kugadzirisa Nguva muExcel ne Shortcut Keys

Iyi Excel tip inokuratidza kuti ungakurumidza sei kutora nguva mune imwe shanduro yekushanda ye Excel uchishandisa mashomanana ekutsvaga pa keyboard.

• Nguva dzinoitwa neawa: miniti: yechipiri uye AM / PM format (yakadai sa10: 33: 00 AM)

Iko inokosha yekubatanidzwa nguva yekufambisa ndeyi:

Ctrl + Shift + @ (pane chiratidzo)

Kugadzirisa Ikozvino nguva kushandisa Shortcut Keys

1. Wedzera nguva yechiteri mune pepa rekushanda.
2. Kana zvichidikanwa, chengetera pane sero kuti uite sero rinoshanda.
3. Dhinda uye ubatisise Ctrl uye Shift keys pane keyboard.
4. Shingairira uye musunungure pikicha yeshi yehandi (@) pane keyboard - iri pamusoro pe nhamba 2 - musingabudisi Ctrl uye Shift keys.
5. Bvisa Ctrl uye Shift keys.
6. Nguva yacho ichagadziridzwa kuratidzira nguva yemazuva ino muawa: maminiti uye AM / PM mafomu sezvinoonekwa mumufananidzo uri pamusoro.