Gajerun hanyoyin maɓallin keɓaɓɓu na Excel don tsara ƙwayoyin halitta da aiki tare da dabara

Microsoft Excel

Da zarar kun saba da gajerun hanyoyin keyboard, da wuya ku rayu ba tare da su ba. Godiya ga waɗannan maɓallan maɓallan, muddin akwai gajerar hanya don aikin da kuka saba amfani da shi, za mu guji barin kallon allo, don haka yawan aikin ku baya tasiri.

A ‘yan kwanakin da suka gabata, na buga labarin inda na nuna muku jerin gajerun hanyoyi don aiki tare da zanen gado na Excel. Yau ita ce jujjuyawar wani jerin gajerun hanyoyi, wannan lokacin, gajerun hanyoyi masu alaƙa da Tsarin salula da kuma lokacin ƙirƙirar dabara.

Gajerun hanyoyin Excel don tsara ƙwayoyin halitta

  • Ara ko cire ƙarfin hali: Umurnin + B
  • Ara ko cire rubutun rubutu: Umurnin + I
  • Ara ko cire layin layi: Umurnin + U
  • Ara ko cire hanyar fitarwa: Umurnin + Shift + X
  • Aiwatar da tsarin kuɗi: Sarrafa + Shift + E (Euro)
  • Aiwatar da ƙirar kashi: Sarrafa + Shift + Alamar Kashi (%)
  • Aiwatar da tsarin kwanan wata (rana, wata, shekara): Sarrafa + Alamar lamba (#)
  • Aiwatar da tsarin lokaci (awa da minti tare da AM ko PM): Sarrafa + Shift + A alamar (@)
  • Saka adireshin haɗin yanar gizo: Umurnin + K ko Sarrafa + K
  • Saka fashin layi a cikin tantanin halitta: Umurnin + Zaɓi + Komawa ko Sarrafawa + Zabin + Maimaitawa
  • Saka haruffa na musamman: Sarrafa + Umurnin + Spacebar
  • Daidaita Cibiyar: Umurnin + E
  • Sanya Hagu: Umurnin + L.
  • Nuna maganganun Tsarin Tsarin: Umarni + 1
  • Nuna akwatin maganganun Gyaran Cell Style: Umarni + Shift + L.
  • Sanya iyaka zuwa zababbun kwayoyin halitta: Umurnin + Zabi + 0 (sifili)
  • Cire kan iyakoki da aka fayyace: Umurnin + Zabi + Dash (-)

Gajerun hanyoyin Excel don aiki tare da dabara

  • Ara ko rushe Bar ɗin Barula: Sarrafa + Shift + U
  • Nuna mai tsara dabara: Shift + F3
  • Nuna maginin dabara (bayan ƙara sunan aiki): Sarrafa + A
  • Fara dabara: Daidaita alama (=)
  • Shigar da dabara a matsayin tsari na tsari: Umurnin + Shift + Komawa ko Sarrafawa + Shift + Komawa
  • Lissafi takardar aiki: Biyan kuɗi + F9
  • Saka tsarin AutoSum: Umurnin + Shift + T
  • Saka kwanan wata: Sarrafa + Semicolon (;)
  • Saka lokacin yanzu: Umurnin + Semicolon (;)
  • Soke shigarwa a cikin tantanin halitta ko a cikin maɓallin tsari: Maɓallin tserewa

Kasance na farko don yin sharhi

Bar tsokaci

Your email address ba za a buga. Bukata filayen suna alama da *

*

*

  1. Wanda ke da alhakin bayanan: Miguel Ángel Gatón
  2. Manufar bayanan: Sarrafa SPAM, sarrafa sharhi.
  3. Halacci: Yarda da yarda
  4. Sadarwar bayanan: Ba za a sanar da wasu bayanan ga wasu kamfanoni ba sai ta hanyar wajibcin doka.
  5. Ajiye bayanai: Bayanin yanar gizo wanda Occentus Networks (EU) suka dauki nauyi
  6. Hakkoki: A kowane lokaci zaka iyakance, dawo da share bayanan ka.