Yadda ake nuna takardar ɓoyayye a cikin Excel

A cikin duniyar ma'auni, Microsoft Excel Ya fito waje azaman kayan aiki mai ƙarfi da ƙarfi. Ɗaya daga cikin abubuwan da ya fi amfani shi ne ikon ɓoye zanen gado don tsarawa da kare bayanai. A cikin wannan labarin fasaha, za mu bincika tsarin ɓoye ɓoye ɓoye a cikin Excel, samarwa mataki-mataki Cikakken umarni. Ko kai mafari ne a cikin Excel ko ƙwararren mai amfani, wannan jagorar za ta taimake ka ka mallaki wannan fasalin kuma ka sami mafi kyawun fa'idar maƙunsar ku.

1. Gabatarwa ga ɓoyewa da nuna zanen gado a cikin Excel

A cikin Excel, zaku iya ɓoye da nuna takaddun aiki don sauƙaƙe hangen nesa na bayanai da tsara abun ciki. daga fayilWannan fasalin yana da amfani musamman lokacin aiki tare da littattafan aikin Excel waɗanda ke ɗauke da zanen gado da yawa. Boye takarda yana sa ba a iya gani, amma har yanzu kuna iya samun dama da aiki tare da abinda ke ciki. Akasin haka, nuna takarda yana sa ta sake gani.

Don ɓoye takarda a cikin Excel, kawai bi waɗannan matakan:

• Zaɓi takardar da kake son ɓoyewa ta danna shafinta a ƙasan taga Excel.
• Danna-dama akan shafin da aka zaɓa kuma zaɓi zaɓin "Boye" daga menu mai saukewa.
• Za a ɓoye takardar da aka zaɓa nan da nan kuma ba za a ƙara gani a cikin taga Excel ba.

Idan kuna buƙatar nuna takaddar ɓoye a cikin Excel, zaku iya yin hakan ta bin waɗannan matakan:

• Je zuwa shafin "Gida" akan ribbon Excel.
• Danna maɓallin "Format" a cikin rukunin "Cells".
• A cikin menu mai saukarwa, zaɓi zaɓin "Sheet Visibility" zaɓi sannan danna kan "Show Sheet".
• Takardar da aka ɓoye za ta sake bayyana a cikin taga Excel.

Boyewa da nuna zanen gado a cikin Excel babban kayan aiki ne don sarrafa nunin bayanai da haɓaka ƙungiyar fayil. Tabbatar tuna matakan da aka ambata a sama don amfani da wannan fasalin. yadda ya kamata a cikin ayyukanku daga Excel.

2. Matakai don buɗe ɓoye ɓoye a cikin Excel

A cikin wannan sakon, za mu ba ku matakan da suka dace don ɓoye ɓoye ɓoye a cikin Excel. Tare da wannan bayanin, zaku sami damar shiga kowane takarda da aka ɓoye a cikin fayil ɗin ku kuma dawo da duk bayanan da kuke buƙata.

1. Buɗe Fayil ɗin Excel wanda ya ƙunshi ɓoyayyun takardar da kuke son ɓoyewa.

2. Danna-dama akan kowane shafin shafi a kasan tagan Excel.

3. A cikin menu mai saukewa, zaɓi "Unhide" don nuna ɓoyayyun zanen gado.

4. Akwatin maganganu zai bayyana yana nuna duk ɓoyayyun zanen gado a cikin fayil ɗin. Zaɓi takardar da kake son cirewa kuma danna "Ok".

Kuma shi ke nan! Yanzu takardar da kuka zaɓa za ta kasance a bayyane kuma za ku iya shiga cikin abubuwan da ke ciki ba tare da wata matsala ba.

3. Zaɓuɓɓuka masu tasowa don nuna ɓoyayyun zanen gado a cikin Excel

Lokacin amfani da Microsoft Excel, zaku iya samun kanku kuna buƙatar nuna ɓoyayyun zanen gado a cikin littafin aikinku. Abin farin ciki, akwai zaɓuɓɓukan ci-gaba da yawa da za ku iya amfani da su don cim ma wannan yadda ya kamata. A ƙasa, za mu gabatar da wasu daga cikin waɗannan zaɓuɓɓuka:

