Kodi mudasindikizapo spreadsheet, ndikupunthwa patatha miyezi ingapo, ndikungodabwa kuti spreadsheet inali yanji, tsiku lanji lomwe idasindikizidwa, kapena zambiri zomwe muyenera kuzisamala? Izi ndizofala, makamaka ngati nthawi zambiri mumasindikiza zosinthidwa za spreadsheet yomweyo.
Kugwira ntchito ndi ma spreadsheets, kaya mumagwiritsa ntchito njira ya Google Apps, Google Sheets, kapena Microsoft Office, Microsoft Excel, nthawi zambiri imakhala ndi magawo awiri. Gawo loyamba ndikulowetsa zonse zomwe zalowetsedwa ndikusinthidwa moyenera, ndiyeno gawo lachiwiri ndikukonza njira zonse zopangira tsamba kuti spreadsheet iwoneke bwino ikasindikizidwa.
Mafayilo a Google Mapepala ndi osavuta kusindikiza mwachisawawa, koma mapulogalamu onse awiri amafunikira kuti muwonjezere zambiri pamutu kapena kusintha zosankha zosiyanasiyana kuti kusindikiza kwa deta kukhale kosavuta kumvetsetsa.
Njira imodzi yothetsera vutoli ndikugwiritsa ntchito dzina la fayilo pamutu. Izi zimawonjezera chidziwitso patsamba lililonse lamasamba ngati masambawo atapatulidwa, pomwe amapereka chidziwitso chofunikira chomwe chingakuthandizeni kuzindikira chosindikiza pambuyo pake. Kalozera wathu pansipa akuwonetsani momwe mungawonjezerere mutu wabukhu lantchito pamutu mu Google Mapepala.
Momwe mungasindikize dzina labukhu lantchito pamwamba pa tsamba mu Google Mapepala
- Tsegulani fayilo ya spreadsheet.
- Dinani tabu fayilo .
- Pezani Sindikizani .
- Sankhani tabu Mitu ndi m'munsi .
- cheke bokosi Mutu wa buku la ntchito .
- Dinani yotsatira Ndiye Sindikizani .
Masitepe omwe ali pamwambawa akuganiza kuti mwalowa kale muakaunti ya Google yomwe ili ndi fayilo yomwe mukufuna kuwonjezera mutu pazokonda zosindikiza.
Wotsogolera wathu pansipa akupitiliza ndi zambiri zoyika adilesi pa Google spreadsheet, kuphatikiza zithunzi zamasitepewa.
Momwe mungawonjezere dzina lafayilo patsamba mukasindikiza mu Google Sheets (Guide with Pictures)
Masitepe omwe ali m'nkhaniyi akuwonetsani momwe mungasinthire makonzedwe a bukhu lanu la ntchito la Google Sheets kuti mutu wa bukhu la ntchito usindikizidwe pamutu, pa tsamba lililonse la spreadsheet. Zokonda izi zimagwira ntchito ku bukhu lantchito lomwe lilipo pano, chifukwa chake muyenera kusintha izi pamasamba ena omwe mukufuna kusindikiza dzina la fayilo.
Gawo 1: Pitani ku Google Drive pa https://drive.google.com/drive/my-drive Tsegulani fayilo yomwe dzina lake labukhu lothandizira mukufuna kuwonjezera pamwamba pa tsamba mukasindikiza.
Gawo 2: Dinani pa tabu fayilo Pamwamba pa zenera.
Gawo 3: Sankhani njira kusindikiza pansi pa mndandanda.
Gawo 4: Sankhani njira Mitu ndi m'munsi mumzati kumanja kwa zenera.
Gawo 5: Sankhani njira Mutu wa buku la ntchito . Kenako mutha dinani batani " yotsatira pamwamba kumanja kwa zenera ndi kupitiriza kusindikiza spreadsheet.
Mzere wapamwamba wa spreadsheet ukhoza kutchedwanso mzere wamutu, kotero mungakhale mukuganiza momwe mungachitire zimenezo.
Kodi ndingasindikize adilesi mu mapulogalamu ena a Google monga Google Docs?
Kuwonjezera zambiri pamutu mu Google Docs ndikosiyana pang'ono.
Popeza mutha kusintha chamutu mwachindunji muzolemba za Google Docs, simupeza zina zonse zosindikiza zapamutu ndi zapamunsi zomwe mudapeza mu Google Mapepala.
Ngati mukufuna kuwonjezera mutu pamutu mu Google Docs, muyenera kudina kawiri mkati mwamutu, kenako lembani mutu wa chikalatacho pamutu. Chidziwitso chilichonse chomwe mungawonjezere pamutu wa zikalata chidzabwerezedwanso patsamba lililonse losindikizidwa.
Google Slides ilibe njira iliyonse yowonjezerera zambiri pamutu, kotero njira yabwino kwambiri yochitira izi mwina ndi kupita Slide> Sinthani mutu Kenako onjezani bokosi lolemba pamwamba pa imodzi mwamasanjidwe apo kuphatikiza mutu wa chiwonetsero chazithunzi. Ndiye mukhoza alemba pa slide ndi kusankha njira Slide> Mawonekedwe a App Ndipo sankhani masanjidwewo ndi mutuwo.
Momwe mungawonjezere mzere wamutu mu Google Mapepala poyika mzere wopanda kanthu pamwamba
Ngati spreadsheet yanu ilibe kale mzere wamutu kapena mzere wamutu koma mukufuna kuwonjezera imodzi kuti muthe kubwereza patsamba lililonse, mutha kukhala mukuganiza momwe mungachitire.
Mukadina mutu wa 1 kumanzere kwa zenera, mzere wonse woyamba udzasankhidwa. Mutha kudina kumanja pamzere wosankhidwa ndikusankha Ikani 1 pamwamba kuti muwonjezere mzere wopanda kanthu pamwamba pa zomwe zilipo.
Kenako muyenera kuwonjezera mutu pagawo lililonse pamzerewu womwe umafotokoza mtundu wa data mugawolo.
Mutha dinani View tabu pamwamba pa zenera, sankhani Chotsani Chotsani, ndiyeno sankhani Freeze Top Row kapena mizere ina iliyonse kuchokera pamenyu yotsitsa.
Dziwani zambiri za momwe mungayikitsire mutu pa Google spreadsheet
Masitepe omwe ali pamwambawa akukuwonetsani momwe mungasinthire makonzedwe mukasindikiza mu Google Sheets kuti mutu wabukhu lantchito uphatikizidwe pamutu watsamba lililonse losindikizidwa.
Zina mwazinthu zomwe mungawonjezere Google ku adilesi ndi:
- Nambala zamasamba
- Mutu wa buku la ntchito
- dzina la pepala
- tsiku lapano
- nthawi ino
Mutu wa bukhu la ntchito ndi dzina la pepala likhoza kuwoneka mofanana, choncho ndizothandiza kudziwa momwe Google imasiyanitsira pakati pawo.
Mutu wabukhu lantchito la fayilo ya Google Sheets ndi dzina lomwe limawonekera pamwamba pawindo. Mutha kusintha izi nthawi iliyonse mwa kungodinanso ndikuzisintha momwe mungafunikire.
Dzina la pepala ndi dzina lomwe limapezeka pa tabu pansi pa zenera. Mukhozanso alemba pa izo kusintha.
Ngati mudapanga graph kapena tchati mu Google Sheets, monga tchati cha chitumbuwa, ndiye kuti mwachita izi posankha ma cell angapo mu spreadsheet yanu ndikusankha kalembedwe ka tchati kuti mupange kuchokera pa datayo.
Ngati mukufuna kusintha mutu wa tchati womwe Google Sheets wagwiritsa ntchito pa tchatichi, mutha kudina kawiri mutuwo, womwe udzatsegule ndime ya Chart Editor kumanja kwa zenera. Mutha kusankha mutu wa tchati kuchokera pamndandanda wotsitsa ndikuyika mutu womwe mumakonda patsamba lalemba lamutu.
