Dingara ƙwayoyin sel a Microsoft Excel

A matsayinka na mai mulki, ga mafi yawan masu amfani, ƙara sel yayin aiki a Excel ba su wakilci aiki mai wahala sosai. Amma, da rashin alheri, ba kowa ba ne ya san duk hanyoyin da za a yi don yin hakan. Amma a wasu yanayi, aikace-aikace na musamman hanya zai taimaka rage lokacin da aka kashe akan aikin. Bari mu bincika menene zaɓuɓɓukan don ƙara sababbin ƙwayoyin sel a cikin Excel.

Dubi kuma: Yadda za a ƙara sabon layi a cikin tebur na Excel
Yadda ake saka shafi a Excel

Tsarin Haɓaka Kwayoyin

Nan da nan za mu mai da hankali kan yadda ake daidai daga bangaren fasaha ana aiwatar da aikin ƙara ƙwayoyin. Gabaɗaya, abin da muke kira “ƙara” shine ainihin motsawa. Wannan shine, sel kawai canzawa ƙasa zuwa dama. Abubuwan da suke gefen gangar an share su lokacin da aka ƙara ƙwayoyin sel. Don haka, ya zama dole a sa ido kan yadda aka nuna lokacin da takardar ke cike da bayanai sama da 50%. Kodayake, ba da cewa a cikin nau'ikan zamani ba, Excel yana da layuka miliyan 1 da ginshiƙai akan takarda, a aikace irin wannan buƙatar yana da matukar wuya.

Bugu da kari, idan kun kara sel, maimakon duka layuka da layuka, kuna buƙatar yin la’akari da cewa a cikin teburin da zaku yi aikin da aka ƙayyade, bayanan zasu canza, kuma dabi'u bazai dace da waɗancan layuka ko ginshiƙan da suka yi daidai ba.

Don haka, yanzu bari mu ci gaba zuwa takamaiman hanyoyi don ƙara abubuwa a cikin takardar.

Hanyar 1: Menu na Yanayi

Daya daga cikin hanyoyin gama gari don ƙara ƙwayoyin sel a cikin Excel shine amfani da menu na mahallin.

1. Zaɓi ɓangaren takardar inda muke so mu saka sabon sel. Mun danna shi tare da maɓallin linzamin kwamfuta na dama. An ƙaddamar da menu na mahallin. Zabi wani matsayi a ciki "Manna ...".



2. Bayan haka, an buɗe ƙaraf ɗin taga. Tunda muna da sha'awar shigar da sel, maimakon duka layuka ko ginshiƙai, abubuwan "Layi" da Harafi mu yi watsi. Munyi zabi tsakanin maki "Kwayoyin, canzawa zuwa dama" da "Sel tare da canzawa", daidai da tsare-tsarensu na shirya teburin. Bayan an yi zaɓi, danna maballin "Ok".



3. Idan mai amfani ya zabi "Kwayoyin, canzawa zuwa dama", sannan canje-canjen zasu ɗauki kusan nau'i kamar yadda yake a cikin tebur da ke ƙasa.

   

   Idan aka zaɓi zaɓi kuma "Sel tare da canzawa", to, teburin zai canza kamar haka.

Ta wannan hanyar, zaka iya ƙara duk rukuni na sel, don wannan kawai, kafin ka shiga menu na mahallin, zaka buƙaci zaɓi adadin abubuwan da ke daidai a kan takardar.

Bayan haka, abubuwan za a kara su daidai da irin tsarin da muka bayyana a sama, amma daukacin rukunin.

Hanyar 2: Bututun Ribbon

Hakanan zaka iya ƙara abubuwa zuwa takardar Excel ta maɓallin akan kintinkiri. Bari mu ga yadda ake yi.

1. Zaɓi kashi a wurin takardar lokacin da muke shirin ƙara tantanin halitta. Matsa zuwa shafin "Gida"idan a halin yanzu muna cikin wani. Saika danna maballin Manna a cikin akwatin kayan aiki "Kwayoyin" a kan tef.