1. Yi amfani da fasalin jujjuya ganye: Excel yana da fasalin jujjuya takarda wanda zai baka damar nunawa da sauri ko ɓoye zanen gado. Kuna iya samun damar wannan fasalin ta hanyar danna kowane shafi na dama a kasan tagan Excel kuma zaɓi "Nuna" ko "Boye." Wannan yana ba ku dama mai sauri don sarrafa ɓoyayyun zanen gado.
2. Yi amfani da shafin "View" akan ribbon: Wata hanyar nuna ɓoyayyun zanen gado ita ce amfani da shafin "View" akan ribbon na Excel. A cikin wannan shafin, zaku sami sashin da ake kira "Windows" wanda ya ƙunshi kayan aiki masu amfani da yawa. Misali, zaku iya danna "Canja Window" don ganin jerin duk zanen gadon da ke cikin littafin aikinku, gami da na boye. Kawai zaɓi takardar da kake son nunawa kuma danna "Ok."
3. Yi amfani da taskbar de Excel: Baya ga zaɓuɓɓukan da ke sama, Excel kuma yana ba da kayan aiki mai amfani wanda zai ba ku damar shiga ɓoye bayanan cikin sauri. Don samun dama ga wannan kayan aiki, danna-dama a ko'ina a cikin mashigin taken Excel kuma zaɓi "Sheets." Jerin duk zanen gado a cikin littafin aikinku zai bayyana, gami da na ɓoye. Danna takardar da kake son nunawa, kuma za ta buɗe ta atomatik a cikin sabuwar taga Excel.

Waɗannan kaɗan ne daga cikin manyan zaɓuɓɓukan da Excel ke bayarwa don nuna ɓoyayyun zanen gado. Ta amfani da waɗannan kayan aikin, zaku iya sarrafa zanen gadonku cikin sauƙi da samun damar bayanan da kuke buƙata a cikin littafin aikinku. Idan kun fi son koyo ta hanyar cikakken koyawa, za ku iya samun albarkatun kan layi da yawa waɗanda za su jagorance ku mataki-mataki ta wannan tsari. Jin kyauta don bincika duk waɗannan zaɓuɓɓuka kuma gano wanda ya fi dacewa da ku!

4. Yin amfani da zaɓin kariyar takarda a cikin Excel

A wasu yanayi, ƙila za ku buƙaci ba da kariya ga takaddun aikin Excel don gyara ko gyara wasu bayanai. Abin farin ciki, Excel yana ba da hanya mai sauƙi don yin wannan. Ga yadda:

1. Bude fayil ɗin Excel wanda ke ƙunshe da zanen gadon da kuke son hanawa.
2. Danna "Review" tab a ciki kayan aikin kayan aiki daga Excel.
3. A cikin rukunin "Change" akan shafin "Review", nemo kuma danna maballin "Unprotect Sheet". Wannan zai buɗe akwatin maganganu na "Unprotect Sheet".

Da zarar kun bi waɗannan matakan, zaɓaɓɓun zanen gado ba za su kasance masu kariya ba kuma kuna iya yin canje-canje a kansu. Ka tuna cewa yana da mahimmanci don kiyaye bayananku amintacce kuma ku sake kare zanen gado da zarar kun gama yin canje-canjenku.

5. Yadda ake dawo da takarda da aka goge ba da gangan ba a cikin Excel

Mayar da takardar da aka goge bisa kuskure a cikin Excel na iya zama abin takaici, amma an yi sa'a, akwai hanyoyi da yawa don gyara shi. A ƙasa, za mu samar da wani sauki mataki-by-mataki jagora don taimaka maka mai da your data ba tare da wata matsala.

1. Da farko, bude Excel kuma je zuwa kasan taga, inda zaku sami tabs. Danna-dama akan kowane shafin kuma zaɓi "Maida Deleted Sheet." Wannan zai buɗe akwatin maganganu na "Maida Sheets" inda za ku iya ganin duk takardun da aka goge.

2. A cikin akwatin maganganu "Mai da Sheets", zaɓi takardar da kake son warkewa kuma danna maɓallin "Ok". Za a dawo da takardar da aka goge kuma za ta sake bayyana a kasan tagan Excel, tare da sauran takaddun aiki.

