Lissafin Ƙididdigawa a Ƙafaffen Ƙaƙwalwar Hanyar Ƙaramar hanya

Formats su ne canje-canje da aka sanya zuwa ga takardun aiki na Excel don bunkasa bayyanar su da / ko don mayar da hankalin akan wasu bayanai a cikin takardun aiki.

Tsarin sake canje-canje na bayyanar bayanai, amma bai canza ainihin bayanai a cikin tantanin halitta ba, wanda zai iya zama mahimmanci idan ana amfani da wannan bayanin a lissafin. Alal misali, lambobin tsarawa don nuna kawai wurare biyu na ƙira bazai rage ko zagaye dabi'u tare da wurare fiye da biyu ba.

Don zahiri canza lambobi ta wannan hanya, ana buƙatar bayanan da aka yi amfani dashi tare da yin amfani da ɗayan ayyuka na zagaye na Excel.

01 na 04

Lissafin Lissafi a Excel

© Ted Faransanci

Ana tsara fasalin lambobi a Excel don canza bayyanar lamba ko darajar a cikin tantanin halitta a cikin takardun aiki.

Tsarin lambobi yana haɗe zuwa tantanin halitta kuma ba ga darajar cikin tantanin halitta ba. A takaice dai, tsarawar lambobi bazai canza ainihin lambar a cikin tantanin halitta ba, amma kawai hanyar da ta bayyana.

Alal misali, zaɓi tantanin halitta wanda aka tsara don mummunan, na musamman, ko lambobin tsawo kuma lambar ƙira maimakon ƙaddaraccen lambar da aka nuna a cikin maƙallin ƙari a sama da takardun aiki.

Hanyar da aka rufe don canza tsarin tsarawa sun haɗa da:

Za'a iya amfani da matakan lambobi zuwa tantanin tantanin halitta guda ɗaya, duk ginshiƙai ko layuka, wani zaɓi na zaɓin sel, ko ɗayan aikin aiki.

Tsarin tsoho don kwayoyin da ke dauke da duk bayanai shi ne Janar ɗin . Wannan salon ba shi da wani takamammen tsari kuma, ta hanyar tsoho, nuna lambobin ba tare da alamun dollar ko alamu ba da lambobi - lambobin da ke dauke da ɓangaren sashi - ba'a iyakance ga wani adadin adadin wurare mara kyau ba.

02 na 04

Aiwatar da Magana Tsarin

© Ted Faransanci

Maɓallin haɗin da za a iya amfani dasu don amfani da tsarin lambobi zuwa bayanai shine:

Ctrl + Shift + ! (maƙalari)

Fassarorin da aka yi amfani da bayanan da aka zaɓa ta amfani da makullin gajeren hanyoyi sune:

Don amfani da matakan lambobi zuwa bayanai ta amfani da maɓallan gajeren hanya:

  1. Ƙarƙashin sassan da ke dauke da bayanan da za a tsara
  2. Latsa ka riƙe ƙasa Ctrl da Shift keys a kan keyboard
  3. Latsa kuma saki maɓallin maɓallin alamar motsa jiki (!) - wanda yake sama da lamba 1 - a kan keyboard ba tare da saki Ctrl da Shift keys
  4. Saki Ctrl da makullin Shift
  5. Idan ya dace, za a tsara lambobi a jikin da aka zaɓa don nuna siffofin da aka ambata
  6. Danna kan kowane daga cikin sel yana nuna lambar da ba a ƙidayar ba a cikin maɓallin tsari a sama da takardun aiki

Lura: domin lambobi tare da wurare masu yawa fiye da biyu amma kawai wurare na biyu sune aka nuna, sauran ba a cire kuma za a yi amfani da su a cikin lissafin da suka shafi waɗannan dabi'u.

Aiwatar da Tsarin Tsarin Amfani da Zaɓi Zabin Rubutun

