Tsarin tantanin halitta a cikin shirin Excel ba kawai yana yanke shawarar bayyanar allon bayanan ba, har ma yana gaya wa shirin yadda ya kamata a sarrafa shi: kamar rubutu, azaman lambobi, azaman kwanan wata, da dai sauransu. Sabili da haka, yana da matukar muhimmanci a saita wannan halayyar daidai gwargwadon abin da za'a shigar bayanan. In ba haka ba, duk lissafin zai zama ba daidai ba ne. Bari mu gano yadda za a canza nau'ikan sel a Microsoft Excel.
Darasi: Rubutun rubutu a cikin Microsoft Word
Babban nau'ikan tsara su da canjin su
Nan da nan tantance irin nau'in tantanin halitta. Shirin ya nuna zabar daya daga cikin manyan nau'ikan nau'ikan tsara bayanai:
- Janar;
- Kudi;
- Lambobi
- Kudi;
- Rubutu
- Kwanan Wata
- Lokaci;
- Ctionarshe;
- Sha'awa;
- Zabi ne.
Bugu da kari, akwai rarrabuwa zuwa kananan bangarori na zabin da ke sama. Misali, kwanan wata da lokaci suna da wasu kudade da yawa (DD.MM.YY., DD.months. YY, DD.M, Ch.MM PM, HH.MM, da sauransu).
Kuna iya sauya fasalin sel a cikin Excel ta hanyoyi da yawa. Zamu yi magana game da su daki-daki.
Hanyar 1: menu na mahallin
Hanya mafi mashahuri don sauya tsararren tsaran bayanai shine amfani da menu na mahallin.
- Zaɓi ƙwayoyin waɗanda suke buƙatar tsara su daidai. Danna-dama Sakamakon haka, jerin abubuwan aiwatarwa suka buɗe. Buƙatar dakatar da zaɓi a "Tsarin kwayar halitta ...".
- Ana kunna taga tsarawa. Je zuwa shafin "Lambar"idan taga an bude shi wani wuri. Yana cikin toshe siga "Lambobin adadi" akwai waɗancan zaɓuɓɓuka don sauya halaye waɗanda aka tattauna a sama. Zaɓi abu wanda ya dace da bayanai a cikin zaɓin da aka zaɓa. Idan ya cancanta, a cikin ɓangaren dama na taga muna ƙaddara ƙimar bayanan. Latsa maballin "Ok".
Bayan waɗannan matakan, an canza tsarin sel.
Hanyar 2: Lambar kayan aiki a kintinkiri
Hakanan za'a iya canza salo ta amfani da kayan aikin da suke cikin tef. Wannan hanyar tana da sauri fiye da wacce ta gabata.
- Je zuwa shafin "Gida". A wannan yanayin, kuna buƙatar zaɓar sel da suka dace akan takardar, kuma a cikin toshe saitunan "Lambar" bude akwatin zabi a kan kintinkiri.
- Kawai sanya zaɓin zaɓin da ake so. Kewayon kai tsaye bayan hakan zai canza yadda aka tsara shi.
- Amma a cikin jerin ƙayyadaddun kawai ana gabatar da manyan tsarukan tsari. Idan kanaso kayyade tsara daidai daidai, zabi "Wasu nau'ikan tsari".
- Bayan waɗannan ayyuka, taga don tsara kewayon zai buɗe, wanda aka riga aka tattauna a sama. Mai amfani zai iya zaɓar kowane ɗaya daga cikin manyan ko ƙarin tsarin bayanan.
Hanyar 3: Akwatin Kayan Aiki
Wani zaɓi don saita wannan halayyar kewayon ita ce amfani da kayan aiki a toshe saitin "Kwayoyin".
- Zaɓi kewayon a kan takardar da za a tsara. Ana zaune a cikin shafin "Gida"danna alamar "Tsarin"wanda ke cikin rukunin kayan aiki "Kwayoyin". A cikin jerin ayyukan da zai buɗe, zaɓi "Tsarin kwayar halitta ...".
- Bayan haka, an kunna fara aikin gyaran taga da kuka saba. Duk matakan gaba daya daidai suke kamar yadda aka bayyana a sama.
Hanyar 4: Jakanni
A ƙarshe, za a iya kiran taga babban tsara ta amfani da maɓallin da ake kira zafi. Don yin wannan, da farko zaɓi yanki mai ɗorewa a kan takardar, sannan sai ka sanya haɗa a kan maballin Ctrl + 1. Bayan haka, taga daidaitaccen taga zai buɗe. Mun canza halaye daidai kamar yadda muka ambata a sama.
Kari akan haka, hadaddun hotkey na mutum yana bada damar canza tsarin sel bayan zaban kewayon koda ba tare da kiran taga na musamman ba:
- Ctrl + Shift + - - tsarin gabaɗaya;
- Ctrl + Shift + 1 - lambobi tare da mai keɓewa;
- Ctrl + Shift + 2 - lokaci (awanni. mintuna);
- Ctrl + Shift + 3 - kwanakin (DD.MM.YY);
- Ctrl + Shift + 4 - kudi;
- Ctrl + Shift + 5 - sha'awa;
- Ctrl + Shift + 6 - Tsarin O.OOE + 00.
Darasi: Babban hotkeys
Kamar yadda kake gani, akwai hanyoyi da yawa don tsara wuraren da ake amfani da takardu na Excel a lokaci guda. Ana iya aiwatar da wannan hanyar ta amfani da kayan aikin akan tef, kiran taga tsarawa, ko amfani da maɓallan zafi. Kowane mai amfani yana yanke shawara don kansa wane zaɓi ne mafi dacewa a gare shi don warware takamaiman ayyuka, saboda a wasu lokuta amfani da tsari na yau da kullun ya isa, kuma a wasu, ana buƙatar ainihin alamun halayen ta hanyar biyan buƙata.
