Lokacin aiki tare da maƙunsar Excel, wani lokaci kuna buƙatar ɓoye wasu wurare na takardar aiki. Sau da yawa ana yin wannan idan, alal misali, suna ɗauke da dabaru. Bari mu gano yadda zaku ɓoye ginshiƙan a cikin wannan shirin.
Boye Algorithms
Akwai zaɓuɓɓuka da yawa don yin wannan hanyar. Bari mu gano menene asalinsu.
Hanyar 1: motsi na sel
Mafi kyawun zaɓi wanda zaku iya cimma sakamakon da ake so shine motsi na sel. Domin aiwatar da wannan hanyar, muna ta ɓoye a gaban kwamitin daidaitawa a inda iyakar take. Kibiya mai nuna halayyar ta bayyana a dukkan bangarorin. Hagu-danna kuma ja iyakokin yanki ɗaya zuwa kan iyakar wani, gwargwadon abin da za a iya yi.
Bayan haka, za a ɓoye ɗayan abubuwa a bayan wani.
Hanyar 2: yi amfani da menu na mahallin
Zai fi dacewa da amfani da menu na mahallin don waɗannan dalilai. Da fari dai, ya fi sauƙi sama da iyakokin ƙasa, kuma na biyu, ta wannan hanyar, yana yiwuwa a cimma cikakkiyar ɓoyayyen sel, sabanin sigar da ta gabata.
- Mun danna dama-dama kan kwamiti na daidaituwa a sashin harafin Latin, wanda ke nuna shafin da zai ɓoye.
- A cikin menu na mahallin da ke bayyana, danna maballin Boye.
Bayan haka, shafin da aka ƙayyade zai ɓoye gaba ɗaya. Don tabbatar da wannan, kalli yadda ake yiwa labulen alama. Kamar yadda kake gani, wasiƙa guda batace a cikin tsari mai tsari.
Amfanin wannan hanyar akan wanda ya gabata ya ta'allaka ne akan cewa tare da shi zaku iya ɓoye lambobi masu yawa a lokaci guda. Don yin wannan, zaɓi su, kuma a cikin menu ake kira mahallin, danna kan abu Boye. Idan kuna son aiwatar da wannan hanyar tare da abubuwanda basa kusa da juna, amma suna warwatse ko'ina cikin takaddar, to lallai ne a zaba zaɓin tare da maɓallin da aka matse. Ctrl a kan keyboard.
Hanyar 3: yi amfani da kayan aikin tef
Bugu da kari, zaku iya yin wannan hanyar ta amfani da ɗayan maɓallan a kan kintinkiri a cikin toshe kayan aiki "Kwayoyin".
- Zaɓi sel waɗanda ke cikin ɓoyayyun abin da kake son ɓoyewa. Kasancewa a cikin shafin "Gida" danna maballin "Tsarin", wanda aka sanya a kan tef a cikin toshe kayan aiki "Kwayoyin". A menu wanda ya bayyana a rukunin saiti "Ganuwa" danna kan kayan Boye ko nuna. Ana kunna wasu jerin, wanda kuke buƙatar zaɓi abu A ɓoye ginshiƙai.
- Bayan wadannan matakan, za a boye ginshikan.
Kamar yadda ya gabata, a wannan hanyar zaka iya ɓoye abubuwa da yawa a lokaci daya, nuna su, kamar yadda aka bayyana a sama.
Darasi: Yadda za a nuna ɓoyayyen ginshiƙai a cikin Excel
Kamar yadda kake gani, akwai hanyoyi da yawa don ɓoɓo abubuwan ginshiƙai a cikin Excel. Hanya mafi fahimta ita ce canzawa sel. Amma, yana da shawarar cewa duk da haka kuyi amfani da ɗayan zaɓuɓɓuka biyu masu zuwa (menu na mahallin ko maɓalli akan kintinkiri), tunda suna da tabbacin cewa sel za a ɓoye gaba ɗaya. Bugu da kari, abubuwan da aka boye ta wannan hanyar zasu kasance da sauki su nuna baya idan ya zama dole.