Kodayake wasu siffofin da aka saba amfani dasu suna samuwa a matsayin ɗigon gumaka a kan shafin shafin rubutun, kamar yadda aka nuna a cikin hoton da ke sama, yawancin adadin lambobin suna samuwa a cikin jerin Rabin Kira na Lambobi - wanda ke nuna Janar azaman tsoho tsari don sel Don amfani da zaɓin jerin:

  1. Ƙarƙirar jerin kwayoyin da za a tsara su
  2. Danna maɓallin ƙusa kusa da akwatin Lambar Saka don buɗe jerin abubuwan da aka sauke
  3. Danna maɓallin Zabuka a cikin jerin don amfani da wannan zaɓi zuwa jerin sassan da aka zaɓa

An tsara lambobi zuwa wurare biyu na ƙirawa tare da maɓallin hanya ta hanya a sama, amma ba'a amfani da rabuwa baƙaƙe da wannan hanya.

Aiwatar da Tsarin Maɓallin a cikin Siffar Magana Tsarin Siffar

Ana samun dukkan zaɓuɓɓukan tsarin lambobi ta hanyar akwatin Siffofin Siffofin Siffar .

Akwai zaɓuɓɓuka guda biyu don buɗe bakunan maganganu:

  1. Danna maɓallin maganganun maganganu - ƙuƙƙan ƙananan haɓaka zuwa ƙasa a kusurwar dama na Ƙungiyar lambar icon a kan kintinkiri
  2. Latsa Ctrl + 1 a kan keyboard

Zaɓuɓɓukan saɓo na Cell a cikin maganganun maganganu suna haɗuwa tare a jerin tsararru tare da siffofin lambobi a ƙarƙashin Lambar shafin.

A kan wannan shafin, ana rarraba samfurori masu samuwa a cikin jigogi a hannun hagu. Danna kan wani zaɓi a cikin taga da halayen kuma samfurin wannan zaɓi an nuna shi zuwa dama.

Danna Lamba a hannun hagu yana nuna halayen da za'a iya gyara

03 na 04

Aiwatar da Tattalin Kudin

© Ted Faransanci

Aiwatar da Tattalin Kudin Yin Amfani da Maɓallin Hanya

Maɓallin haɗin da za'a iya amfani dashi don amfani da tsarin jadawalin zuwa bayanai shine:

Fassarori na waje masu amfani da aka yi amfani da bayanan da aka zaɓa ta amfani da makullin gajeren hanya sune:

Matakai na Neman Kudin Kudin Yin Amfani da Hanya Kuskure

Don amfani da tsarin jadawalin zuwa bayanai ta amfani da maɓallan gajeren hanya:

  1. Ƙarƙashin sassan da ke dauke da bayanan da za a tsara
  2. Latsa ka riƙe ƙasa Ctrl da Shift keys a kan keyboard
  3. Latsa kuma saki maɓallin alamar dollar ($) - wanda yake sama da lamba 4 - a kan keyboard ba tare da yada Ctrl da makullin Shift ba
  4. Saki Ctrl da makullin Shift
  5. Za'a tsara ƙayyadaddun kuɗin waje kuma, idan ya cancanta, nuna siffofin da aka ambata
  6. Danna kan kowane daga cikin sel yana nuna lambar da ba a ƙidayar ba a cikin maɓallin tsari a sama da takardun aiki.

Aiwatar da Tattalin Kudin Yin Amfani da Zabin Rubutun

Za'a iya amfani da tsarin lissafi zuwa bayanan ta hanyar zaɓar zaɓi na Kudin daga jerin jerin sauƙi.

Alamar dollar ( $) icon da take a cikin Ƙungiyar Lamba a kan shafin shafin rubutun, ba don tsarin kudin ba amma don tsarin lissafi kamar yadda aka nuna a cikin hoto a sama.

Babban bambanci tsakanin su biyu shi ne cewa tsarin lissafi yana nuna alamar dollar a gefen hagu na tantanin halitta yayin aligning da bayanai kanta a dama.

Aiwatar da Tattalin Kudin a cikin Akwatin Siffar Siffofin Tsarin

Hanya na waje a cikin akwatin Siffar Siffofin Siffar tana da kama da tsarin lambobi, sai dai don zaɓin zaɓi na alamar waje daban daga alamar tarar ta baya.

Za a iya buɗe akwatin maganganun Siffar hanyar daya daga hanyoyi biyu:

  1. Danna maɓallin maganganun maganganu - ƙuƙƙan ƙananan haɓaka zuwa ƙasa a kusurwar dama na Ƙungiyar lambar icon a kan kintinkiri
  2. Latsa Ctrl + 1 a kan keyboard

