Lokacin aiki tare da teburin Excel, sau da yawa kuna buƙatar ba kawai shigar da sel ba, har ma share su. Tsarin cirewa gabaɗaya yana da masaniya, amma akwai zaɓuɓɓuka da yawa don wannan aikin, wanda ba duk masu amfani da labarinsu ba. Bari mu ƙara koyo game da duk hanyoyin da za'a cire wasu ƙwayoyin sel daga falle mai inganci.
Karanta kuma: Yadda za a goge layi a Excel
Tsarin Kwayar Tiki
A zahiri, hanya don share sel a cikin Excel ita ce juzu'in aikin ƙara su. Ana iya rarrabu zuwa manyan kungiyoyi biyu: goge cike da rabe Kwayoyin. Karshen kallon, haka ma, za'a iya sarrafa kansa.
Yana da mahimmanci a san cewa lokacin share sel ko ƙungiyoyin su, maimakon madaidaiciya layuka da ginshiƙai, an tsara bayanai a cikin tebur. Sabili da haka, aiwatar da wannan hanyar dole ne sane.
Hanyar 1: menu na mahallin
Da farko dai, bari mu kalli aiwatar da wannan hanyar ta hanyar mahallin. Wannan shi ne ɗayan shahararrun nau'ikan yin wannan aikin. Ana iya amfani da shi ga abubuwa biyu cike da kuma waɗancan fanko.
- Zaɓi kashi ɗaya ko rukuni wanda muke so mu goge. Danna kan zaɓi tare da maɓallin linzamin kwamfuta na dama. An ƙaddamar da menu na mahallin. A ciki muke zaɓi matsayi "Share ...".
- An kaddamar da karamin taga don share sel. A ciki kuna buƙatar zaɓar ainihin abin da muke so mu goge. Akwai zaɓuɓɓuka masu zuwa:
- Sel na hagu;
- Sel tare da matsawa sama;
- Layi;
- Harafi.
Tunda muna buƙatar share sel, kuma ba duka layuka ko ginshiƙai ba, ba mu kula da zaɓuɓɓuka biyu na ƙarshe ba. Zaɓi aikin da ya dace da kai daga zaɓuɓɓuka biyu na farko, kuma saita sauyawa zuwa matsayin da ya dace. Saika danna maballin "Ok".
- Kamar yadda kake gani, bayan wannan matakin za'a share duk abubuwan da aka zaɓa, idan an zaɓi abu na farko daga jerin waɗanda aka tattauna a sama, sannan tare da matsawa.
Kuma, idan an zaɓi abu na biyu, sannan tare da matsawa zuwa hagu.
Hanyar 2: kayan aikin tef
Hakanan zaka iya share sel a cikin Excel ta amfani da kayan aikin da aka gabatar akan kintinkiri.
- Zaɓi abun da za'a share. Matsa zuwa shafin "Gida" kuma danna maballin Sharewacce take akan kintinkiri a cikin akwatin kayan aiki "Kwayoyin".
- Bayan haka, abin da aka zaɓa za a share shi tare da matsawa sama. Don haka, wannan bambance-bambancen wannan hanyar ba ta samar wa mai amfani don zaɓar shugaban dutsen ba.
Idan kanaso ka share gungun sel a wannan hanyar, to za a zartar da wadannan ka'idoji.
- Mun fitar da wannan rukunin abubuwan abubuwan kwance. Latsa maballin Sharesanya a cikin shafin "Gida".
- Kamar yadda yake a sigar da ta gabata, an share abubuwan da aka zaɓa tare da juyawa.
Idan mukayi kokarin cire kwatancen abubuwan da ke tsaye, to canjin zai faru a daya bangaren.
- Zaɓi rukuni na abubuwan tsaye. Latsa maballin. Share a kan tef.
- Kamar yadda kake gani, a ƙarshen wannan hanyar, an share abubuwan da aka zaɓa tare da matsawa zuwa hagu.
Kuma yanzu bari muyi kokarin cire hanyoyin da yawa ta amfani da wannan hanyar, dauke da abubuwan bangarorin biyu a kwance da daidaituwa.
- Zaɓi wannan tsararru kuma danna maballin. Share a kan tef.
- Kamar yadda kake gani, a wannan yanayin duk abubuwan da aka zaɓa an share su tare da juyawa.
An yi imanin cewa yin amfani da kayan aikin akan tef ɗin ba shi da aiki fiye da cirewa ta hanyar mahallin mahallin, saboda wannan zaɓi ba ya samar da mai amfani da zaɓin hanyar juyawa. Amma wannan ba haka bane. Yin amfani da kayan aikin akan tef ɗin, zaku iya share sel ta zaɓi hanyar juyawa da kanku. Bari mu ga yadda zai kaya akan misalin irin tsararru iri ɗaya a cikin tebur.
- Zaɓi jerin hanyoyin da suka kamata a share. Bayan haka, danna maɓallin kanta Share, amma akan alwatika, wanda yake nan da nan zuwa dama daga shi. Ana kunna jerin ayyukan da ke akwai. Ya kamata zaɓi zaɓi "Share sel ...".
- Bayan wannan, taga share yana farawa, wanda muka riga muka san daga zaɓi na farko. Idan muna buƙatar cire tsarin multidimensional tare da canzawa daban da wanda ke faruwa lokacin danna maballin Share akan tef, yakamata ka canza wurin zuwa wurin "Kwayoyin tare da juyawa sama". Saika danna maballin "Ok".
- Kamar yadda kake gani, bayan wannan an saita tsararru yayin da aka saita saiti a taga wanda aka share, wannan shine, tare da matsawa sama.
Hanyar 3: amfani da hotkeys
Amma hanya mafi sauri don kammala tsarin karatun yana tare da taimakon saitin haɗuwa da hotkey.
- Zabi kewayon akan takardar da muke so mu cire. Bayan haka, danna maɓallin kewayawa "Ctrl" + "-" a kan keyboard.
- Tace don share abubuwanda muka riga muka saba dasu. Zaɓi shugabanci na motsawa da ake so kuma danna maballin "Ok".
- Kamar yadda kake gani, bayan wannan an cire abubuwan da aka zaɓa tare da jagorancin motsi, wanda aka nuna a sakin baya.
Darasi: Excel hotkeys
Hanyar 4: cire abubuwa marasa kyau
Akwai lokuta idan kuna buƙatar share jeri daban-daban waɗanda basu da alaƙa, watau, suna cikin bangarori daban-daban na teburin. Tabbas, ana iya cire su ta kowane ɗayan hanyoyin da ke sama, aiwatar da hanya daban tare da kowane kashi. Amma yana iya ɗaukar lokaci mai yawa. Yana yiwuwa a cire abubuwan disparate daga cikin sauri da sauri. Amma saboda wannan ya kamata, da farko, a rarrabe.
- An zaɓi kashi na farko a hanyar da ta saba, riƙe maɓallin linzamin kwamfuta na hagu kuma kewaye da shi tare da siginan kwamfuta. Sannan yakamata ku riƙe maballin Ctrl sannan ka latsa sauran sassan disparate ko ka sanya jeri tare da siginan yayin riƙe maɓallin linzamin kwamfuta na hagu.
- Bayan an gama zaɓin, zaku iya cire ta ta amfani da kowane ɗayan hanyoyi uku da muka bayyana a sama. Duk abubuwan da aka zaɓa za'a share su.
Hanyar 5: share ƙwayoyin babu komai
Idan kuna buƙatar share abubuwa marasa komai a cikin tebur, to wannan hanyar za'a iya sarrafa kansa ba zaɓi ɗaya daga cikin daban ba. Akwai zaɓuɓɓuka da yawa don warware wannan matsala, amma hanya mafi sauƙi don yin wannan ita ce amfani da kayan aikin zaɓi na ƙungiyar tantanin halitta.
- Zaɓi tebur ko kowane iyaka akan takardar inda kake son sharewa. Sannan danna kan maɓallin aiki akan keyboard F5.
- Wurin tsalle ya fara. A ciki, danna maɓallin "Zaɓi ..."located a cikin ƙananan kusurwar hagu.
- Bayan haka, taga don zaɓar gungun sel ya buɗe. A ciki, saita canjin zuwa Kwayoyin marasa komaisannan kuma danna maballin "Ok" a cikin ƙananan kusurwar dama na wannan taga.
- Kamar yadda kake gani, bayan matakin ƙarshe, aka zaɓi duk abubuwan wofi cikin ƙayyadadden kewayon.
- Yanzu zamu iya cire waɗannan abubuwan kawai tare da kowane zaɓi da aka nuna a cikin hanyoyin ukun farko na wannan darasi.
Akwai wasu zaɓuɓɓuka don cire abubuwan wofi, waɗanda aka tattauna dalla dalla a cikin labarin daban.
Darasi: Yadda za a cire ƙwayoyin wofi a cikin Excel
Kamar yadda kake gani, akwai hanyoyi da yawa don share sel a cikin Excel. Hanyar mafi yawancinsu daidai ne, saboda haka, lokacin zabar takamaiman zaɓi, mai amfani yana mai da hankali ga abubuwan da suke so. Amma har yanzu yana da mahimmanci a lura cewa hanya mafi sauri don aiwatar da wannan hanyar tana tare da haɗakar maɓallan zafi. Raba shine cire abubuwan wofi. Ana iya sarrafa wannan aikin ta atomatik ta amfani da kayan aikin zaɓi na wayar, amma don shafewa kai tsaye har yanzu kuna da amfani da ɗayan daidaitattun zaɓuɓɓuka.