6. Dabaru don ganowa da nuna duk ɓoyayyun zanen gado a cikin Excel

Ganewa da nuna duk takaddun aiki na ɓoye a cikin Excel na iya zama ƙalubale, amma tare da ƴan dabaru da dabaru, zaku iya magance wannan matsalar cikin sauri. Anan akwai wasu dabaru don taimaka muku ganowa da nuna ɓoyayyun takaddun aiki a cikin Excel:

1. Yi amfani da aikin daftarin aiki: Wannan fasalin yana ba ku damar gano duk takaddun aikin da aka ɓoye a cikin takaddar Excel. Don samun damar wannan fasalin, je zuwa shafin "Bita" a kan kayan aiki kuma danna "Duba Takardu." Da zarar ka danna wannan zaɓi, Excel zai bincika kuma ya nuna duk takaddun aikin da aka ɓoye a cikin takaddun ku.

2. Yi amfani da kwamitin kewayawa: Fannin Kewayawa kayan aiki ne mai amfani wanda zai baka damar kewayawa da sarrafa duk zanen gadon da ke cikin takaddar Excel. Don buɗe Fannin Kewayawa, je zuwa shafin "View" a kan kayan aiki kuma danna "Pane Kewayawa." Sannan, yi amfani da zaɓuɓɓukan da ke akwai a cikin Maɓallin Kewayawa don ganowa da nuna ɓoyayyun zanen gado a cikin takaddar ku.

3. Yi amfani da kayan aikin "Edit Objects": Wata hanya don ganowa da nuna ɓoyayyun takardun aiki a cikin Excel ita ce ta amfani da kayan aiki na "Edit Objects". Don samun dama ga wannan kayan aiki, je zuwa shafin "Gida" kuma danna "Find & Select." Sannan, zaɓi "Edit Objects" daga menu mai saukewa. Yi amfani da zaɓuɓɓukan da ke akwai akan wannan kayan aiki don ganowa da nuna ɓoyayyun takaddun aiki a cikin takaddar ku.

7. Yadda ake nuna takamaiman takaddar ɓoye a cikin Excel

Ɗaya daga cikin fasalulluka masu amfani na Excel shine ikon ɓoye zanen gado a cikin littafin aiki. Koyaya, wani lokacin kuna buƙatar nuna takamaiman takardar da aka ɓoye. Abin farin ciki, Excel yana ba da hanya mai sauƙi don yin wannan, kuma an bayyana matakan da ke ƙasa.

1. Bude littafin aiki a cikin Excel kuma je zuwa shafin "Gida" akan kintinkiri.

2. Danna-dama akan kowane shafin da ake iya gani a kasan tagan Excel. Menu na mahallin zai bayyana sannan.

3. A cikin mahallin menu, zaɓi zaɓin "Nuna" sannan danna "Show Hidden Sheet." Akwatin maganganu zai buɗe yana nuna jerin duk ɓoyayyun zanen gado a cikin littafin aiki.

A taƙaice, don nuna takamaiman takaddar ɓoye a cikin Excel, kuna buƙatar samun dama ga akwatin maganganu "Nuna Hidden Sheet" ta hanyar mahallin mahallin shafuka na bayyane. Daga nan, za ku iya zaɓar ɓoyayyen takardar da kuke so kuma danna "Ok" don nuna shi. Wannan tsari yana da sauri da sauƙi kuma yana iya zama da amfani lokacin da kuke buƙatar samun damar ɓoye bayanan cikin sauri cikin maƙunsar rubutu.

8. Nuna mahara boye zanen gado a cikin Excel lokaci guda

Wani lokaci, yana iya zama taimako don nuna ɓoyayyun takardun aiki a cikin Excel lokaci ɗaya maimakon danna kowane shafin don duba abubuwan da ke ciki. Abin farin ciki, Excel yana ba da hanya mai sauƙi don yin hakan ba tare da an cire kowane takardar aiki da hannu ba.

Don nuna ɓoyayyun zanen gado a cikin Excel, na farko dole ne ka zaɓa Don nuna duk zanen gadon da kuke so a lokaci ɗaya, riƙe maɓallin Ctrl kuma danna maballin ɓoyayyun zanen gado. Da zarar kun zaɓi duk zanen gado, danna-dama akan kowane ɗayan da aka zaɓa kuma zaɓi "Nuna" daga menu mai saukewa.

