Contents
A cikin wannan labarin, za ku koyi hanyoyi 2 mafi sauri don saka tsari iri ɗaya ko rubutu a cikin sel da yawa lokaci ɗaya a cikin Excel. Wannan yana da amfani a cikin yanayi inda kake son saka dabara a cikin dukkan sel a cikin ginshiƙi, ko cika duk sel marasa komai da ƙima ɗaya (misali, “N/A”). Dukansu fasahohin suna aiki a cikin Microsoft Excel 2013, 2010, 2007 da baya.
Sanin waɗannan dabaru masu sauƙi zai cece ku lokaci mai yawa don ƙarin ayyuka masu ban sha'awa.
Zaɓi duk sel waɗanda kuke son saka bayanai iri ɗaya a cikinsu
Anan akwai mafi sauri hanyoyin don haskaka sel:
Zaɓi gaba ɗaya shafi
- Idan bayanan da ke cikin Excel an tsara su azaman cikakken tebur, kawai danna kowane tantanin halitta na ginshiƙin da ake so kuma danna Ctrl+Space.
lura: Lokacin da ka zaɓi kowane tantanin halitta a cikin cikakken tebur, ƙungiyar shafuka suna bayyana akan Menu Ribbon Yi aiki tare da tebur (Kayan Tebu).
- Idan wannan kewayon al'ada ne, watau lokacin da aka zaɓi ɗayan sel na wannan kewayon, ƙungiyar shafuka Yi aiki tare da tebur (Table Tools) ba ya bayyana, yi waɗannan:
lura: Abin baƙin ciki, a cikin yanayin yanayi mai sauƙi, latsawa Ctrl+Space zai zaɓi duk sel na shafi a cikin takardar, misali daga C1 to C1048576, ko da an ƙunshi bayanai ne kawai a cikin sel ku: ku1.
Zaɓi tantanin halitta na farko na ginshiƙi (ko na biyu, idan tantanin halitta na farko yana shagaltar da taken), sannan danna Shift+Ctrl+Enddon zaɓar duk sel ɗin tebur har zuwa dama mai nisa. Na gaba, rike Motsi, danna maɓallin sau da yawa hagu na haguhar sai an zaɓi ginshiƙin da ake so kawai.
Wannan ita ce hanya mafi sauri don zaɓar duk sel a cikin ginshiƙi, musamman lokacin da bayanan ke shiga tare da sel maras komai.
Zaɓi layin gaba ɗaya
- Idan bayanan da ke cikin Excel an tsara su azaman tebur mai cikakken aiki, kawai danna kowane tantanin halitta na layin da ake so kuma danna. Shift+Space.
- Idan kana da kewayon bayanai na yau da kullun a gabanka, danna tantanin halitta na ƙarshe na layin da ake so kuma danna Shift+Gida. Excel zai zaɓi kewayon farawa daga tantanin halitta da ka ayyana har zuwa shafi А. Idan bayanan da ake so ya fara, misali, tare da ginshiƙi B or C, tsunkule Motsi kuma danna maɓallin Dama ta hannun damahar sai kun sami sakamakon da ake so.
Zaɓin sel masu yawa
riƙe Ctrl sannan ka danna maballin linzamin kwamfuta na hagu akan dukkan kwayoyin halitta da ke bukatar cike da bayanai.
Zaɓi teburin duka
Danna kowane tantanin halitta a cikin tebur kuma latsa Ctrl + A.
Zaɓi duk sel akan takarda
latsa Ctrl + A sau daya zuwa uku. Da farko danna Ctrl + A yana haskaka yankin na yanzu. Danna na biyu, ban da yankin na yanzu, yana zaɓar layuka tare da kai da jimloli (misali, a cikin cikakkun teburi). Latsa na uku yana zaɓar dukan takardar. Ina tsammanin kun yi hasashe, a wasu yanayi zai ɗauki dannawa ɗaya kawai don zaɓar dukan takardar, kuma a wasu yanayi zai ɗauki kusan dannawa uku.
Zaɓi sel mara komai a cikin wani yanki da aka bayar (a cikin jere, a cikin ginshiƙi, a cikin tebur)
Zaɓi wurin da ake so (duba hoton da ke ƙasa), misali, gabaɗayan ginshiƙi.
latsa F5 kuma a cikin maganganun da ke bayyana Sauyin yanayi (Je zuwa) danna maɓallin haskaka (Na musamman).
A cikin akwatin maganganu Zaɓi ƙungiyar sel (Je zuwa na musamman) duba akwatin Kwayoyin fanko (Blanks) da kuma durƙusa OK.
Za ku koma yanayin gyare-gyare na takardar Excel kuma za ku ga cewa sel marasa komai ne kawai aka zaɓa a cikin yankin da aka zaɓa. Kwayoyin fanko guda uku sun fi sauƙi don zaɓar tare da danna linzamin kwamfuta mai sauƙi - za ku ce kuma za ku yi daidai. Amma idan akwai sel sama da 300 marasa komai kuma an warwatse bazuwar akan kewayon sel 10000 fa?
Hanya mafi sauri don saka dabara a cikin duk sel na ginshiƙi
Akwai babban teburi, kuma kuna buƙatar ƙara sabon shafi tare da wasu dabara a ciki. A ce wannan jerin adiresoshin Intanet ne waɗanda kuke son cire sunayen yanki don ƙarin aiki.
- Maida kewayon zuwa tebur na Excel. Don yin wannan, zaɓi kowane tantanin halitta a cikin kewayon bayanai kuma latsa Ctrl + Tdon kawo akwatin maganganu Ƙirƙirar tebur (Ƙirƙiri Tebur). Idan bayanan suna da taken shafi, duba akwatin Teburi mai taken (Table na yana da rubutun kai). Yawancin lokaci Excel yana gane taken ta atomatik, idan hakan bai yi aiki ba, duba akwatin da hannu.
- Ƙara sabon shafi zuwa tebur. Tare da tebur, wannan aiki ya fi sauƙi fiye da sauƙi na bayanai. Danna dama akan kowane tantanin halitta a cikin ginshiƙi da ke zuwa bayan inda kake son saka sabon shafi, kuma daga menu na mahallin zaɓi. Saka > Rukunin hagu (Saka> Rukunin Tebu zuwa Hagu).
- Ba da suna ga sabon shafi.
- Shigar da dabara a cikin tantanin halitta na farko na sabon shafi. A cikin misali na, Ina amfani da dabara don cire sunayen yanki:
=MID(C2,FIND(":",C2,"4")+3,FIND("/",C2,9)-FIND(":",C2,"4")-3)=ПСТР(C2;НАЙТИ(":";C2;"4")+3;НАЙТИ("/";C2;9)-НАЙТИ(":";C2;"4")-3) - latsa Shigar. Voila! Excel ta atomatik ya cika dukkan sel marasa komai a cikin sabon shafi tare da tsari iri ɗaya.
Idan ka yanke shawarar komawa daga tebur zuwa tsarin kewayon da aka saba, sannan zaɓi kowane tantanin halitta a cikin tebur da kan shafin Constructor (Design) danna Maida zuwa kewayo (Maida zuwa kewayo).
Za a iya amfani da wannan dabara kawai lokacin da duk sel a cikin ginshiƙi ba su da komai, don haka yana da kyau a ƙara sabon shafi. Na gaba ya fi kowa yawa.
Manna wannan bayanai a cikin sel da yawa ta amfani da Ctrl + Shigar
Zaɓi sel akan takardar Excel waɗanda kuke son cika da bayanai iri ɗaya. Dabarun da aka bayyana a sama zasu taimaka maka da sauri zabar sel.
A ce muna da tebur tare da jerin abokan ciniki (za mu, ba shakka, dauki jerin almara). Ɗaya daga cikin ginshiƙan wannan tebur ya ƙunshi shafukan da abokan cinikinmu suka fito. Waɗanda ba kowa a cikin wannan ginshiƙi dole ne a cika su da rubutun "_unknown_" don sauƙaƙe rarrabuwa:
- Zaɓi duk sel mara komai a cikin ginshiƙi.
- latsa F2don gyara tantanin halitta mai aiki, da shigar da wani abu a ciki: yana iya zama rubutu, lamba, ko tsari. A cikin yanayinmu, wannan shine rubutun "_unknown_".
- Yanzu maimakon Shigar click Ctrl + Shigar. Duk sel da aka zaɓa za a cika su da bayanan da aka shigar.
Idan kun san wasu dabarun shigar da bayanai cikin sauri, gaya mana game da su a cikin sharhi. Zan ƙara su cikin wannan labarin da farin ciki, in faɗi ku a matsayin marubucin.