A cikin akwatin maganganu, danna Currency akan jerin jinsin a gefen hagu don duba ko canza saitunan yanzu.

04 04

Aiwatar Kashi Gyara

© Ted Faransanci

Tabbatar cewa an nuna bayanan da aka nuna a cikin kashi dari cikin nau'in ƙaddara - kamar 0.33 - wanda, lokacin da aka tsara don kashi, zai nuna daidai kamar 33%.

Banda ga lambar 1, baƙi ba - lambobi ba tare da wani ɓangaren ƙayyadadden ba - ba a tsara shi ba bisa kashi bisa dari yayin da aka nuna yawan lambobin da kashi 100.

Alal misali, lokacin da aka tsara don kashi:

Aiwatar da Kashi Tsarin Amfani da Hanya Kullun

Maɓallin haɗin da za a iya amfani dasu don amfani da tsarin lambobi zuwa bayanai shine:

Ctrl + Shift + % (kashi alama)

Fassarorin da aka yi amfani da bayanan da aka zaɓa ta amfani da makullin gajeren hanyoyi sune:

Matakan da za a yi amfani da ƙayyadadden tsaftacewa ta yin amfani da matakai na gajeren hanya

Don amfani da tsara kashi zuwa bayanai ta amfani da maɓallin gajeren hanya:

  1. Ƙarƙashin sassan da ke dauke da bayanan da za a tsara
  2. Latsa ka riƙe ƙasa Ctrl da Shift keys a kan keyboard
  3. Latsa kuma saki kashi na maɓallin alamar (%) - located a sama da lambar 5 - a kan keyboard ba tare da yada Ctrl da makullin Shift ba
  4. Saki Ctrl da makullin Shift
  5. Lambobin a cikin zaɓuɓɓukan da aka zaɓa za a tsara su don nuna alamar kashi
  6. Danna kan kowane ɓangaren da aka tsara ya nuna lambar da ba a ƙidayar ba a cikin maɓallin tsari a sama da takardun aiki

Aiwatar Kashi Tsarin Amfani da Ribbon Zabuka

Za'a iya amfani da kashi mai yawa ga bayanai ta amfani da ko dai kashi-dari icon wanda ke cikin Rukunin Lamba a kan Shafin shafin, wanda aka nuna a cikin hoton da ke sama, ko kuma ta zaɓin Zaɓin kashi daga cikin jerin jerin sauƙi.

Bambanci kawai tsakanin su biyu shi ne cewa gunkin rubutun, kamar maɓallin kewayawa a sama, ya nuna nau'i-nau'i na wurare na decimal yayin da jerin jerin sauƙi ya nuna har zuwa wurare guda biyu. Alal misali, kamar yadda aka nuna a hoton da ke sama, ana nuna lamba 0.3256 a matsayin:

An tsara lambobi zuwa wurare biyu na ƙirawa tare da maɓallin hanya ta hanya a sama, amma ba'a amfani da rabuwa baƙaƙe da wannan hanya.

Aiwatar da Kashi Amfani da Ƙarin Siffofin Cikil

Idan akai la'akari da yawan matakai da ake buƙata don samun damar shiga cikin kashi na kashi a cikin akwatin Siffofin Siffofin, akwai sau da yawa lokacin da wannan zaɓin ya buƙaci a yi amfani maimakon ɗaya daga cikin hanyoyin da aka ambata a sama.

Dalilin da ya sa zaɓin yin amfani da wannan zaɓin shine zai canza yawan adadin ƙananan wurare da aka nuna tare da lambobi waɗanda aka tsara don kashi - a cikin akwatin maganganu yawan adadin ƙaddamar wurare da aka nuna za a iya saita daga sifilin zuwa 30.

Za a iya buɗe akwatin maganganun Siffar hanyar daya daga hanyoyi biyu:

  1. Danna maɓallin maganganun maganganu - ƙuƙƙan ƙananan haɓaka zuwa ƙasa a kusurwar dama na Ƙungiyar lambar icon a kan kintinkiri
  2. Latsa Ctrl + 1 a kan keyboard