Wata hanya don nuna ɓoyayyun zanen gado da yawa ita ce amfani da gajeriyar hanyar madannai. Bayan zaɓar duk ɓoye bayanan da kuke son nunawa, kawai danna Ctrl + Shift + 9 a lokaci guda. Wannan zai nuna nan take duk zaɓaɓɓun zanen gado. Ka tuna cewa wannan gajeriyar hanyar madannai tana aiki ne kawai idan duk zanen gadon da aka zaɓa suna ci gaba. Idan akwai zanen gadon da ba na gaba ba da kuke son nunawa, dole ne kuyi amfani da hanyar da ta gabata.

9. Yadda ake tsarawa da sake suna boye zanen gado a cikin Excel

Tsara da sake suna ɓoyayyun zanen gado a cikin Excel na iya zama da amfani sosai don tsara fayilolinku da samun bayanai cikin sauri da sauƙi. Abin farin ciki, Excel yana ba da zaɓuɓɓuka da yawa don cika wannan aikin. yadda ya kamata. A continuación, te mostraremos cómo hacerlo paso a paso.

1. Don tsara takaddun ɓoye, abu na farko da yakamata ku yi shine zaɓi shafin "Sheets" a cikin hagu na hagu na taga Excel. Menu mai saukewa zai bayyana tare da duk zanen gado a cikin littafin aiki. (Bayyana)

2. Danna-dama akan takardar da kake son sake suna kuma zaɓi "Sake suna" daga menu mai saukewa. Za a buɗe taga pop-up inda za ku iya shigar da sabon sunan takardar. Tabbatar zabar suna mai siffatawa wanda zai taimaka maka gano abubuwan cikin takardar da sauri. (Bayyana)

3. Don ɓoye takarda a cikin Excel, kawai danna dama akan takardar da kake son ɓoyewa sannan ka zaɓi zaɓin "Hide" daga menu mai saukarwa. Za a ɓoye takardar nan take, amma har yanzu za a samu don amfani a cikin littafin aiki. Don nuna takaddar ɓoye, kawai maimaita tsari iri ɗaya kuma zaɓi zaɓin "Nuna" maimakon "Boye." (Bayyana)

10. Matsalolin warware matsalar yayin nuna ɓoyayyun zanen gado a cikin Excel

Akwai matsalolin gama gari da yawa yayin ƙoƙarin nuna ɓoyayyun zanen gado a cikin Excel, amma an yi sa'a, akwai mafita masu sauƙi. Ga wasu hanyoyin magance waɗannan matsalolin:

1. Tabbatar da ɓoyayyun saitunan takardar: Za a iya ɓoye takaddun saboda saitin da ba daidai ba. Don bincika, je zuwa shafin "Gida" a cikin Excel kuma danna maɓallin "Format" a cikin rukunin "Cells". Sa'an nan, zaɓi "Sheet" sa'an nan kuma "Unboye Sheet." Idan zaɓin Unhide Sheet ɗin ya ƙare, kunna shi kawai, kuma ya kamata a sake ganin zanen gadon ɓoye.

2. Yi amfani da gajerun hanyoyin madannai: Wata hanyar nuna ɓoyayyun zanen gado a cikin Excel ita ce amfani da gajerun hanyoyin keyboard. Kawai danna "Ctrl + Shift + "9" kuma za a nuna ɓoyayyun zanen gado. Idan kuna da ɓoyayyun zanen gado da yawa, zaku iya amfani da "Ctrl + "Shift + Hagu / Dama" don canzawa tsakanin su.

3. Yi amfani da aikin "Nuna duk": Idan babu ɗayan mafita na sama da ke aiki, zaku iya gwada amfani da aikin "Show All". Je zuwa shafin "Bita" a cikin Excel kuma danna "Nuna Duk" a cikin rukunin "Change". Wannan zai nuna duk ɓoyayyun zanen gado a cikin fayil ɗin ku.

11. La'akari da tsaro lokacin nuna ɓoye ɓoye a cikin Excel

