5 mau ʻōlelo aʻoaʻo a me nā hoʻopunipuni no Google Sheets ma Mac e ʻike pono i kēlā me kēia mea hoʻohana Google Sheets

Ke hoʻomau nei mākou i kā mākou moʻolelo ma nā mea hana pūnaewele a Google me kahi ʻāpana i hoʻolaʻa ʻia no ka papa hana palahalaha pūnaewele Google Sheets. E hōʻike aku mākou iā ʻoe i ʻelima mau ʻōlelo aʻoaʻo a me nā hoʻopunipuni e hiki mai ana i ka wā e hana ai me kēia lawelawe pūnaewele.

Hana pū

E like me nā lawelawe pūnaewele ʻē aʻe, hiki iā ʻoe ke hoʻohana i ka hana kaʻana like a me ka hui pū ʻana i ka hihia o Google Sheets - kaomi wale ma ka ʻaoʻao ʻākau o ka puka aniani me ka papaʻaina. Kaʻana like. E inoa i ka papaʻaina a laila v kaʻana pā kaomi ma luna "ʻO nā mea hoʻohana āpau i loaʻa kahi loulou". Hiki iā ʻoe ke hoʻonohonoho i nā ʻano kaʻana like a me nā ʻae no ka poʻe āu e kaʻana like ai i ka papaʻaina.

Photogallery

Kaʻana like ʻo Google Sheets 1

Kaʻana like ʻo Google Sheets 2

Kaʻana like ʻo Google Sheets 3

Kaʻana like ʻo Google Sheets 4

Palapala no ka akaka maikaʻi

ʻAʻole pono nā papa ma Google Sheets e hōʻike i ka ʻikepili āu e pono ai ma ke ʻano maʻamau. Inā makemake ʻoe e hoʻokaʻawale i kāu papaʻaina a i ʻole e hōʻike i ka ʻikepili ma kahi ʻano ʻokoʻa, hiki iā ʻoe ke hoʻololi iā ia i kahi pakuhi kala. He maʻalahi ke kaʻina hana - kaomi wale i ka papaʻaina me ka paʻa ʻana i ke kī Cmd kaha lā, ka mea āu e makemake ai e hoʻololi i ka pakuhi, a laila i mea hana ma ka piko o ka pukaaniani Kaomi ma Hookomo -> Palapala.

Photogallery #2

Papa palapala Google 1

Papa palapala Google 2

Papa palapala Google 3

Papa palapala Google 4

Laka pūnaewele

Inā kaʻana like ʻoe i kāu pāpalapala me nā mea hoʻohana ʻē aʻe, a ʻaʻole ʻoe makemake iā lākou e hoʻopilikia i nā cell i koho ʻia ma kekahi ʻano (hiki nō hoʻi ke hana ʻia me ka ʻole a me ka manaʻo ʻole), hiki iā ʻoe ke laka i ka ʻikepili. Hiki iā ʻoe ke hoʻopaʻa i nā cell a me ka pepa e like me ia. Ma ka mea hana ma ka piko o ka pukaaniani kaomi ma luna Mea hana -> Pale pale. Ma hope o kēlā ma ka pukaaniani e hoʻonoho i nā ʻāpana laka, a i ʻole e kāpae i nā cell āu e makemake ʻole e pale.

Photogallery #3

Palekana Google Sheets 1

Palekana Google Sheets 2

Palekana Google Sheets 3

Macros

Inā ʻoe e hana ana me nā papa no ka manawa lōʻihi a me nā kikoʻī hou aku, maopopo maoli ʻoe i ka hana macro mai, no ka laʻana, Microsoft Excel. Eia nō naʻe, hiki iā ʻoe ke hana pū me nā macros ma nā papa o ka palapala noi pūnaewele Google Sheets. Ma ka mea hana ma ka piko o ka pukaaniani kaomi ma luna Mea Hana -> Macro -> Hoʻopaʻa Macro. Hele hapa lalo o ka pukaaniani e hōʻike ʻia iā ʻoe karta, kahi āu e hoʻonoho ai i nā ʻāpana āpau a hiki iā ʻoe ke hoʻomaka e hoʻopaʻa.

Photogallery #4

Nā Macro Google Sheets 1

Nā Macro Google Sheets 2

Nā Macro Google Sheets 3

Nā Macro Google Sheets 4