Yadda ake Daskare layuka a cikin Excel
Excel kayan aiki ne mai ƙarfi wanda ke ba da ayyuka da dama da yawa don nazari da tsara bayanai. Ɗaya daga cikin abubuwan da ke da amfani a Excel shine ikon daskare layuka, wanda ke ba ka damar ganin wasu layuka yayin da kake gungurawa cikin sauran maƙunsar bayanai. kiyaye wasu bayanai a bayyane a kowane lokaci.
Ikon daskare layuka a cikin Excel Yana cikin shafin "View" na ribbon. Ta danna kan wannan shafin, za a nuna menu tare da zaɓuɓɓukan nuni daban-daban. Zaɓin "Freeze panels" shine abin da ke ba mu damar daskare layuka. Don amfani da wannan aikin, kawai mu zaɓi layin da muke so mu daskare kuma danna kan zaɓin da ya dace.
Da zarar mun zabi layin da muke so mu daskare, Excel zai raba ma'auni zuwa kashi biyu: wani bangare na sama wanda zai tsaya a tsaye da kuma karamin sashi wanda zai motsa yayin da muke kewaya cikin takardar. komai nawa muka gungura sauran takardar.
Yayin da muke matsar da siginan kwamfuta ƙasa, layuka da ke gaban layin da aka daskare za su ɓoye, amma har yanzu muna iya ganin daskararrun jeri a saman. daga allon. Wannan yana da amfani musamman lokacin da muke buƙatar ci gaba da yin la'akari da layin taken ko mahimman bayanai.
A takaice, aikin na daskare layuka a cikin Excel Kayan aiki ne mai mahimmanci wanda ke ba ka damar adana wasu bayanai koyaushe a bayyane yayin gungurawa cikin manyan bayanan bayanai Yana da sauƙin amfani kuma yana cikin shafin Duba na kintinkiri. Wannan fasalin zai iya zama da amfani musamman ga waɗanda ke buƙatar yin la'akari da layukan kai ko da yaushe ko mahimman bayanai, haɓaka aiki da tsari. a wurin aiki tare da maƙunsar rubutu.
1. Gabatarwa zuwa Row Freezing a cikin Excel
Daskarewa layuka a cikin Excel siffa ce mai fa'ida wacce zata baka damar gyara wasu layuka a cikin ma'auni yayin da kake gungurawa cikin sauran shafin. Wannan yana da amfani musamman lokacin aiki tare da dogon maƙunsar rubutu ko yin nazarin bayanai. "
Don sanya layuka a cikin Excel, kawai zaɓi layin da kuke son sakawa sannan ku je shafin "View" a cikin kayan aiki. A can za ku sami zaɓi "Daskare panels". Ta zaɓar wannan zaɓi, Excel zai liƙa layin da aka zaɓa zuwa sama kuma zaku iya gungurawa cikin sauran takaddun kyauta ba tare da rasa wannan muhimmin bayanin ba.
Wata hanyar daskare layuka a cikin Excel ita ce ta amfani da maɓallin daskare da sauri, wanda ke gefen dama. daga mashaya ƙaura a tsaye. Lokacin da ka danna wannan maɓallin, Excel zai daskare layuka kafin tantanin halitta mai aiki a saman allon. Wannan yana da amfani sosai lokacin da kake da maƙunsar rubutu mai layuka da yawa kuma kana son kiyaye mahimman bayanai a bayyane yayin gungurawa cikin sauran bayanan.
Baya ga daskarewar layuka, Hakanan yana yiwuwa a daskare ginshiƙai a cikin Excel. Wannan tsari yana kama da layuka masu daskarewa kuma yana iya zama da amfani lokacin da kuke aiki tare da maƙunsar rubutu tare da ginshiƙai da yawa kuma kuna son kiyaye bayanan a cikin ginshiƙan farko a bayyane yayin gungurawa a kwance ta sauran ginshiƙan. Ana yin ginshiƙan daskarewa kamar yadda ake yin layuka masu daskarewa, kawai ku zaɓi ginshiƙin da kuke son gyarawa maimakon jere.
The immobilization na darajoji da ginshikan a cikin Excel kayan aiki ne wanda zai taimaka muku inganta aikin ku da kuma ci gaba da lura da mahimman bayanai a cikin maƙunsar bayanai. Ko kuna aiki akan rahoton kuɗi, nazarin bayanai, ko kowane ɗawainiya wanda ya ƙunshi manyan maƙunsar rubutu, fasalin daskarewar layi da ginshiƙi zai zama hanya mai kima don haɓaka aikinku da haɓakar ku.
2. Yadda ake saita daskarewa a cikin Excel
Aikin immobilization na layuka a cikin Excel yana da matukar amfani yayin aiki tare da manyan maƙunsar rubutu. Izinin mu anga wasu layuka a saman taga, yana ba da tabbacin cewa za su kasance a bayyane ko da mun gungura ƙasa. Idan kana son koyon yadda ake cin gajiyar wannan aikin, a nan za mu nuna maka mataki-mataki.
1. Zaɓi jere da kake son daskare: Kafin farawa, dole ne ku zaɓi jeren da kuke son ci gaba da gani. Danna lambar jere a gefen hagu na maƙunsar bayanai don zaɓar ta gabaɗaya. Idan kana so ka daskare layuka da yawa, kawai ka riƙe maɓallin "Ctrl" yayin zabar ƙarin layuka.
2. Samun damar zaɓin immobilizationDa zarar kun zaɓi layi ko layuka da kuke son daskarewa, je zuwa shafin View akan ribbon sannan ku danna Freeze Panels. jere da shafi.
3. Tabbatar cewa an yi amfani da rashin motsi: Bayan zaɓar zaɓi na daskarewa, zaku lura da layin madaidaiciya mai duhu yana nuna rabuwa tsakanin daskararre jere da sauran maƙunsar bayanai. Bugu da ƙari, zaɓuɓɓukan gungurawa a tsaye da a kwance za su kasance suna aiki, suna ba ku damar kewaya cikin takardar yayin da kuke ajiye layin da aka zaɓa akai-akai. Don kawar da daskare, kawai ku sake zuwa shafin Duba, danna "Daskare panels" kuma zaɓi "Crede panels". "zabi.
Yin amfani da fasalin daskarewar layi a cikin Excel babbar hanya ce don sauƙaƙa karantawa da bincika bayanai masu yawa a cikin maƙunsar rubutu. Yanzu da kuka san matakan da suka wajaba don daidaita shi, zaku sami damar yin aiki da kyau da inganci akan ayyukan ku na Excel.
3. Yin amfani da aikin "Lock Panel" a cikin Excel
Ayyukan "Kulle Panels" a cikin Excel kayan aiki ne mai amfani sosai wanda ke ba da damar daskare layuka da ginshiƙai. a kan takarda Wannan yana da amfani musamman lokacin da muke aiki tare da babban saitin bayanai kuma muna buƙatar samun saurin shiga wasu layuka ko ginshiƙai a kowane lokaci. Tare da wannan fasalin, za mu iya liƙa takamaiman layi ko ginshiƙi domin ya kasance a bayyane yayin da muke gungurawa sauran takardar, yana sauƙaƙa dubawa da tantance bayanan.
Don amfani da fasalin "Kulle Panels" a cikin Excel, kawai zaɓi layi ko shafi da kuke son daskare. Na gaba, je zuwa shafin "View" a cikin kayan aiki kuma danna "Kulle Panel". Za ku ga layi a kwance ko a tsaye da aka ƙara a cikin maƙunsar bayanai, yana nuna cewa an kulle layin da aka zaɓa ko shafi. Yanzu, lokacin da kuka gungura ƙasa ko dama, wannan layi ko ginshiƙi za su kasance a bayyane a sama ko hagu na allon.
Wani zaɓi mai amfani shine ikon daskare fiye da jere ɗaya ko shafi. Don yin wannan, kawai zaɓi layi ko ginshiƙi da kake son daskare tare da layuka ko ginshiƙan sama ko hagu. Sannan, bi matakan da ke sama don kunna aikin "Kulle Panel". Ta wannan hanyar, zaɓaɓɓun layuka ko ginshiƙai da duk waɗanda ke sama ko na hagu za su kasance a bayyane yayin da kake gungurawa cikin maƙunsar bayanai.
Ka tuna cewa zaka iya kashe aikin "Kulle Panel" a kowane lokaci. Kawai je zuwa shafin "Duba" kuma danna "Kulle Panel" sake don cire layin kwance ko a tsaye da kuma dawo da kallon maƙunsar rubutu na yau da kullun. Wannan yana da amfani musamman idan kuna buƙatar yin canje-canje zuwa layuka ko ginshiƙan da kuka daskare. Gwada wannan fasalin kuma zaku gano nawa lokaci da ƙoƙarin da zai iya ceton ku yayin aiki tare da manyan maƙunsar rubutu a cikin Excel.
4. Yadda ake daskare takamaiman layuka a cikin maƙunsar rubutu
Idan kuna neman Excel, kuna kan wurin da ya dace. Wani lokaci, ya zama dole a sami wasu layuka koyaushe a bayyane yayin da kuke gungurawa cikin sauran bayanan. Abin farin ciki, Excel yana ba da fasalin da zai ba ku damar aiwatar da wannan cikin sauƙi da inganci.
Don daskare layuka a cikin Excel, bi waɗannan matakan:
1. Bude Excel spreadsheet ɗinku kuma zaɓi layin da kuke son daskare.
2. Je zuwa shafin "View" a saman kayan aiki na sama.
3. Danna "Daskare Panels" a cikin rukunin "Window".
4. Na gaba, zaɓi "Daskare Top Row" idan kana so ka daskare layin farko, ko "Daskare Layi" idan kana so ka daskare wani takamaiman jere na daban.
Da zarar ka daskare layuka da ake so, za ka iya gungurawa cikin sauran bayanan ba tare da rasa mahimmin bayanan da ka zaɓa ba. Wannan yana da amfani musamman lokacin da kuke aiki tare da manyan saitin bayanai kuma kuna buƙatar samun saurin shiga wasu layukan maɓalli.
Ka tuna cewa zaka iya cire daskarewar layuka ta bin matakan da aka ambata a sama. Kawai zaɓi zaɓi na Un daskare maimakon "Daskare Layi" don dawo da yanayin maƙunsar rubutu na yau da kullun. Muna fatan hakan waɗannan shawarwari sun kasance masu amfani a gare ku kuma kuna iya cin gajiyar wannan aikin Excel don sauƙaƙe aikinku tare da bayanai. Gwada Daskarewa Layukan yau kuma adana lokaci da ƙoƙari akan ayyukan maƙunsar ku!
5. Nasihu don ingantaccen daskarewa na layuka a cikin Excel
Aikin hana layuka A cikin Excel yana da matukar amfani idan kun yi aiki tare da manyan ɗakunan rubutu, kamar yadda yake ba ku damar yin aiki. gyara layuka daya ko da yawa a saman allon yayin da kake gungurawa cikin sauran takardar. Wannan yana da amfani musamman idan kuna da taken ko taken a saman maƙunsar bayanan ku kuma kuna buƙatar yin bitar su akai-akai ba tare da rasa ganinsu ba. Anan zaku sami wasu nasihu don samun ingantaccen daskarewa na layuka a cikin Excel.
Mataki na farko zuwa daskare layuka A cikin Excel shine zaɓin layuka ko layuka waɗanda kuke son ci gaba da gani a saman takaddar ku. Za ka iya yi Yi haka ta danna lambar layin da ke gefen hagu na maƙunsar bayanai don zaɓar jere ɗaya ko ta hanyar jan siginan kwamfuta zuwa ƙasa don zaɓar layuka da yawa da zarar kun zaɓi layuka, je zuwa shafin "Duba". kayan aikin kayan aiki na Excel kuma danna "Daskare" panels.
Idan kuna so hana motsi fiye da ɗaya jere, tabbatar da cewa layin nan da nan sama da layuka da kake son daskarewa an zaɓi shi. Wannan zai tabbatar da cewa an kulle layuka a daidai matsayi. Bugu da ƙari, idan kuna da ginshiƙai masu mahimman bayanai waɗanda kuma kuke son daskare, kuna iya bin matakai iri ɗaya amma zaɓi ginshiƙan maimakon layuka. A wannan yanayin, je zuwa shafin "Duba" kuma danna "Daskare Panels" don gyara ginshiƙan da aka zaɓa a wurin.
6. Magani ga matsalolin gama gari lokacin daskarewa layuka a cikin Excel
Ga waɗanda ke amfani da tsarin maƙunsar bayanai na Excel akai-akai, kuna iya samun kanku kuna buƙatar yin hakan. hana layuka don sauƙaƙe ganin bayanan bayanan. Koyaya, wani lokacin ana iya samun matsalolin gama gari yayin ƙoƙarin yin wannan aikin wanda zai iya zama takaici. Abin farin ciki, akwai mafita da yawa waɗanda zasu iya taimakawa wajen magance waɗannan matsalolin kuma su sauƙaƙe aikin daskarewa layuka.
Matsala ta gama gari wacce za ta iya tasowa lokacin ƙoƙarin daskare layuka a cikin Excel shine cewa zaɓin daskare yana iya kashewa. an kashe. Wannan na iya faruwa idan ba a zaɓi tantanin halitta a cikin layin da kake son daskare ba. Gyaran gaggawa ga wannan matsalar shine tabbatar da cewa an zaɓi tantanin halitta a cikin layin kafin yunƙurin daskare shi. Da zarar an zaɓi tantanin halitta daidai, zaɓin Daskare Layuka yakamata ya kasance don amfani.
Wata matsalar gama gari tare da daskarewa layuka a cikin Excel shine cewa daskararrun layuka na iya motsi ko bace ta hanyar gungurawa ta cikin maƙunsar rubutu. Wannan na iya zama mai ban haushi musamman idan kuna aiki tare da babban maƙunsar rubutu. Domin warware wannan matsalar, yana da mahimmanci don tabbatar da cewa layin daskararre yana samuwa a daidai sashin maƙunsar. Bugu da ƙari, za a iya amfani da zaɓin daskare don haɗa layuka da ginshiƙai, waɗanda za su tabbatar da cewa daskararrun layuka suna kasancewa a wurin koda lokacin gungurawa cikin maƙunsar rubutu.
7. Yadda ake kashe daskarewa a cikin Excel
Daskarewa layuka a cikin Excel siffa ce mai fa'ida wacce ke ba ka damar ganin wasu layuka a bayyane, koda lokacin gungurawa cikin babban maƙunsar rubutu. Koyaya, ana iya samun lokutan da kuke son kashe wannan fasalin. Na gaba, za mu nuna muku yadda ake yi.
1. Zabin Menu: Hanya mafi sauƙi don kashe daskarewa a layi shine ta amfani da zaɓin menu a cikin Excel. A saman taga, danna "Duba" sannan zaɓi "Daskare Panes." Wannan zaɓin zai nuna muku zaɓuɓɓukan daskarewa daban-daban da ake da su. Idan kuna da daskararren layuka ko ginshiƙai, za ku ga alamar rajistan shiga kusa da zaɓin da ya dace. Kawai danna zaɓi don kashe daskarewar layi.
2. Gajeren hanyar madannai: Idan kun fi son amfani da gajerun hanyoyin keyboard, Excel yana ba ku hanya mai sauri don musaki daskarewa. Kawai ka riƙe maɓallin "Ctrl" kuma, a lokaci guda, danna maɓallin "Shift" da maɓallin "F6". Wannan zai cire duk wani jeri da ka saita a baya a cikin maƙunsar bayanai.
3. Zaɓin gungurawa: Wani lokaci za ka iya so a kashe daskarewar layi na ɗan lokaci yayin da kake lilon maƙunsar rubutu. Don yin wannan, kawai gungura sama ko ƙasa da maƙunsar rubutun har sai layuka masu ƙulla bace daga nunin. Wannan ba zai cire layi na dindindin ba, zai kashe shi na ɗan lokaci na ɗan lokaci har sai kun dawo wurin asali a cikin maƙunsar bayanai.
Ni Sebastián Vidal, injiniyan kwamfuta mai sha'awar fasaha da DIY. Bugu da ƙari, ni ne mahaliccin tecnobits.com, inda nake raba koyaswar don sa fasaha ta fi dacewa da fahimtar kowa ga kowa.