12. Yadda ake nuna takardar da aka kare a baya a cikin Excel

Lokacin aiki tare da kariyar takaddun aikin Excel, akwai iya zuwa lokacin da muke buƙatar nuna abubuwan da ke cikin su ba tare da kare su gaba ɗaya ba. Wannan yana da amfani musamman lokacin da muke son gabatar da bayanan daga takarda mai kariya ga abokin ciniki ko mai haɗin gwiwa ba tare da ƙyale su yin canje-canje ba. Abin farin ciki, Excel yana ba da hanya mai sauƙi don nuna takardar da aka kare a baya ba tare da buɗe kariyar ba.

Don nuna takardar da aka kare a baya a cikin Excel, bi waɗannan matakan:

1. Bude fayil ɗin Excel wanda ke ƙunshe da takaddun kariya.
2. Danna kan shafin "Review" a cikin kayan aiki na Excel.
3. A cikin rukunin "Canje-canje", danna kan "Ba a tsare Sheet".
4. Idan an nemi kalmar sirri, shigar da kalmar sirri da kuka yi amfani da ita don kare takardar.
5. Da zarar takardar ba ta da kariya, zaɓi abun ciki da kake son nunawa.
6. Danna-dama zaɓi kuma zaɓi "Copy" daga menu mai saukewa.
7. Bude sabon takarda a cikin littafin aikin Excel iri ɗaya kuma danna dama akan cell A1. Sa'an nan, zaži "Paste" daga drop-saukar menu.

Ta bin waɗannan matakan, zaku iya nuna abubuwan da ke cikin takardar Excel da aka kiyaye a baya ba tare da cire duk kariya ba. Wannan yana ba ku damar gabatar da bayanai. lafiya da hana duk wani gyare-gyare na bazata ta wasu mutane. Ka tuna cewa da zarar ka gama nuna takardar, za ka iya sake kare ta ta hanyar bin matakai iri ɗaya kuma zaɓi "Sheet ɗin Kariya" maimakon "Sheet ɗin Mara Kariya".

13. Kayan aiki masu amfani don nunawa da sarrafa bayanan ɓoye a cikin Excel

Fayil ɗin aiki na ɓoye a cikin Excel na iya zama tushen rudani da wahala lokacin aiki tare da manyan fayiloli. Abin farin ciki, akwai kayan aiki iri-iri masu amfani waɗanda ke sauƙaƙa nunawa da sarrafa waɗannan ɓoyayyun takaddun aiki yadda ya kamata. Ga wasu zaɓuɓɓukan da za su taimaka muku magance wannan matsalar:

1. Cire ganyeDon nuna ɓoyayyun zanen gado a cikin Excel, kuna iya bin waɗannan matakan: danna-dama akan kowane shafin da ake iya gani a kasan allon, sannan zaɓi zaɓin "Unhide" daga menu mai saukarwa. Kuna iya maimaita wannan tsari don kowane takardar da kuke son ɓoyewa.

2. Gajerun hanyoyin madannaiHakanan Excel yana ba da gajerun hanyoyin keyboard masu amfani don nunawa da ɓoye zanen gado. Don nuna ɓoyayyen takarda, zaku iya amfani da haɗin maɓalli "Ctrl + Shift + 9". Akasin haka, don ɓoye takardar da ake iya gani, zaku iya danna "Ctrl + Shift + 0".

3. Yi amfani da aikin "Format Cell".Wani zaɓi shine yin amfani da aikin "Format Cells" a cikin Excel. Zaɓi takaddun ɓoye da kuke son nunawa, sannan ku je shafin "Gida" akan kayan aiki kuma danna "Format Cells." A cikin taga da ya bayyana, je zuwa shafin "Kariya" kuma cire alamar "Hidden" akwatin. Wannan zai sake sa takardar ɓoye ta sake bayyana a cikin littafin aiki.

Waɗannan kayan aikin da dabaru za su ba ka damar nunawa da sarrafa ɓoyayyun takaddun aiki a cikin Excel a zahiri da inganci. Komai girman fayil ɗin ko nawa ɓoyayyun takaddun aikin da kuke da su, tare da waɗannan matakan zaku iya samun damar duk bayanan da kuke buƙata cikin sauƙi. Ka tuna don amfani da wannan ilimin kuma sauƙaƙe aikinku tare da Excel!

