Lokacin aiki a cikin Excel, wani lokacin kuna so ku ɓoye ginshiƙai. Bayan haka, abubuwan da aka nuna ya daina nunawa a kan takardar. Amma abin da za a yi lokacin da kuke buƙatar kunna sake nuni? Bari mu bincika wannan batun.
Nuna ɓoyayyun ginshiƙai
Kafin ka ba da damar nuna alamun ɓoyayyun ginshiƙai, kana buƙatar gano inda suke. Wannan abu ne mai sauki. Dukkanin ginshiƙai na Excel suna alama da haruffan haruffan Latin don tsari. A wurin da aka keta wannan umarni, wanda aka bayyana da rashin wasiƙar, kuma akwai wani ɓoyayyen abu.
Methodsayyadaddun hanyoyi don ƙaddamar da bayyanar sel ɓoyayyun sun dogara da wane zaɓi aka yi amfani dashi don ɓoye su.
Hanyar 1: iya motsa iyakoki da hannu
Idan kun ɓoye sel ta hanyar motsa iyakoki, to kuna iya ƙoƙarin nuna jeri ta matsar da su zuwa ainihin wurin da suke. Don yin wannan, kuna buƙatar isa zuwa kan iyakar kuma jira don bayyanar sifar halayyar hanya biyu. Saika danna maɓallin linzamin kwamfuta na hagu ka ja kibiya zuwa gefe.
Bayan wannan hanyar, ƙwayoyin za a nuna su ta faɗaɗa, kamar yadda suke a da.
Gaskiya ne, dole ne a yi la’akari da cewa idan an motsa iyakokin sosai idan aka ɓoye su, to “taraɗuwa” a kansu ta haka zai zama da wahala, idan ba zai yiwu ba. Sabili da haka, yawancin masu amfani sun fi son su warware wannan batun ta amfani da wasu zaɓuɓɓuka.
Hanyar 2: menu na mahallin
Hanya don ba da damar bayyanar abubuwan ɓoye ta hanyar menu na mahallin duniya ne kuma ya dace a kowane yanayi, ko da wane zaɓi aka ɓoye su.
- Zaɓi ɓangarorin da ke gefen tare da haruffa a kan kwamitin daidaitawa, tsakanin sashin da ke ɓoye.
- Danna-dama kan abubuwan da aka zaɓa. A cikin mahallin menu, zaɓi Nuna.
Yanzu abubuwan da ke ɓoye zasu fara nuna sake.
Hanyar 3: Bututun Ribbon
Yin amfani da maɓallin "Tsarin" a kan tef, kamar sigar da ta gabata, ta dace da duk lamurran warware matsalar.
- Matsa zuwa shafin "Gida"idan muna cikin wani shafin daban. Zaɓi duk wasu ƙwayoyin maƙwabta waɗanda a cikinsu akwai abin da ke ɓoye. A kan kintinkiri a cikin akwatin kayan aiki "Kwayoyin" danna maballin "Tsarin". Ana buɗe menu. A cikin akwatin kayan aiki "Ganuwa" matsa zuwa nuna Boye ko nuna. A jeri wanda ya bayyana, zaɓi shigar Nuni ginshikan.
- Bayan waɗannan ayyukan, abubuwan da suke dacewa da juna zasu sake zama bayyane.
Darasi: Yadda ake ɓoye ginshiƙai a Excel
Kamar yadda kake gani, akwai hanyoyi da yawa don taimakawa bayyanar ɓoyayyun ginshiƙai. A lokaci guda, ya kamata a lura cewa zaɓi na farko tare da motsi na kan iyakoki ya dace ne kawai idan an ɓoye sel a cikin hanyar, kuma ba a motsa iyakokinsu da yawa ba. Kodayake, wannan hanyar musamman shine mafi bayyane ga mai amfani da ba a shirya ba. Amma sauran zaɓuɓɓuka biyu ta amfani da menu na mahallin da maɓallan kan ribbon sun dace don warware wannan matsala a kusan kowane yanayi, wato, duniya ne.
