Shin kun taɓa fitar da maƙunsar rubutu, sannan kuka yi tuntuɓe a kansa bayan ƴan watanni, kawai kuna mamakin menene maƙunsar rubutun, kwanan wata da aka buga, ko menene bayanin da yakamata ku kula dashi? Wannan ya zama ruwan dare, musamman idan kuna yawan buga sabbin sigogin maƙunsar rubutu iri ɗaya.
Yin aiki tare da maƙunsar bayanai, ko kuna amfani da zaɓin Google Apps, Google Sheets, ko zaɓi na Microsoft Office, Microsoft Excel, galibi ƙoƙari ne na kashi biyu. Kashi na farko shine shigar da duk bayanan da aka tsara su daidai, sannan kashi na biyu shine a tsara dukkan zaɓuɓɓukan saitin shafi ta yadda maƙunsar bayanai ta yi kyau idan an buga su.
Fayilolin Google Sheets sun ɗan fi sauƙi don bugawa ta tsohuwa, amma duka aikace-aikacen biyu yawanci za su buƙaci ka ƙara bayanai zuwa taken ko daidaita zaɓuɓɓuka daban-daban domin fitin bayanan ya sami sauƙin fahimta.
Hanya ɗaya don magance wannan matsalar ita ce amfani da sunan fayil a cikin taken. Wannan yana ƙara gano bayanai zuwa kowane shafi na maƙunsar bayanai idan waɗannan shafukan sun rabu, yayin da suke ba da bayanai masu mahimmanci waɗanda zasu taimaka muku gano bugun daga baya. Jagoranmu da ke ƙasa zai nuna muku yadda ake ƙara taken littafin aiki zuwa take a cikin Google Sheets.
Yadda ake buga sunan littafin aiki a saman shafin a cikin Google Sheets
- Bude fayil ɗin maƙunsar bayanai.
- Danna shafin fayil .
- Gano wuri Buga .
- Zaɓi shafin Masu kai da ƙafa .
- duba akwatin Taken littafin aiki .
- Danna na gaba Sannan Buga .
Matakan da ke sama suna ɗauka cewa an riga an shigar da ku cikin asusun Google wanda ke ɗauke da fayil ɗin da kuke son ƙara take a cikin saitunan bugawa.
Jagoranmu na ƙasa yana ci gaba da ƙarin bayani game da sanya adireshi akan maƙunsar bayanai na Google, gami da hotunan waɗannan matakan.
Yadda ake ƙara sunan fayil zuwa shafi yayin bugawa a cikin Google Sheets (Jagora tare da Hotuna)
Matakan da ke cikin wannan labarin za su nuna maka yadda ake canza saiti don littafin aikin Sheets na Google domin a buga taken littafin aiki a cikin take, akan kowane shafi na maƙunsar bayanai. Wannan saitin ya shafi littafin aiki na yanzu kawai, don haka kuna buƙatar yin wannan canji akan wasu maƙunsar bayanai waɗanda kuke son buga sunan fayil ɗin don su.
Mataki 1: Je zuwa Google Drive a kunne https://drive.google.com/drive/my-drive Bude fayil ɗin wanda sunan littafin aikin da kake son ƙarawa zuwa saman shafin lokacin bugawa.
Mataki 2: Danna kan shafin fayil A saman taga.
Mataki 3: Zaɓi zaɓi bugu a kasan lissafin.
Mataki 4: Zaɓi wani zaɓi Masu kai da ƙafa a cikin ginshiƙi a gefen dama na taga.
Mataki 5: Zaɓi zaɓi Taken littafin aiki . Kuna iya danna maɓallin " na gaba saman dama na taga kuma ci gaba da buga maƙunsar rubutu.
Za a iya kiran babban layi na maƙunsar rubutu da lakabin take, saboda haka kuna iya mamakin yadda ake yin hakan.
Zan iya buga adireshi a cikin wasu aikace-aikacen Google kamar Google Docs?
Ƙara bayanai zuwa take a cikin Google Docs ya ɗan bambanta.
Tun da kuna iya shirya taken kai tsaye a cikin takaddun Google Docs, ba za ku sami duk ƙarin zaɓuɓɓukan bugu don taken da ƙafar da kuka samo a cikin Google Sheets ba.
Idan kana son ƙara take ga take a cikin Google Docs, kuna buƙatar danna sau biyu a cikin taken, sannan a buga taken daftarin aiki a cikin taken. Duk wani bayani da ka ƙara zuwa taken takaddun za a maimaita shi akan kowane shafi da aka buga na takaddar.
Google Slides ba shi da wata hanya ta ƙara bayanai a kan taken, don haka hanya mafi inganci don yin hakan wataƙila ita ce ta zuwa. Slide> Shirya jigo Sannan ƙara akwatin rubutu zuwa saman ɗaya daga cikin shimfidu da ke wurin gami da taken nunin faifai. Kuna iya danna kan nunin faifai kuma zaɓi zaɓi Slide> Layout App Kuma zaɓi shimfidar wuri tare da take.
Yadda ake ƙara layin kai a cikin Google Sheets ta hanyar saka layin maraice a saman
Idan maƙunsar rubutun ku bai riga ya sami layin kai ko jere ba amma kuna son ƙara ɗaya don ku iya ƙididdigewa akan kowane shafi, kuna iya yin mamakin yadda ake yin sa.
Idan ka danna kan layi na 1 a gefen hagu na taga, za a zaɓi duk layin farko. Sannan zaka iya danna dama akan layin da aka zaba sannan ka zabi zabin Saka 1 a sama don kara layin mara komai a saman bayanan da kake dasu.
Dole ne ku ƙara kan shafi zuwa kowace tantanin halitta a jere wanda ke bayyana nau'in bayanai a wannan shafi.
Kuna iya danna View tab a saman taga, zaɓi zaɓin Daskare, sannan zaɓi Daskare Top Row ko kowane ɗayan zaɓuɓɓukan jere daga menu na zazzagewa.
Ƙara koyo game da yadda ake saka take akan maƙunsar bayanai na Google
Matakan da ke sama suna nuna muku yadda ake canza saiti yayin bugawa a cikin Google Sheets domin an haɗa taken littafin aiki a cikin taken kowane shafi da aka buga.
Wasu daga cikin abubuwan da Google za ku iya ƙarawa zuwa adireshin sun haɗa da:
- Lambobin shafi
- Taken littafin aiki
- sunan takarda
- kwanan wata
- lokacin yanzu
Sunan littafin aikin da sunan takarda na iya zama iri ɗaya, don haka yana da amfani a san yadda Google ke bambanta su.
Taken littafin aikin fayil na Google Sheets shine sunan da ya bayyana a saman taga. Kuna iya gyara wannan a kowane lokaci ta hanyar danna shi kawai kuma canza shi yadda ake buƙata.
Sunan takardar shine sunan da ke bayyana akan shafin da ke ƙasan taga. Hakanan zaka iya danna wannan don gyara shi.
Idan kun ƙirƙiri jadawali ko ginshiƙi a cikin Google Sheets, kamar taswirar kek, to kun yi haka ta zaɓin kewayon sel a cikin maƙunsar bayanan ku kuma zaɓi salon ginshiƙi don ƙirƙirar daga waccan bayanan.
Idan kuna son canza taken ginshiƙi da Google Sheets ya yi amfani da su a kan wannan ginshiƙi, zaku iya danna take sau biyu, wanda zai buɗe ginshiƙi Editan Chart a gefen dama na taga. Sannan zaku iya zaɓar taken taswira daga jerin zaɓuka sannan shigar da taken ginshiƙi da kuka fi so a filin rubutu na take.
