Yadda ake ɓoye duk bayanin kula a cikin Excel lokaci guda

Bayanan kula a cikin Microsoft Office Excel wasu ƙarin bayanai ne waɗanda mai amfani ya ɗaure zuwa wani takamaiman yanki na tsararrun tebur ko zuwa kewayon sel. Rubutun yana ba ka damar rubuta ƙarin bayani a cikin tantanin halitta ɗaya don tunatar da kai wani abu. Amma wasu lokuta ana buƙatar ɓoye ko cire bayanin kula. Yadda za a yi hakan za a tattauna a wannan talifin.

Yadda ake ƙirƙirar bayanin kula

Don cikakken fahimtar batun, da farko kuna buƙatar koya game da hanyoyin ƙirƙirar bayanin kula a cikin Microsoft Office Excel. Ba daidai ba ne a yi la'akari da duk hanyoyin da ke cikin tsarin wannan labarin. Don haka, don adana lokaci, muna gabatar da mafi sauƙin algorithm don kammala aikin:

1. Danna dama akan tantanin halitta da kake son rubuta rubutu a ciki.
2. A cikin nau'in mahallin mahallin, danna LMB akan layin "Saka bayanin kula".

3. Wani ƙaramin akwati zai bayyana kusa da tantanin halitta, wanda zaku iya shigar da rubutun bayanin kula. Anan zaka iya rubuta duk abin da kake so bisa ga ra'ayin mai amfani.

4. Lokacin da aka rubuta rubutun, kuna buƙatar danna kowane tantanin halitta kyauta a cikin Excel don ɓoye menu. Wani abu mai rubutu za a yi masa alama da ƙaramin jajayen alwatika a kusurwar dama ta sama. Idan mai amfani ya motsa siginan kwamfuta na linzamin kwamfuta akan wannan tantanin halitta, rubutun da aka buga zai bayyana.

Kula! Hakanan, zaku iya ƙirƙirar bayanin kula ga kowane tantanin halitta a cikin takaddar aikin Excel. Adadin haruffan da aka shigar cikin taga bai iyakance ba.

A matsayin bayanin kula ga tantanin halitta, zaka iya amfani da ba kawai rubutu ba, har ma da hotuna daban-daban, hotuna, siffofi da aka sauke daga kwamfuta. Duk da haka, dole ne a ɗaure su da wani takamaiman yanki na jeri na tebur.

Yadda ake ɓoye bayanin kula

A cikin Excel, akwai hanyoyi da yawa na gama gari don cika aikin, kowannensu ya cancanci cikakken la'akari. Za a ci gaba da tattauna wannan.

Hanyar 1: Boye bayanin kula guda ɗaya

Don cire tambarin tantanin halitta ɗaya na ɗan lokaci a cikin tsararrun tebur, dole ne ku yi masu zuwa:

1. Yi amfani da maɓallin linzamin kwamfuta na hagu don zaɓar wani abu wanda ya ƙunshi bayanin kula da ke buƙatar gyara.
2. Dama danna kowane yanki na tantanin halitta.
3. A cikin mahallin mahallin da ya bayyana, nemo layin "Share bayanin kula" kuma danna kan shi.

4. Duba sakamakon. Ƙarin sa hannun ya kamata ya ɓace.
5. Idan ya cancanta, a cikin wannan taga na nau'in mahallin, danna kan layin "Edit note" don sake rubuta rubutun da aka buga a baya, gyara gazawar.

Hanyar 2. Yadda ake cire bayanin kula daga duk sel lokaci guda

Microsoft Office Excel yana da aiki don cire tsokaci a lokaci guda daga duk abubuwan da yake ciki. Don amfani da wannan damar, dole ne ku yi abubuwa masu zuwa:

1. Zaɓi gabaɗayan jeri na tebur tare da maɓallin linzamin kwamfuta na hagu.
2. Matsa zuwa shafin "Review", wanda yake a saman kayan aiki na shirin.
3. A cikin yankin da ke buɗewa, za a gabatar da zaɓuɓɓuka da yawa. A wannan yanayin, mai amfani yana sha'awar maɓallin "Share", wanda ke kusa da kalmar "Ƙirƙiri bayanin kula". Bayan dannawa, za a share sa hannu ta atomatik daga duk sel na farantin da aka zaɓa.

Muhimmin! Hanyar ɓoye ƙarin sa hannu da aka tattauna a sama ana ɗaukarsa a duniya kuma yana aiki a duk nau'ikan software.

Hanyar 3: Yi amfani da menu na mahallin don ɓoye sharhi a cikin Excel

Don cire alamun daga duk sel a cikin tebur a lokaci guda, zaku iya amfani da wata hanya. Ya ƙunshi yin magudi kamar haka:

1. Bisa ga irin wannan makircin da aka tattauna a cikin sakin layi na baya, zaɓi kewayon sel da ake so a cikin tebur.
2. Danna-dama akan yankin da aka zaɓa na tsararrun bayanan tabular tare da maɓallin linzamin kwamfuta na dama.
3. A cikin nau'in mahallin mahallin da ya bayyana, danna LMB sau ɗaya akan layin "Share bayanin kula".

4. Tabbatar cewa bayan yin matakin da ya gabata, an cire alamun duk sel.

Hanyar 4: Gyara wani aiki

Bayan ƙirƙirar bayanan kuskure da yawa, zaku iya ɓoye su ɗaya bayan ɗaya, share su ta amfani da kayan aikin gyarawa. A aikace, ana aiwatar da wannan aikin kamar haka:

1. Cire zaɓi daga dukan tebur, idan yana nan, ta danna LMB akan sarari kyauta na takaddar aikin Excel.
2. A cikin kusurwar hagu na sama na mu'amalar shirin, kusa da kalmar "File", nemo maɓallin a cikin nau'in kibiya zuwa hagu kuma danna shi. Ya kamata a soke aikin da aka yi a ƙarshe.
3. Hakazalika, danna maɓallin "Cancel" har sai an share duk bayanin kula.

Wannan hanya tana da babban koma baya. Bayan danna maɓallin da aka yi la'akari, mahimman ayyukan da mai amfani ya yi bayan ƙirƙirar sa hannu kuma za a share su.

Mahimmin bayani! A cikin Excel, kamar yadda yake a cikin kowane editan Microsoft Office, za a iya aiwatar da aikin sake yin amfani da gajeriyar hanyar keyboard. Don yin wannan, kana buƙatar canza maballin kwamfuta zuwa shimfidar Ingilishi kuma a lokaci guda ka riƙe maɓallin "Ctrl + Z".

Kammalawa

Don haka, bayanin kula a cikin Microsoft Office Excel yana taka muhimmiyar rawa wajen haɗa tebur, yin aikin haɓakawa, faɗaɗa mahimman bayanai a cikin tantanin halitta. Koyaya, wani lokacin dole ne a ɓoye su ko cire su. Don fahimtar yadda ake cire sa hannu a cikin Excel, kuna buƙatar karanta hanyoyin da ke sama a hankali.