14. Ƙarshe da shawarwari don nuna ɓoye ɓoye a cikin Excel

A taƙaice, akwai hanyoyi da yawa don nuna ɓoyayyun zanen gado a cikin Excel. Da farko, zaku iya amfani da hanyar gargajiya ta danna dama akan shafin da ake iya gani a kasan allon kuma zaɓi "Cre ɓoye" daga menu mai buɗewa. Wannan zai nuna duk bayanan ɓoye a cikin fayil ɗin Excel.

Wani zaɓi shine a yi amfani da gajeriyar hanya Ctrl madannai Latsa Shift + 9 don nuna duk ɓoyayyun zanen gado lokaci guda. Wannan hanyar tana da amfani musamman idan kuna da ɓoyayyun zanen gado da yawa waɗanda kuke son nunawa a lokaci guda.

Idan kuna buƙatar nuna takamaiman takarda kuma ba duk takaddun ɓoye ba, zaku iya amfani da Task Pane a cikin Excel. Don buɗe Task Pane, je zuwa shafin "Duba" akan kayan aiki kuma zaɓi "Task Pane." Bayan haka, zaɓi shafin "Sheet Explorer" a cikin Task Pane kuma duba akwatin kusa da zanen gadon da kuke son nunawa. Danna maɓallin "Nuna" don nuna zaɓaɓɓun zanen gado.

A ƙarshe, nuna ɓoyayyun takaddun aiki a cikin Excel aiki ne mai sauƙi tare da zaɓuɓɓuka da yawa akwai. Kuna iya amfani da hanyar danna dama ta gargajiya, gajeriyar hanyar madannai Ctrl + Shift + 9, ko Task Pane don bayyana ɓoyayyun takaddun aiki. Zaɓi hanyar da ta fi dacewa da bukatunku kuma kuyi aiki da kyau. a cikin fayilolinku daga Excel.

Ka tuna cewa yana da mahimmanci a kiyaye ɓoyayyun zanen gadonka da kyau, musamman idan sun ƙunshi bayanan sirri ko na sirri. Kar ku manta da adana aikinku akai-akai kuma kuyi amfani da kalmomin sirri masu ƙarfi don kare fayil ɗin Excel ɗin ku. Tare da waɗannan shawarwarin, zaku iya nunawa da kuma kare ɓoyayyun zanen gadonku.

A ƙarshe, koyon yadda ake nuna takaddar ɓoye a cikin Excel ƙwarewa ce ta asali ga kowane mai amfani da ke son yin ingantaccen amfani da wannan kayan aiki mai ƙarfi. Ta hanyar cikakkun matakan da aka bayar a cikin wannan labarin, mun bincika zaɓuɓɓuka da hanyoyi daban-daban waɗanda ke ba mu damar nuna ɓoyayyun zanen gado da sauri. Ko ta amfani da menu na zaɓuɓɓuka, shafukan ribbon, ko ɓangaren Dubawa, za mu iya shiga ba tare da wahala ba mu duba ɓoyayyun zanen gado a cikin maƙunsar mu na Excel. Bugu da ƙari kuma, mun tattauna wasu muhimman batutuwa, kamar ba raba fayiloli Tare da bayanan sirri, guje wa ɗaukar matakan da suka dace, kuma ku tuna cewa duk wani canje-canje da kuka yi zuwa takaddar ɓoye za a ganuwa da zarar kun ɓoye shi. Excel yana ba da ayyuka da fasali da yawa, kuma nuna ɓoyayyun zanen gado ɗaya ne daga cikin ƙwararrun ƙwarewa masu yawa da zaku iya samu don haɓaka aikinku tare da maƙunsar rubutu. Don haka ci gaba da bincike da gwaji tare da Excel don samun mafi kyawun wannan kayan aiki kuma ku sauƙaƙe nazarin bayanan ku na yau da kullun da ayyukan gudanarwa. Sa'a mai kyau, kuma jin daɗin komawa zuwa wannan labarin a duk lokacin da kuke buƙatar nuna takaddar ɓoye a cikin Excel!