Ga abin da ma'anar Rediyo ta Red da Green Tigers ke nufi

Akwai matakai biyu masu launin shuɗi - ja da kore - waɗanda aka yi amfani da shi a Excel don nuna bayanin ga mai amfani game da:

• Zai yiwu kurakurai a cikin abun ciki na cell
• gaban mai amfani yayi magana a cikin tantanin halitta

Bugu da ƙari ga launi, maƙallan ya bayyana a sassan daban-daban na cellular aiki :

• Green - saman hagu
• Red - saman dama

Ƙungiyar Tudun Tsuntsu

Kullun kore yana bayyana a cikin tantanin halitta lokacin da abinda ke ciki na sirri ya karya ɗaya daga cikin kuskuren ɓataccen Excel.

Wadannan dokoki suna kunna ta tsoho kuma suna saka idanu don kuskure guda ɗaya kamar:

• Kwayoyin dake dauke da takaddun da suka haifar da kuskure - irin su #VALUE! ko # DIV / 0!
• samfurori waɗanda basu da bambanci ko daban-daban daga samfurori a cikin kwayoyin kewaye
• Lambobin da aka tsara a matsayin bayanai na rubutu

Idan ka danna kan tantanin halitta wanda ke dauke da maƙallan kore mai maɓallin zaɓi na kuskure yana nuna kusa da shi.

Maɓallin zaɓi na kuskure shine siffar lu'u-lu'u mai launin rawaya tare da bayanan launin toka wanda ya ƙunshi zabin don gyara kuskuren da aka gane.

Kashe Gidan Triangle

Kuskuren kuskure ya kunna ta tsoho a cikin Excel don haka harsunan kore suna bayyana a duk lokacin da duk inda Excel ke ƙayyade akwai wani cin zarafin doka.

Za'a iya canza wannan tsoho a cikin akwatin maganganu na Excel .

Don kashe kuskuren dubawa:

1. danna File> Zabuka don buɗe akwatin maganganu
2. a cikin ɓangaren Zangon Kuskuren a hannun dama na dama, cire alamar dubawa daga Yanayin dubawa na ɓataccen ɓangaren waje
3. danna Ya yi don karɓar canji kuma rufe akwatin maganganun Zabuka

Canza Kuskuren Kuskuren Dokokin

Canje-canje ga dokokin dubawa na kuskure da aka yi amfani da shi a cikin wani littafi ne aka yi a cikin akwatin maganganu na Excel Options .

Don sauya dokokin dubawa:

1. danna Fayil> Zabuka
2. a cikin Kuskuren Dokokin Kuskuren a hannun dama, ƙara ko cire alamomi don kunna ko kashe zažužžukan daban-daban
3. danna Ya yi don karɓar canji kuma rufe akwatin maganganun Zabuka

Canza Triangle & # 39; s Launi

Za'a iya canza launin launi na kore wannan rukuni a cikin akwatin maganganu na Excel .

Don canza launin alwashin tabarau:

1. danna Fayil> Zabuka
2. a cikin ɓangaren Zangon Kuskuren a hannun dama, zaɓi launi dabam dabam daga palette na launi kusa da Bayyana kurakurai ta amfani da wannan launi
3. danna Ya yi don karɓar canji kuma rufe akwatin maganganun Zabuka

Triangle Red

Gilashi mai launin ja a saman kusurwar dama na tantanin halitta yana nuna cewa an ƙara bayanin mai amfani akan tantanin halitta.

Don karanta wannan sharhi, toshe siginar linzamin kwamfuta a kan tantanin halitta wanda ke dauke da aljan ja; akwatin rubutu da ke dauke da sharhin zai bayyana kusa da tantanin halitta.

Ƙarin zaɓuɓɓuka don nunawa da nunawa sune:

• ba da nunawa ko alamomi - ko da a lokacin da yake kunshe a jikin salula dauke da sharhi
• ko da yaushe suna nuna sharhi da alamomi ga dukkan kwayoyin da ke dauke da maganganu

Canje-canje a cikin maganganun maganganun an yi a cikin akwatin maganganu na Excel Options .

Don canja zaɓuɓɓukan sharuddan:

1. danna Fayil> Zabuka> Babba
2. ƙarƙashin> Sashen nuni a hannun dama, yin canje-canje ga Ƙungiyoyin cell da ke kunshe da bayanin nuna: zaɓi
3. danna Ya yi don karɓar canji kuma rufe akwatin maganganun Zabuka

Zaɓuɓɓukan Excel don ƙirƙirar, gyara, motsawa, ko sharewar salula na sirri a ƙarƙashin Ƙaƙwalwar shafin a cikin Sashen faɗi na rubutun.