5 matipi uye matipi eGoogle Sheets paMac ayo mushandisi weGoogle Sheets anofanira kuziva

Isu tinoenderera mberi nehurongwa hwedu paGoogle zvishandiso zvepamhepo nechidimbu chakatsaurirwa kune online spreadsheet processor Google Sheets. Isu tichakuzivisa iwe kune mashanu matipi uye matipi anozonyatso shanda kana uchishanda newebhu sevhisi.

Kubatana

Semamwe ese ese masevhisi epamhepo, iwe unogona zvakare kushandisa kugovera uye kubatana basa mune yeGoogle Sheets - ingodzvanya pakona yepamusoro yekurudyi yehwindo netafura. Share. Doma tafura uyezve v kugovera tab tinya pa "Vese vashandisi vane chinongedzo". Iwe unogona ipapo kuseta nzira dzekugovana uye mvumo kune avo vaunogovana navo tafura.

Photogallery

Google Sheets yakagovaniswa 1

Google Sheets yakagovaniswa 2

Google Sheets yakagovaniswa 3

Google Sheets yakagovaniswa 4

Chati yekujekesa zviri nani

Matafura muGoogle Sheets haafanire kuratidza iyo data yaunoda nenzira yechinyakare. Kana iwe uchida kuita kuti tafura yako ive yakakosha kana kupa iyo data mune imwe fomu, unogona kuishandura kuita cheti yemavara. Maitiro acho ari nyore - ingobaya patafura uchibata pasi Cmd kiyi maka misi, iyo yaunoda kushandura kuita girafu, uyezve ku toolbar kumusoro kwehwindo Dzvanya pa Isa -> Chati.

Photogallery #2

Google Sheets chati 1

Google Sheets chati 2

Google Sheets chati 3

Google Sheets chati 4

Kuvhara kwesero

Kana iwewo uchigovera spreadsheet yako nevamwe vashandisi, uye iwe usingadi kuti vavhiringidze masero akasarudzwa nenzira ipi zvayo (iyo inogonawo kuitika zvachose nengozi uye nekusaziva), unogona kuvhara data. Iwe unogona kukiya ese ari maviri maseru uye pepa saizvozvo. On toolbar kumusoro kwehwindo tinya pa Zvishandiso -> Dzivirira pepa. Mushure maizvozvo pahwindo isa ma parameter ekukiya, kana kusabvisa maseru ausingade kudzivirira.

Photogallery #3

Google Sheets inodzivirira pepa 1

Google Sheets inodzivirira pepa 2

Google Sheets inodzivirira pepa 3

Macros

Kana wanga uchishanda nematafura kwenguva yakareba uye zvakadzama, iwe zvechokwadi unojairana nebasa guru kubva, semuenzaniso, Microsoft Excel. Nekudaro, iwe unogona zvakare kushanda nema macros mumatafura eGoogle Sheets web application. On toolbar kumusoro kwehwindo tinya pa Zvishandiso -> Macros -> Rekodha Macro. Enda chikamu chezasi chehwindo zvicharatidzwa kwamuri karta, kwaunoseta ese ma parameter uye iwe unogona kutanga kurekodha.

Photogallery #4

Google Sheets Macros 1

Google Sheets Macros 2

Google Sheets Macros 3

Google Sheets Macros 4