Yadda ake saka akwati a cikin ma'auni na Excel

A cikin Microsoft Office Excel, zaku iya sanya akwati a cikin kowane tantanin halitta na tebur. Wannan wata ƙayyadaddun alama ce a cikin nau'in alamar rajista, wanda aka ƙera don ƙawata kowane sashe na rubutu, haskaka mahimman abubuwa, da ƙaddamar da rubutun. Wannan labarin zai tattauna hanyoyin saita alama a cikin Excel ta amfani da kayan aikin da aka gina a cikin shirin.

Yadda ake duba akwatin

Duba akwati a cikin Excel yana da sauƙin isa. Tare da wannan alamar, iyawarta da ƙayataccen takaddar za su ƙaru. Za a tattauna ƙarin game da shi daga baya.

Hanyar 1: Yi amfani da daidaitattun Alamomin Microsoft Excel

Excel, kamar Word, yana da nasa ɗakin karatu na alamomi daban-daban waɗanda za a iya shigar da su a ko'ina a kan takardar aiki. Don nemo gunkin alamar bincike kuma sanya shi a cikin tantanin halitta, kuna buƙatar bin waɗannan matakan:

• Zaɓi tantanin halitta inda kake son saka akwati.
• Matsa zuwa sashin "Saka" a saman babban menu.
• Danna maɓallin "Alamomin" a ƙarshen jerin kayan aikin.
• A cikin taga da yake buɗewa, sake danna maɓallin "Symbol". Menu na gumakan da aka gina a ciki zai buɗe.

• A cikin filin "Saita", zaɓi zaɓi "Haruffa don canza wurare", nemo alamar rajistan shiga cikin jerin sigogin da aka gabatar, zaɓi shi tare da LMB kuma danna kalmar "Saka" a ƙasan taga.

• Tabbatar an saka akwati a cikin tantanin halitta daidai.

Kula! Akwai nau'ikan akwatunan rajista da yawa a cikin kundin alamar. An zaɓi gunkin bisa ga shawarar mai amfani.

Hanyar 2. Sauya haruffa

Matakan da ke sama na zaɓi ne. Ana iya shigar da alamar akwati da hannu daga madannai na kwamfuta ta hanyar sauya fasalinsa zuwa yanayin Ingilishi da latsa maɓallin "V".

Hanyar 3. Duba akwatin don kunna akwati

Ta hanyar dubawa ko cire alamar rajistan shiga cikin Excel, zaku iya gudanar da rubutun daban-daban. Da farko kuna buƙatar sanya akwati a kan takardar aiki ta kunna yanayin haɓakawa. Don saka wannan kashi, kuna buƙatar yin manipulations masu zuwa:

• Danna kalmar "File" a saman kusurwar hagu na allon.
• Je zuwa sashin "Settings".

• A cikin taga na gaba, zaɓi sashin "Ribbon Customization" a gefen hagu na allon.
• A cikin ginshiƙin "Main shafuka" a cikin jerin, nemo layin "Mai Haɓakawa" kuma duba akwatin kusa da wannan zaɓi, sannan danna "Ok" don rufe taga.

• Yanzu, a cikin jerin kayan aikin da ke saman babban menu na shirin, shafin "Developer" zai bayyana. Kuna buƙatar shiga ciki.
• A cikin toshe aiki na kayan aiki, danna maɓallin "Saka" kuma a cikin "Controls" shafi na tsari, danna gunkin akwati.

• Bayan kammala matakan da suka gabata, maimakon daidaitaccen siginan linzamin kwamfuta, za a nuna gunki a cikin nau'in giciye. A wannan mataki, mai amfani yana buƙatar danna LMB akan yankin da za a saka fom.
• Tabbatar cewa fankon murabba'i ya bayyana a cikin tantanin halitta bayan dannawa.
• Danna LMB akan wannan fili, kuma za a sanya tuta a ciki.

• Kusa da akwati a cikin tantanin halitta za a sami daidaitaccen rubutu. Kuna buƙatar zaɓar shi kuma danna maɓallin "Delete" daga maballin don share shi.

Muhimmin! Daidaitaccen rubutun da ke kusa da alamar da aka saka ana iya maye gurbinsa da kowane bisa ga shawarar mai amfani.

Hanyar 4. Yadda ake ƙirƙirar akwati don aiwatar da rubutun

Ana iya amfani da akwati da aka saita a cikin tantanin halitta don aiwatar da wani aiki. Wadancan. a kan takardar aiki, a cikin tebur, za a yi canje-canje bayan dubawa ko cirewa akwatin. Don yin hakan, kuna buƙatar:

• Bi matakan da ke cikin sashin da ya gabata don yiwa alama alama a cikin tantanin halitta.
• Danna LMB akan abubuwan da aka saka kuma je zuwa menu na "Format Object".

• A cikin "Control" tab a cikin "Value" shafi, sanya jujjuya jujjuya sabanin layin da ke nuna halin yanzu na akwati. Wadancan. ko dai a cikin filin "Shigar" ko a cikin layin "Cire".
• Danna maɓallin hanyar haɗi zuwa Cell a kasan taga.

• Ƙayyade tantanin halitta wanda mai amfani ke shirin aiwatar da rubutun ta hanyar jujjuya akwati da danna gunkin guda kuma.

• A menu na Format Object, danna Ok don amfani da canje-canjenku.

• Yanzu, bayan duba akwatin, kalmar "GASKIYA" za a rubuta a cikin tantanin halitta da aka zaɓa, kuma bayan cire darajar "KARYA".

• Ana iya haɗa kowane aiki zuwa wannan tantanin halitta, misali, canza launi.

Ƙarin Bayani! Ana yin ɗaurin launi a cikin menu na "Format Cells" a cikin shafin "Cika".

Hanyar 5. Shigar da akwati ta amfani da kayan aikin ActiveX

Ana iya aiwatar da wannan hanyar bayan kunna yanayin haɓakawa. Gabaɗaya, ana iya rage algorithm aiwatar da aikin kamar haka:

• Kunna yanayin haɓakawa kamar yadda aka bayyana a sama. An ba da cikakkun bayanai lokacin la'akari da hanya ta uku don saka tuta. Ba shi da ma'ana a maimaita.
• Danna-dama akan tantanin halitta tare da murabba'i mara komai da daidaitaccen rubutu wanda zai bayyana bayan shigar da yanayin "Developer".
• Zaɓi "Properties" daga menu na mahallin.

• Wani sabon taga zai buɗe, a cikin jerin sigogi waɗanda zaku buƙaci nemo layin "Value" kuma shigar da kalmar "Gaskiya" da hannu maimakon "Ƙarya".

• Rufe taga kuma duba sakamakon. Ya kamata alamar bincike ta bayyana a cikin akwatin.

Kammalawa

Don haka, a cikin Excel, ana iya saita akwati ta hanyoyi daban-daban. Zaɓin hanyar shigarwa ya dogara da manufofin da mai amfani ke bi. Don kawai yiwa wannan ko wancan abu alama a cikin kwamfutar hannu, ya isa a yi amfani da hanyar musanya alamar.