Domin yin ayyuka daban-daban akan abubuwan da ke cikin sel na Excel, dole ne a fara zaba. Ga waɗannan dalilai, shirin yana da kayan aiki da dama. Da farko, wannan bambancin ya faru ne saboda gaskiyar cewa akwai buƙatar zaɓar kungiyoyi daban-daban na sel (jeri, layuka, ginshiƙai), da kuma bukatar buƙatar abubuwan da suka dace da wani yanayin. Bari mu gano yadda za mu yi wannan hanya ta hanyoyi daban-daban.
Shirin tsari
A cikin tsari na zaɓin, za ka iya amfani da linzamin kwamfuta da keyboard. Har ila yau akwai hanyoyi inda waɗannan haɗin shigarwa suka haɗu da juna.
Hanyar 1: Single Cell
Domin zaɓar rabuɗɗɗen tantanin halitta, kawai zuga mai siginan kwamfuta a kanta kuma danna maɓallin linzamin hagu. Za'a iya yin wannan zaɓi ta amfani da maɓallin kewayawa akan keyboard. "Down", "Up", "Dama", "Hagu".
Hanyar 2: Zaɓi shafi
Domin yin alama a shafi a kan teburin, kana buƙatar riƙe ƙasa da maɓallin linzamin hagu sa'annan ya motsa daga saman cellular daga cikin shafi zuwa kasa, inda za'a danƙa maɓallin.
Akwai wasu maganin wannan matsalar. Danna maɓallin Canji a kan keyboard kuma danna saman tantanin halitta na shafi. Sa'an nan, ba tare da sakewa da button ba, danna kan kasa. Zaka iya yin ayyuka a cikin tsari na baya.
Bugu da ƙari, don zaɓar ginshiƙai a cikin tebur, zaka iya amfani da algorithm mai biyowa. Zaɓi sel na farko na shafi, saki linzamin kwamfuta kuma danna maɓallin haɗin Ctrl + Shift + Down Arrow. Wannan zai nuna alamar shafi gaba daya har zuwa ƙarshe na abin da bayanai ke kunshe. Wata mahimmancin yanayin yin wannan hanya shine babu kwayoyin kullun a cikin wannan shafi na tebur. A cikin akwati, kawai yankin kafin an fara samfurin ɓoye na farko za a yi alama.
Idan kana buƙatar zaɓar ba kawai shafi na teburin ba, amma dukan shafi na takardar, sa'an nan kuma a wannan yanayin ne kawai ka buƙaci danna maballin hagu na hagu a kan sashin sashin kwance na kwance, inda haruffan Latin haruffa ke nuna sunayen ginshiƙan.
Idan kana buƙatar zaɓar ginshiƙai da yawa na takardar, sannan ka riƙe linzamin kwamfuta tare da hannun hagu wanda aka ajiye tare da bangarori masu dacewa na sashin kulawa.
Akwai madadin bayani. Danna maɓallin Canji da kuma nuna alamar farko a jerin da aka zaɓa. Bayan haka, ba tare da saki maɓallin ba, danna kan ɓangare na ƙarshe na rukunin kulawa a cikin jerin ginshiƙai.
Idan kana buƙatar zaɓar ginshiƙai daban na takardar, sannan ka riƙe maɓallin Ctrl kuma, ba tare da saki shi ba, danna kan bangarori a kan kwance na kwance na kowane shafi da kake so ka yi alama.
Hanyar 3: zaɓi na layi
Lines a cikin Excel suna bambanta da irin wannan ka'ida.
Don zaɓar jere guda ɗaya a teburin, kawai ja mai siginan kwamfuta a kanta tare da maɓallin linzamin kwamfuta da aka ajiye.
Idan teburin babba, yana da sauki don riƙe maɓallin. Canji sannan kuma danna kan farko da na ƙarshe na jere.
Bugu da ƙari, layuka a cikin Tables ana iya alama a cikin hanya kamar yadda ginshiƙai. Danna kan abu na farko a cikin shafi, sa'an nan kuma danna maɓallin haɗin Ctrl + Shift + Dama Dama. Layin yana haskaka zuwa ƙarshen tebur. Amma kuma, abin da ake buƙata a wannan yanayin shi ne samun bayanai a duk sel na layin.
Don zaɓar dukan jere na takardar, danna kan sashen mai dacewa na gwargwadon daidaito, inda aka nuna lamba.
Idan kana buƙatar zaɓin hanyoyi da dama a wannan hanya, to, ja da linzamin kwamfuta tare da hannun hagu wanda aka ajiye a kan rukunin kamfanoni na sashen kulawa.
Hakanan zaka iya riƙe maɓallin Canji kuma danna maɓallin farko da na karshe a cikin sashin kula da kewayon layin da aka zaba.
Idan kana buƙatar zaɓar layi guda, sa'an nan kuma danna kan kowane bangarori a kan rukunin daidaituwa ta tsaye tare da maɓallin da aka riƙe Ctrl.
Hanyar 4: zaɓi na dukan takardar
Akwai hanyoyi guda biyu na wannan hanya don dukan takardar. Na farko daga cikin wadannan shine danna kan maɓallin rectangular dake tsaye a tsinkayar haɗin kai tsaye da kwance. Bayan wannan aikin za a zabi cikakken dukkanin jikin a kan takardar.
Danna haɗin maɓallan zai kai ga wannan sakamako. Ctrl + A. Gaskiya ne, idan a wannan lokaci mai siginan kwamfuta yana cikin kewayon bazawar bayanai ba, alal misali, a tebur, to farko kawai wannan yanki za a haskaka. Sai kawai bayan sake maimaita haɗin za ku iya zaɓar dukan takardar.
Hanyar Hanya 5: Ginin Yanki
Yanzu mun gano yadda za a zaɓa nau'in jeri na sel a kan takardar. Don yin wannan, ya isa ya kirkiri mai siginan kwamfuta tare da maɓallin linzamin hagu ya ajiye wani yanki a kan takardar.
Zaka iya zaɓar iyakar ta riƙe da maballin. Canji a kan keyboard kuma danna danna a kan hagu na hagu da ƙananan ƙananan yankin da aka zaba. Ko kuma ta hanyar yin aiki a cikin sake tsari: danna kan hagu na sama da hagu na dama na tsararren. Tsarin tsakanin waɗannan abubuwa za a haskaka.
Haka kuma akwai yiwuwar rabu da ɓangarorin da aka warwatse ko jeri. Don yin wannan, a kowane ɗayan hanyoyin da aka sama, kana buƙatar zaɓar daban-daban kowane yanki wanda mai amfani yana so ya tsara, amma maɓallin dole ne a danna. Ctrl.
Hanyar 6: amfani da hotkeys
Za ka iya zaɓar yankuna ta hanyar amfani da hotkeys:
- Ctrl + Home - zaɓi na farkon tantanin halitta tare da bayanai;
- Ctrl + Ƙarshen - zaɓi na karshe cell tare da bayanai;
- Ctrl + Shift + End - zaɓi na sel zuwa ga ƙarshe da ake amfani dasu;
- Ctrl + Shift + Home - zaɓi na sel har zuwa farkon takardar.
Waɗannan zaɓuɓɓuka za su taimaka wajen ajiye lokaci a kan yin ayyukan.
Darasi: Hotunan Hot a Excel
Kamar yadda kake gani, akwai babban adadin zaɓuɓɓuka don zaɓar sel da ƙungiyoyi daban-daban ta yin amfani da keyboard ko linzamin kwamfuta, kazalika da amfani da haɗin waɗannan na'urorin biyu. Kowane mai amfani zai iya zaɓar hanyar zabin da ya fi dacewa da kansa a cikin wani yanayi, tun da yake ya fi dacewa don zaɓar ɗayan ko fiye da yawa a cikin hanya ɗaya, kuma zaɓi hanyar ɗaya ko dukan takardar a wani.