2. Bayan haka, za'a ƙara abu a cikin takardar. Haka kuma, a kowane hali, za'a kara shi tare da kashe farashi. Don haka wannan hanyar har yanzu ba ta da sassauƙa fiye da wacce ta gabata.

Yin amfani da wannan hanyar, zaka iya ƙara rukunin ƙwayoyin.

1. Zaɓi rukuni a kwance na abubuwan haɗin takardar kuma danna kan alamar da muka sani Manna a cikin shafin "Gida".



2. Bayan haka, za a shigar da rukunin abubuwa na takarda, kamar yadda tare da ƙari guda, tare da matsawa ƙasa.

Amma lokacin da muke zaɓi ɗakunan sel na tsaye, zamu sami sakamako daban.

1. Zaɓi rukuni tsaye na abubuwa kuma danna maballin Manna.



2. Kamar yadda kake gani, sabanin zaɓuɓɓukan da suka gabata, a wannan yanayin an ƙara gungun abubuwa tare da canzawa zuwa dama.

Menene zai faru idan muka ƙara abubuwa da yawa waɗanda ke da madaidaiciyar hanya da ta tsaye a cikin hanyar guda?

1. Zaɓi wani tsari na daidaiton da ya dace ka danna maɓallin da muka riga muka san Manna.



2. Kamar yadda kake gani, a wannan yanayin, ana shigar da abubuwa tare da juyawa zuwa dama zuwa yankin da aka zaɓa.

Idan har yanzu kuna son bayyana takamaiman wurinda yakamata a canza abubuwan, kuma, alal misali, lokacin da za a ƙara shirin, kuna son canzawa ya sauka, to ya kamata ku bi umarnin nan.

1. Zaɓi kashi ko gungun abubuwan da muke so mu saka a ciki. Mun danna maballin da bamu saba dashi ba Manna, kuma tare da alwatika, wanda aka nuna shi daman shi. Lissafin ayyuka ya buɗe. Zaɓi abu a ciki "Saka sel ...".



2. Bayan wannan, taga shigarwa, wanda ya riga ya saba da mu a farkon hanyar, yana buɗewa. Zaɓi zaɓi na sa. Idan mu, kamar yadda muka ambata a sama, muna son aiwatar da aiki tare da matsawa ƙasa, to sanya madaidaicin a wuri "Sel tare da canzawa". Bayan haka, danna maɓallin "Ok".



3. Kamar yadda kake gani, an ƙara abubuwa zuwa cikin takardar tare da juyawa, wannan shine, daidai kamar yadda muka saita saiti.

Hanyar 3: Jakanni

Hanya mafi sauri don ƙara abubuwa a cikin Excel shine amfani da haɗakar hotkey.

1. Zabi abubuwan da muke so mu saka. Bayan haka mun buga a kan keyboard babban hade da m key Ctrl + Shift + =.



2. Bayan wannan, karamin taga don saka abubuwan da muka riga muka saba dasu zasu bude. A ciki akwai buƙatar saita hanyar farko zuwa dama ko ƙasa kuma danna maɓallin "Ok" kamar yadda muke yi fiye da sau ɗaya a cikin hanyoyin da suka gabata.



3. Bayan haka, za a saka abubuwan da ke cikin takardar, gwargwadon shirye-shiryen farkon waɗanda aka yi a sakin baya na wannan koyarwar.

Darasi: Gyadaje a Excel

Kamar yadda kake gani, akwai manyan hanyoyi guda uku da zaka sanya sel a cikin tebur: ta amfani da mahallin mahallin, maballin kan kintinkiri, da maɓallan zafi. Dangane da aiki, waɗannan hanyoyin daidai suke, don haka lokacin da zaɓa, da farko, an lasafta dacewa da mai amfani. Kodayake, mafi nisa, hanya mafi sauri ita ce amfani da hotkeys. Amma, Abin baƙin ciki, ba duk masu amfani bane sun saba da kasancewa mai kyau na haɗuwa da ƙwaƙwalwar ajiya a ƙwaƙwalwar su. Saboda haka, nesa da kowa wannan hanyar mai sauri zata dace.