Kwamfuta ta atomatik a cikin Excel

Kwayoyin cikawa ta atomatik a cikin Excel suna ba ku damar hanzarta shigar da bayanai cikin takaddar aiki. Wasu ayyuka a cikin Microsoft Excel dole ne a maimaita su sau da yawa, wanda ke ɗaukar lokaci mai yawa. Don sarrafa irin waɗannan ayyuka ne aka haɓaka aikin na atomatik. A cikin wannan koyawa, za mu dubi mafi yawan hanyoyin da ake amfani da su don cikawa ta atomatik: ta amfani da alamar alama da filashi, wanda ya fara bayyana a cikin Excel 2013.

Yin amfani da alamar autofill a cikin Excel

Wani lokaci kana buƙatar kwafin abun ciki zuwa sel da yawa da ke kusa akan takardar aiki. Kuna iya kwafa da liƙa bayanai cikin kowace tantanin halitta daban-daban, amma akwai hanya mafi sauƙi. Don yin wannan, kuna buƙatar amfani da madaidaicin autocomplete, wanda ke ba ku damar kwafi da liƙa bayanai da sauri.

1. Zaɓi tantanin halitta wanda kake son kwafin bayanansa. Ƙananan murabba'i zai bayyana a cikin ƙananan kusurwar dama na tantanin halitta da aka zaɓa - wannan shine alamar cikawa.
2. Danna ka riƙe maɓallin linzamin kwamfuta na hagu kuma ja hannun mai cike da atomatik har sai an haskaka duk sel da ake buƙata. Nan da nan, zaku iya cika sel na ko dai shafi ko jere.
3. Saki maɓallin linzamin kwamfuta don cike sel da aka zaɓa.

Cika Sequential Data Series a cikin Excel

Ana iya amfani da alamar cikawa ta atomatik a duk lokacin da kuke buƙatar cika bayanai waɗanda ke da tsari na jeri. Misali, jerin lambobi (1, 2, 3) ko kwanaki (Litinin, Talata, Laraba). A mafi yawan lokuta, kuna so ku zaɓi sel da yawa kafin kuyi amfani da alamar don taimakawa Excel tantance matakin jerin.

Misalin da ke ƙasa yana amfani da alamar cikawa ta atomatik don ci gaba da jerin kwanakin a cikin shafi.

Cika Nan take a cikin Excel

Excel 2013 yana da sabon zaɓi na Flash Fill wanda zai iya shigar da bayanai ta atomatik cikin takaddar aiki, yana ceton ku lokaci da ƙoƙari. Kamar AutoComplete, wannan zaɓi yana sarrafa irin bayanan da kuka shigar akan takardar aiki.

A cikin misalin da ke ƙasa, muna amfani da Fill Fill don ƙirƙirar jerin sunaye daga jerin adiresoshin imel da ke akwai.

1. Fara shigar da bayanai akan takardar aiki. Lokacin da Fill Fill ya gano tsari, samfotin zaɓin yana bayyana a ƙasan tantanin halitta da aka haskaka.
2. Danna Shigar. Za a ƙara bayanan zuwa takardar.

Don gyara ko canza sakamakon aikin Fill Fill, danna alamar wayo da ke bayyana kusa da sabbin ƙima.