Wasu lokuta lokacin da buga littafin mai kyau, kwafi na firinta ba kawai shafuna da bayanai ba, har ma babu komai. Wannan na iya faruwa saboda dalilai daban-daban. Misali, idan ka kasance a cikin yankin wannan shafin, ba da gangan sanya kowane hali, har zuwa sarari, za a kama shi don bugawa. A zahiri, ba shi da kyau yana cutar da abin bugawa, kuma yana haifar da asarar lokaci. Bugu da kari, akwai lokuta yayin da baka son buga wani shafin cike da bayanai da kuma son kada su ciyar dashi don bugawa, amma cire. Bari mu kalli zaɓuɓɓuka don share shafi a Excel.
Shafin Share hanya
Kowane takarda mai fice yana sama zuwa shafukan da aka buga. Iyakarsu lokaci guda suna aiki a matsayin iyakokin zanen gado waɗanda za a nuna a kan firintar. Kuna iya duba daidai yadda aka raba takaddun zuwa shafuka, zaku iya zuwa yanayin aikin hannu ko zuwa yanayin Excel add. Sanya shi mai sauki ne.
A gefen dama na kirtani na matsayin, wanda yake a kasan taga Excel, alamu don canza yanayin duba daftarin aiki. Ta hanyar tsoho, an kunna yanayin da aka saba. Gunkin da ya dace da shi, hagu na gumakan uku. Don canjawa zuwa yanayin alamar shafi, danna kan gunkin farko zuwa dama na gunkin da aka ƙayyade.
Bayan haka, an kunna yanayin fasalin shafin. Kamar yadda kake gani, duk shafuka sun rabu da sarari mara komai. Don zuwa yanayin shafin, danna kan maɓallin dama a jere na gumakan da ke sama.
Kamar yadda kake gani, a cikin yanayin shafi, ba kawai shafukan da kansu ke bayyane ba, iyakokin da aka yiwa layin da aka nuna, amma kuma lambobin su.
Hakanan, canzawa tsakanin nau'ikan kallo a cikin Freel za'a iya yin ta zuwa shafin "kallo". A can, a kan tef a cikin zamani na zamani "Toshe, yanayin juyawa da ke dacewa da gumakan kan matsayin kwamitin zai kasance.
Idan lokacin amfani da yanayin shafi ya ƙidaya kewayon kewayon da a gani da ba a bayyana komai ba, to, za a sake ba komai a buga. Ya ƙare, yana yiwuwa ne ta hanyar saita buga shafi da bai ƙunshi abubuwa ba komai, amma ya fi kyau a cire waɗannan abubuwan da ba dole ba. Don haka ba lallai ne ku yi ƙarin ayyukan ba yayin bugawa. Bugu da kari, mai amfani na iya mantawa kawai don samar da saitunan da suka wajaba, wanda zai haifar da sabon zanen gado.
Bugu da kari, akwai abubuwa fanko a cikin takaddar, zaku iya gano ta hanyar filin samfoti. Don isa zuwa can don matsawa zuwa shafin "fayil". Bayan haka, je zuwa sashin "Buga". A cikin matsanancin dama na bude taga, yankin na samfotin takaddar za a samo. Idan ka gungurawa cikin sandar gungurawa kafin kasan da ganowa a cikin taga preview, cewa babu wani bayani game da wasu shafuka ko kaɗan, yana nufin cewa za a buga su a cikin zanen gado.
Yanzu bari mu fahimci waɗanne hanyoyi da zaku iya share shafuka ba komai daga cikin takaddun, idan Gano, lokacin aiwatar da ayyukan da ke sama.
Hanyar 1: Dalilin Buga Yankin
Domin kada a yi kama da zanen gado ko marasa amfani, zaku iya sanya yankin ɗab'in. Ka yi la'akari da yadda ake yi.
- Zaɓi kewayon bayanai akan takardar da za a buga.
- Je zuwa "Page Markup", danna maɓallin "Buga na Buga", wanda yake a cikin "Saitin Page". Oan karamin menu yana buɗewa, wanda ya ƙunshi maki biyu kawai. Danna kan abu "saita".
- Mun adana fayil ɗin tare da daidaitaccen hanyar ta danna alamar a cikin diski na kwamfuta a saman kusurwar hagu na taga mai kyau.
Yanzu koyaushe lokacin ƙoƙarin buga wannan fayil, yanki kawai an aika da yankin da aka aiko ku zuwa firintar za a kawo. Don haka, shafukan yanar gizo marasa amfani zasu yanke "yanke" kuma an aiwatar da bullocinsu. Amma wannan hanyar tana da aibi. Idan ka yanke shawarar ƙara bayanai zuwa teburin, dole ne ka canza yankin bugu don buga baya zuwa tebur, tunda za'a aika da shi zuwa filin wasan da ka kayyade a cikin saitunan.
Amma wani yanayi mai yiwuwa ne lokacin da ka ko wani mai amfani ya tambayi yankin bugu, bayan an cire teburin kuma an cire teburin da layuka daga ciki. A wannan yanayin, shafukan ba su da hannu waɗanda aka daidaita a matsayin yanki na ɗab'i zuwa firinta, koda kuwa babu alama a kewayonsu, gami da sarari. Don kawar da wannan matsalar, zai isa kawai don cire yankin ɗab'in.
Domin cire yankin buga da ya ware bayan ba a buƙata. Kawai kaje shafin "Marwa", danna maɓallin "Buga na Buga" a cikin "saitunan shafin" a cikin menu wanda ya bayyana.
Bayan haka, idan babu sarari ko wasu haruffa a cikin sel a waje da tebur, babu komai a cikin tebur.
Darasi: Yadda za a kafa yankin Buga a Excel
Hanyar 2: Share Page
Idan matsalar ita ce ba cewa yankin Buga tare da fannoni ba komai a cikin takaddun, wasu ƙarin haruffa akan takarda, sannan a wannan yanayin, tilasta Dalilin Buga Buga wuri ne kawai mai girma.
Kamar yadda aka ambata a sama, idan teburin yana canzawa koyaushe, mai amfani zai kafa sabbin sigogin bugu kowane lokaci yayin bugawa. A wannan yanayin, wani abu mai ma'ana zai zama cikakkiyar gogewa daga littafin kewayon da ke dauke da sarari marasa amfani ko wasu dabi'u.
- Je zuwa kallon shafin da kowane ɗayan hanyoyin da muka bayyana a baya.
- Bayan ƙayyadadden yanayin yana gudana, ware duk shafukan da ba mu buƙata. Muna yin wannan ta hanyar kewaya su da siginan kwamfuta tare da maɓallin linzamin kwamfuta na hagu.
- Bayan abubuwan da aka fifita su, danna kan maɓallin Share akan keyboard. Kamar yadda kake gani, ana cire duk shafuka duk shafukan da ba dole ba. Yanzu zaku iya zuwa yanayin kallo na yau da kullun.
Babban dalilin kasancewar zanen gado ba fãce yayin bugawa shine shigar da sarari a daya daga cikin sel fannoni. Bugu da kari, dalilin na iya zama yankin da aka buga ba daidai ba. A wannan yanayin, kawai kuna buƙatar soke shi. Hakanan, don magance matsalar buga rubutun fanko ko ba dole ba, zaku iya saita ainihin ɗab'in Buga, amma yana da kyau a yi, kawai cire makada marasa komai.