Yadda ake ɓoye daftarin aiki a cikin Excel. Hanyoyi 2 don ɓoye ƙididdiga a cikin Excel

Ta hanyar tsoho, a cikin takaddar Excel, lokacin da ka danna tantanin halitta a cikin mashaya dabara, dabarar da aka yi amfani da ita a cikin takamaiman tantanin halitta ta bayyana ta atomatik. Wani lokaci yana iya zama dole a ɓoye dabarar da aka yi amfani da ita daga idanu masu zazzagewa. Ayyukan Excel yana sauƙaƙa yin wannan.

Saita nunin dabarar a cikin tebur na Excel

Don dacewa da aiki tare da tebur da gyara abubuwan da ke cikin ƙididdiga, lokacin da ka danna tantanin halitta, cikakken ra'ayi na dabarar da aka nuna a ciki yana bayyana. Ana nuna shi a saman layi kusa da halin "F". Idan babu dabara, to abin da ke cikin tantanin halitta kawai ana kwafi su ne. Wannan ya sa ya dace don gyara tebur, amma ba koyaushe ya zama dole ga sauran masu amfani su iya ganin hanyoyin da aka yi amfani da su ba ko ma samun damar shiga wasu sel. Fasalolin Excel suna ba ku damar ɓoye nunin dabarun kawai, kuma suna sa ya zama ba zai yiwu ba ga kowane hulɗa tare da takamaiman sel. Bari mu yi la'akari da zaɓuɓɓuka biyu.

Ƙara kariyar takarda

Lokacin da aka kunna wannan zaɓi abinda ke cikin tantanin halitta a mashaya dabara ya daina nunawa. Koyaya, duk wani hulɗa tare da dabara a cikin wannan yanayin kuma za a hana shi, don haka don yin canje-canje, kuna buƙatar kashe kariyar takarda. Ana kunna kariyar takardar kamar haka:

1. Zaɓi sel waɗanda kuke son ɓoye tsarin su.
2. Dama danna kan yankin da aka haskaka. A cikin mahallin menu, je zuwa abu "Format Cells". Madadin haka, zaku iya amfani da gajeriyar hanyar keyboard "Ctrl + 1".

3. Taga mai saitunan tsarin salula zai buɗe. Canja zuwa shafin "Kariya".
4. Duba akwatin kusa da Boye Formulas. Idan kuma kuna buƙatar hana gyara abubuwan da ke cikin sel, to ku duba akwatin kusa da “Tantanin halitta mai kariya”. Danna "Ok" don amfani da saitunan kuma rufe taga don canza tsarin salula.

5. Kar a cire sel. Canja zuwa shafin "Review", wanda ke cikin menu na sama.
6. A cikin rukunin kayan aiki "Kare", danna kan "Kare Sheet".
7. Tagan saitunan kariyar takardar zai buɗe. Yi tunanin kalmar sirri kuma shigar da shi a cikin filin da ya dace. Danna "Ok" don amfani da kalmar wucewa.

8. Tagan tabbatar da kalmar sirri zai bayyana. Shigar da shi a can kuma danna Ok.
9. A sakamakon haka, za a sami nasarar ɓoye hanyoyin. Lokacin da kuka zaɓi layuka masu kariya, sandar shigarwar dabara za ta zama fanko.

Hankali! Don yin canje-canje ga sel masu kariya, kuna buƙatar hana takaddun aiki ta amfani da kalmar wucewa da kuka bayar.

Idan kana son wasu sel su sami damar canza dabi'u kuma a sanya su cikin lissafi ta atomatik a cikin ɓoyayyun dabaru, yi masu zuwa:

1. Zaɓi sel da ake buƙata.
2. Danna-dama a kan zaɓi kuma je zuwa Format Cells.
3. Canja zuwa shafin "Kariya" kuma cire alamar "kariyar salula" abu. Danna "Ok" don amfani.
4. Yanzu zaku iya canza dabi'u a cikin sel da aka zaɓa. Sabbin bayanai za a musanya ta atomatik a cikin ɓoyayyun dabaru.

Hana zaɓin tantanin halitta

Ana amfani da wannan zaɓin idan kuna buƙatar ba kawai don hana aiki tare da sel ba kuma ku ɓoye dabarar, amma har ma don sa ba zai yiwu a zaɓi su ba. A wannan yanayin, ba zai yi aiki ba don canza zane.

1. Zaɓi kewayon sel da ake so. Dama danna kan yankin da aka haskaka.
2. Canja zuwa shafin "Kariya". Bincika idan akwai alamar bincike kusa da "Tsel Kare". Idan ba haka ba, to shigar da shi.
3. Danna "Ok" don amfani.
4. Canja zuwa shafin Bita. A can, zaɓi kayan aikin Kare Sheet.
5. Tagan saitunan kariyar zai buɗe. Cire alamar akwatin da ke kusa da "Haske sel masu kulle" kuma danna "Ok" don amfani da saitunan.

6. Tabbatar da kalmar wucewa ta sake buga shi a cikin taga da ya bayyana.
7. Yanzu ba za ku iya yin hulɗa tare da ƙayyadadden sel kwata-kwata. Wannan ya dace sosai idan kuna aika da takarda ga wani kuma ba sa son mai karɓa ya lalata wani abu a ciki.

Muhimmin! Ba a ba da shawarar wannan zaɓi ba idan kuna aika daftarin aiki zuwa wani mai amfani wanda zai iya buƙatar yin canje-canje a gare ta. Gaskiyar ita ce, a cikin takaddun da sel ke da haɗin kai sosai, mai karɓar mai yiwuwa ba zai iya yin wani gyara da shi kwata-kwata ba.

Kammalawa

Lokacin ɓoye ƙididdiga a cikin sel a cikin Excel, a shirya don iyakan gyara abun ciki. A cikin zaɓi na farko, ana iya ƙetare su ta hanyar ɗaukar ƙarin matakai. Zaɓin na biyu yana nuna rashin yiwuwar yin kowane canje-canje ga sel waɗanda ka yanke shawarar ɓoye tsarin su.