Yin amfani da rubutun fitar da rubutu yayi aiki don nuna sakaci, ba dacewar wani aiki ko taron ba. Wasu lokuta wannan yanayin yana zama dole don amfani yayin aiki a Excel. Amma, abin takaici, ba maɓallin keɓaɓɓun ko ɓangaren da ake iya gani a cikin shirin neman aikin ba suna da kayan aikin da suke da masaniya don yin wannan aikin. Bari mu gano yadda zaku iya amfani da rubutun tsallake cikin Excel.
Darasi: Rubutun rubutu a cikin Microsoft Word
Yin amfani da rubutu na rubutu
Strikethrough in Excel sashin tsara abubuwa ne. Dangane da wannan, ana iya ba da wannan mallakar ga matani ta amfani da kayan aikin tsara.
Hanyar 1: menu na mahallin
Hanya mafi gama gari don masu amfani su hada da tsaran rubutu a tsakanin masu amfani shine ka je taga ta hanyar menu Tsarin Cell.
- Zaɓi tantanin halitta ko kewayo inda rubutun da kake son yi ya wuce. Danna dama. Tushen mahallin yana buɗewa. Danna kan jerin a cikin jerin Tsarin Cell.
- Tsarin tsarawa yana buɗe. Je zuwa shafin Harafi. Duba akwatin kusa da abun Strikethroughwanda yake a cikin rukunin saiti "Gyara". Latsa maballin "Ok".
Kamar yadda kake gani, bayan waɗannan ayyukan, alamomin da aka zaɓa sun zama ƙetarewa.
Darasi: Tsarin tebur a cikin Excel
Hanyar 2: tsara kalmomin mutum a sel
Sau da yawa kuna buƙatar yin dama don ƙetare duk abubuwan da ke cikin tantanin halitta, amma takamaiman kalmomi a ciki, ko ma wani sashi na kalma. A cikin Excel, wannan ma yana yiwuwa.
- Mun sanya siginan kwamfuta a cikin tantanin kuma zaɓi ɓangaren rubutun da ya kamata a ƙetare. Danna-dama akan menu na mahallin. Kamar yadda kake gani, yana da ɗan fuska kaɗan daban-daban fiye da lokacin amfani da hanyar da ta gabata. Koyaya, kayan da muke buƙata "Tsarin kwayar halitta ..." nan ma. Danna shi.
- Taganan Tsarin Cell yana buɗewa. Kamar yadda kake gani, a wannan karon ya kunshi shafuka daya kacal Harafi, wanda ya kara sauƙaƙe aikin, tunda babu buƙatar zuwa ko'ina. Duba akwatin kusa da abun Strikethrough kuma danna maballin "Ok".
Kamar yadda kake gani, bayan waɗannan jan hankali, kawai zaɓin ɓangarorin rubutun kalmomin da ke cikin tantanin halitta ya fito.
Hanyar 3: kayan aikin tef
Canjin zuwa ƙirar sel don ba da rubutu ya zama za a iya yin amfani da kintinkiri.
- Zaɓi sel, rukuni na sel ko rubutu a ciki. Je zuwa shafin "Gida". Mun danna kan gunkin a cikin nau'i na kibiya mai rauni wadda take a cikin ƙananan kusurwar dama na toshe kayan aiki Harafi a kan tef.
- Tsarin tsarawa yana buɗe ko dai tare da cikakken aiki ko tare da gajeriyar. Ya dogara da abin da ka zaɓa: sel ko rubutu kawai. Amma ko da taga yana da cikakken aikin Multi-tab, zai buɗe a cikin shafin Harafi, wanda muke buƙatar magance matsalar. Na gaba, muna yin daidai kamar yadda a cikin zaɓuɓɓuka biyu da suka gabata.
Hanyar 4: gajeriyar hanya
Amma hanya mafi sauƙi don yin saɓon rubutu shine amfani da maɓallan zafi. Don yin wannan, zaɓi tantanin ko magana a ciki kuma shigar da gajeriyar hanya ta maballin Ctrl + 5.
Tabbas, wannan shine mafi dacewa kuma mafi saurin dukkanin hanyoyin da aka bayyana, amma ba da gaskiya cewa ƙarancin masu amfani da yawa sun kiyaye haɗuwa da hotkey daban-daban a ƙwaƙwalwar su, wannan zaɓi don ƙirƙirar rubutun da aka ƙeta shine mafi ƙarancin mita zuwa yin amfani da wannan hanya ta taga tsarawa.
Darasi: Babban hotkeys
A cikin Excel, akwai hanyoyi da yawa don yin rubutun rubutu. Duk waɗannan zaɓuɓɓuka suna da alaƙa da aikin tsarawa. Hanya mafi sauki don aiwatar da sauyawar halayyar da aka ƙayyade ita ce amfani da haɗakar hotkey.
