Yadda ake cire lambobin zagaye a fice

Hanyar 1: Aiki "Bayyana Babbar"

Hanya mafi sauƙi kuma hanya mafi sauri don kashe lambobi masu zagaye a Excel shine amfani da "Haɗin girma" aiki. Yana aiki akan ka'idar ƙara nuna alamun lambobi bayan wakafi zuwa adadin da ake buƙata, kuma ana buƙatar yin aiki biyu.

1. Yanke shawarar wane ƙwayoyin kuke buƙatar yin canje-canje, kuma idan akwai da yawa daga cikinsu, ware komai lokaci ɗaya.



2. A cikin "lambar" toshe, fadada jerin abubuwan lambobi da yanke shawara wanda kake son amfani da shi.



3. Nan da nan, sannan danna maɓallin "Haƙiƙa girma" kamar yadda lambobin suke so ƙara.



4. Bibiya canje-canje ta hanyar kallon yanayin sel, ka kuma yi la'akari da cewa da zaran an cire haɗin zai, kowane ƙimar da aka kara zai zama "0".

Daidai wani zaɓi shima yana aiki, tsara don rage ɗigo. Ana a kan wannan panel kuma ana iya amfani dashi idan kun kara da wasu alamomi marasa amfani.

Hanyar 2: Saita tsarin sel

Saita tsarin tantanin halitta yana ba ku damar saita ainihin adadin semicolons don saita zagaye ta atomatik. Hakan ba zai hana komai ya kara adadin su ba, don haka ya cire. Don yin wannan, kuna buƙatar nufin menu na da ya dace a Excel.

1. Da farko dai, koyaushe yana ƙarƙashin waɗannan ƙwayoyin da za a yi amfani da canje-canje masu zuwa.



2. Na gaba, fadada "menu na" tantanin halitta kuma zaɓi Menu zaɓi na ƙasa.



3. A ciki, danna maɓallin sabon tsarin tsarin tantanin halitta.



4. Zaɓi maɓallin hagu tare da tsarin lambobin da ake amfani da shi don sel da aka zaɓa a baya.



5. Saita yawan alamun decimal ta hanyar buga darajar ta a fagen wannan, nemi sabon saiti kuma bar menu na yanzu.



6. Yi la'akari da sel da aka zaba a baya kuma ka tabbatar cewa an nuna dabi'unsu daidai.

Hanyar 3: canje-canje a tsarin tantanin halitta

Yana ƙare da labarin ta zaɓi wanda ya nuna canji a cikin tsarin sel tare da lambobin da aka kashe. Wannan ita ce kawai hanyar da za ta yi tasiri idan zagaye ya faru ne saboda karancin wurin a cikin sel duka.

Kuna iya amfani da hanyar da ta gabata ta zaɓar wani tsarin sel, amma a lokaci guda tare da sakamakon za ku iya karantawa ne kawai bayan barin menu. A madadin haka, muna ba ku shawara don tura menu "lambar", wanda tuni an faɗa a cikin hanyar 1, kuma duba ra'ayin lambobin don wasu tsararrun. Latsa wanda zai dace domin nan da nan ya shiga aiki.

Yi la'akari da cewa idan yawan tsarin rubutu ba zai iya yin lissafin adadin sa a lokacin ware ba ko amfani da tantanin halitta a cikin lissafin lissafi. Idan a nan gaba zai zama dole a sake zagaye lambobi, yi amfani da sauran umarnin akan gidan yanar gizon mu ta danna kan mahaɗin da ke ƙasa.

Kara karantawa: Lambobin zagaye a Microsoft Excel