Don aiwatar da ayyuka daban-daban tare da abubuwan da ke cikin ƙwayoyin Excel, dole ne a fara zaɓe su. Don waɗannan dalilai, shirin yana da kayan aiki da yawa. Da farko dai, wannan bambancin ya kasance ne saboda gaskiyar cewa akwai buƙatar haskaka gungun sel daban-daban (jeri, layuka, ginshiƙai), da kuma buƙatar alamar abubuwan da suka dace da wani yanayin. Bari mu gano yadda ake yin wannan hanya ta hanyoyi daban-daban.
Tsarin zaɓi
A kan aiwatar da zaɓi, zaku iya amfani da linzamin kwamfuta da kuma keyboard. Hakanan akwai hanyoyi inda aka haɗa waɗannan na'urorin shigar da juna.
Hanyar 1: sel guda
Domin zaɓar sel guda, kawai ka liƙa kan shi da danna hagu. Hakanan, ana iya aiwatar da irin wannan zaɓi ta amfani da maɓallin maballin akan maɓallin kewaya maballin "Na sauka", Sama, Dama, Hagu.
Hanyar 2: zaɓi shafi
Domin alamar alama a cikin tebur, riƙe maɓallin linzamin kwamfuta na hagu kuma ja daga kananun saman da ke kan layi zuwa ƙasa, inda ya kamata a fito da maɓallin.
Akwai wani zaɓi don warware wannan matsalar. Riƙe maɓallin Canji a kan keyboard kuma danna kan saman sel na shafi. Sannan, ba tare da sakin maɓallin ba, danna ƙasa. Kuna iya aiwatar da ayyuka a cikin tsarin baya.
Bugu da kari, za a iya amfani da wadannan algorithm mai zuwa don nuna ginshiƙai a cikin tebur. Zaɓi sel na farko na shafi, sakin linzamin kwamfuta ka latsa haɗin maɓallin Ctrl + Shift + Girman Arrow. A wannan yanayin, an zaɓi gaba ɗaya zuwa kashi na ƙarshe wanda acikin bayanan yake ƙunshe. Wani muhimmin yanayi don aiwatar da wannan hanyar shine rashin ƙwayoyin wofi a cikin wannan shafi na teburin. In ba haka ba, kawai yankin kafin farkon komai ɗin alama za'a alama.
Idan kanaso ka zabi bawai bangaran tebur ba, amma gaba daya shafin takarda, to a wannan yanayin kana bukatar kawai danna-danna ne kan sashin hada-hadar daidaituwa, inda harafin haruffan ke nuna sunayen ginshikan.
Idan ya zama dole don zaɓar ginshiƙan lambobi da yawa, sai a ja linzamin kwamfuta tare da maɓallin hagu da aka matse tare da sassan da ke daidai na kwamitin daidaitawa.
Akwai wata hanyar warwarewa. Riƙe maɓallin Canji kuma yi alama shafi na farko a jerin masu alama. Bayan haka, ba tare da sakin maɓallin ba, danna kan ɓangaren ƙarshe na kwamitin daidaitawa a cikin jerin ginshiƙai.
Idan kanaso ka zabi maballin warwatse na takarda, to sai ka riƙe maɓallin Ctrl kuma, ba tare da sake shi ba, mun danna sashen a cikin kwamitin daidaitawa na kowane shafi da za a yi alama.
Hanyar 3: haskaka layin
Hakanan, ana layin layi a cikin Excel.
Don zaɓar layi ɗaya a cikin tebur, kawai zana alama a kanta tare da maɓallin linzamin kwamfuta da ke ƙasa.
Idan tebur ɗin ya yi girma, ya fi sauƙi a riƙe maɓallin Canji sannan kuma danna maballin farko da na karshe na layin.
Hakanan, layuka a cikin tebur za a iya lura da su a cikin hanya ɗaya zuwa ginshiƙai. Latsa abu na farko a cikin shafi, sannan sai a buga a gajeriyar hanya Ctrl + Shift + Arrow Dama. An yi layin alama zuwa ƙarshen tebur. Amma kuma, muhimmi a wannan yanayin shine kasancewa data a cikin dukkanin sel na jere.
Don zaɓar duk layin takardar, danna kan ɓangaren daidaitawa na kwamitin daidaitawa na tsaye, inda aka nuna lamba.
Idan ya zama dole don zaɓar layin kusa da dama ta wannan hanyar, to sai a ja maɓallin hagu a kan rukuni mai dacewa na ɓangarorin haɗin gwiwar tare da linzamin kwamfuta.
Hakanan zaka iya riƙe maɓallin Canji sannan ka latsa bangaren farko da na karshe a kwamitin hadin gwiwar yawan layin da ya kamata a zaba.
Idan kuna buƙatar zaɓi layin dabam, sannan danna kowane ɗayan bangarorin akan ɓangaren daidaitawa na tsaye tare da maɓallin da aka matse Ctrl.
Hanyar 4: zaɓi hanyar gaba ɗaya
Akwai zaɓuɓɓuka biyu don wannan hanyar don ɗaukacin takarda. Na farkon shi ne danna maballin maɓallin rectangular wanda yake a tsakiyar hanyar daidaitawar daidaituwa da kwance. Bayan wannan aikin, za a zaɓi dukkan ƙwayoyin da ke kan takardar.
Danna maɓallin kewayawa zai haifar da sakamako iri ɗaya. Ctrl + A. Koyaya, idan a wannan lokacin siginan yana cikin kewayon bayanan da ba za a iya rarrabewa ba, misali, a cikin tebur, to wannan yankin ne kawai za'a fara zaba. Bayan an sake haɗa haɗarin ne kawai zai yuwu a zaɓi dukkan takaddun.
Hanyar 5: Ranti mai haske
Yanzu bari mu gano yadda za a zaɓi nau'ikan ƙwayoyin sel akan takardar. Don yin wannan, ya isa don kewaya siginan kwamfuta tare da maɓallin-hagu a kan wani yanki akan takardar.
Za'a iya zaɓar kewayon ta hanyar riƙe maɓallin Canji a kan maballin keyboard saika danna maɓallin hagu da ƙananan dama na yankin da aka zaɓa. Ko kuma ta hanyar yin wannan aikin a maimaita baya: danna kan hagu na dama da hagu na dama na tsararru. Za'a fadada ma'ana tsakanin wadannan abubuwan.
Haka nan akwai yiwuwar yin haskaka ƙwayoyin sel dabam dabam. Don yin wannan, ta kowane ɗayan hanyoyin da ke sama, kuna buƙatar zaɓa daban kowane yanki da mai amfani yake so ya tsara shi, amma dole ne a rufe maballin Ctrl.
Hanyar 6: amfani da hotkeys
Kuna iya zaɓar kowane yanki guda ɗaya ta amfani da maɓallan zafi:
- Ctrl + Gida - zaɓi na sel na farko tare da bayanai;
- Ctrl + .arshe - zaɓi na sel ɗin ƙarshe tare da bayanai;
- Ctrl + ftaura + .are - zaɓi na sel har zuwa na ƙarshe da aka yi amfani da shi;
- Ctrl + Shift + Gida - zaɓi na sel har zuwa farkon takardar.
Waɗannan zaɓuɓɓuka na iya adana lokaci cikin aiki.
Darasi: Babban hotkeys
Kamar yadda kake gani, akwai zaɓi da yawa don zaɓar ƙwayoyin sel da ƙungiyoyin su daban daban ta amfani da maballin linzamin kwamfuta ko linzamin kwamfuta, kazalika da amfani da haɗin waɗannan na'urori guda biyu. Kowane mai amfani zai iya zaɓar salon zaɓin da ya fi dacewa da kansa a cikin wani yanayi na musamman, saboda ya fi dacewa don zaɓar ƙwayoyin guda ɗaya ko da yawa a wata hanya, kuma don zaɓar babban layi ko duka takardar a wata.
