Bari mu ce mun ƙirƙiri fom don shigar da mai amfani, kamar wannan:
Lokacin shigarwa, koyaushe akwai yuwuwar shigar da bayanan da ba daidai ba, “launi na ɗan adam”. Ɗaya daga cikin zaɓuɓɓuka don bayyanarsa shine ƙarin wurare. Wani yana sanya su da gangan, wani da gangan, amma, a kowane hali, ko da ƙarin sarari ɗaya zai ba ku matsala a nan gaba lokacin sarrafa bayanan da aka shigar. Wani ƙarin "la'a" shine cewa har yanzu ba a ganuwa ba, kodayake, idan da gaske kuke so, kuna iya nuna su ta amfani da macro.
Tabbas, yana yiwuwa kuma ya zama dole don " tsefe" bayanan bayan shigar da shi tare da taimakon ayyuka na musamman ko macros. Kuma zaku iya haskaka bayanan da aka shigar ba daidai ba yayin aiwatar da cike fom, da sauri nuna kuskure ga mai amfani. Don wannan:
- Hana filayen shigarwa inda kuke buƙatar bincika ƙarin sarari (kwayoyin rawaya a misalinmu).
- Zabi akan babban umarnin tab Tsarin Yanayi - Ƙirƙiri Doka (Gida - Tsarin Sharadi - Ƙirƙirar Doka).
- Zaɓi nau'in ƙa'ida Yi amfani da dabara don tantance waɗanne sel don tsarawa (Yi amfani da dabara don tantance wane sel don tsarawa) kuma shigar da dabara mai zuwa a cikin filin:
inda D4 shine adireshin tantanin halitta na yanzu (ba tare da alamun "$") ba.
A cikin sigar Turanci zai kasance, bi da bi = G4<>TRIM(G4)
aiki TASHIYA (TRIM) yana cire ƙarin sarari daga rubutun. Idan ainihin abun ciki na tantanin halitta na yanzu bai yi daidai da “combed” tare da aikin ba TASHIYA, don haka akwai ƙarin sarari a cikin tantanin halitta. Sannan filin shigarwa yana cike da launi wanda za'a iya zaɓar ta danna maɓallin tsarin (Format).
Yanzu, lokacin da ake cike ƙarin wurare "don kyau", za a haskaka filayen shigar da mu da ja, tare da nuna wa mai amfani da cewa ba daidai ba ne:
Anan akwai irin wannan dabara mai sauƙi amma kyakkyawa wacce na yi amfani da ita sau da yawa a cikin ayyukana. Ina fatan ku ma kuna samun amfani 🙂
- Tsaftace rubutu daga ƙarin sarari, haruffa marasa bugawa, haruffan Latin, da sauransu.
- Kayan aikin don cire ƙarin sarari daga ƙarawar PLEX
- Kare zanen gado, littattafan aiki da fayiloli a cikin Microsoft Excel