{"id":217890,"date":"2022-10-21T10:19:00","date_gmt":"2022-10-21T07:19:00","guid":{"rendered":"https:\/\/goodroid.mediadoma.com\/?p=217890"},"modified":"2022-11-10T03:15:42","modified_gmt":"2022-11-10T00:15:42","slug":"pikanaeppaeimet-google-sheetsille","status":"publish","type":"post","link":"https:\/\/goodroid.mediadoma.com\/fi\/pikanaeppaeimet-google-sheetsille\/","title":{"rendered":"Pikan\u00e4pp\u00e4imet Google Sheetsille"},"content":{"rendered":"

Sanomattakin on selv\u00e4\u00e4, ett\u00e4 pikan\u00e4pp\u00e4imet<\/a> ovat loistava tapa s\u00e4\u00e4st\u00e4\u00e4 aikaa ty\u00f6skennelless\u00e4si mink\u00e4 tahansa sovelluksen parissa. Tuottavuuden ja ty\u00f6n tekemiseen tarvittavan ajan v\u00e4lill\u00e4 on suora yhteys. Tutkimukset osoittavat, ett\u00e4 pikan\u00e4pp\u00e4imet voivat lis\u00e4t\u00e4 tuottavuuttasi jopa 30 %.<\/p>\n

N\u00e4m\u00e4 pikan\u00e4pp\u00e4imet ovat l\u00e4hes samat kuin MS Office, joten ne on helppo muistaa<\/strong>. K\u00e4yt\u00e4 Mac Safari -selaimessa Command- tai Apple-n\u00e4pp\u00e4int\u00e4 Ctrl-n\u00e4pp\u00e4imen sijaan.<\/p>\n

[Katso my\u00f6s: Yleiset pikan\u00e4pp\u00e4imet Google-dokumenteille<\/a> ]<\/p>\n

Riitt\u00e4\u00e4k\u00f6 t\u00e4st\u00e4 teknisest\u00e4 puheesta, katsokaamme t\u00e4ydelliset pikan\u00e4pp\u00e4imet Google-laskentataulukoille:<\/p>\n

Liikkuminen laskentataulukoiden sis\u00e4ll\u00e4<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Siirr\u00e4 yksi solu yl\u00f6s, alas, vasemmalle tai oikealle<\/span><\/span><\/td>\nNuolin\u00e4pp\u00e4imill\u00e4<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Siirr\u00e4 yksi solu oikealle<\/span><\/span><\/td>\nTab<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Siirr\u00e4 yksi solu vasemmalle<\/span><\/span><\/td>\nVaihto+Sarkain<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Siirry rivin loppuun<\/span><\/span><\/td>\nEnd (PC)<\/span><\/span><\/strong> tai <\/span><\/span>Fn + oikea nuoli (Mac)<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Siirry data-alueen viimeiseen soluun<\/span><\/span><\/td>\nCtrl + End (PC)<\/span><\/span><\/strong> tai <\/span><\/span>Ctrl + Fn + oikea nuoli (Mac)<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Siirry rivin alkuun<\/span><\/span><\/td>\nKoti (PC)<\/span><\/span><\/strong> tai <\/span><\/span>Fn + vasen nuoli (Mac)<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Siirry laskentataulukon alkuun<\/span><\/span><\/td>\nCtrl+Home (PC)<\/span><\/span><\/strong> tai <\/span><\/span>Ctrl+Fn+vasen nuoli (Mac)<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Siirry nykyisen rivin vasemmanpuoleisimpaan soluun<\/span><\/span><\/td>\nCtrl + vasen nuoli<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Siirry nykyisen rivin oikeanpuoleisimpaan soluun<\/span><\/span><\/td>\nCtrl + oikea nuoli<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Siirry nykyisen sarakkeen alimpaan soluun<\/span><\/span><\/td>\nCtrl + alanuoli<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Siirry nykyisen sarakkeen ylimp\u00e4\u00e4n soluun<\/span><\/span><\/td>\nCtrl+nuoli yl\u00f6s<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Siirry seuraavaan taulukkoon<\/span><\/span><\/td>\nCtrl + sivu alas<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Siirry edelliseen taulukkoon<\/span><\/span><\/td>\nCtrl+Page Up<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Siirr\u00e4 yksi n\u00e4ytt\u00f6 oikealle.<\/span><\/span><\/td>\nAlt + Sivu alas<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Siirr\u00e4 yksi n\u00e4ytt\u00f6 vasemmalle<\/span><\/span><\/td>\nAlt+Page Up<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Vierit\u00e4 aktiiviseen soluun, kun useita soluja on valittu<\/span><\/span><\/td>\nCtrl+askelpalautin<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Vaihda arkkia<\/span><\/span><\/td>\nCtrl+Shift+PageUp\/Down<\/span><\/span><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Liike valitulla alueella<\/strong><\/p>\n\n\n\n\n\n\n
Siirry ylh\u00e4\u00e4lt\u00e4 alas valitulla alueella<\/span><\/span><\/td>\nTulla sis\u00e4\u00e4n<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Siirry alhaalta yl\u00f6s valitulla alueella<\/span><\/span><\/td>\nVaihto+Enter<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Siirry vasemmalta oikealle valitulla alueella. <\/span>Jos yhden sarakkeen solut on valittu, siirry alas.<\/span><\/span><\/td>\nTab<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Siirry oikealta vasemmalle valitulla alueella. <\/span>Jos yhden sarakkeen solut on valittu, siirry yl\u00f6sp\u00e4in.<\/span><\/span><\/td>\nVaihto+Sarkain<\/span><\/span><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Valitse koko laskentataulukko<\/span><\/span><\/td>\nCtrl+A<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Lihavoi valitun solun sis\u00e4lt\u00f6<\/span><\/span><\/td>\nCtrl+B<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Kopioi valitun solun sis\u00e4lt\u00f6<\/span><\/span><\/td>\nCtrl+C<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Etsi sanoja tai lauseita laskentataulukosta<\/span><\/span><\/td>\nCtrl+F<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Kursivoi valitun solun sis\u00e4lt\u00f6<\/span><\/span><\/td>\nCtrl+I<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Tulosta<\/span><\/span><\/td>\nCtrl+P<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Kopioi valitun solun sis\u00e4lt\u00f6 oikealle (k\u00e4ytet\u00e4\u00e4n yhdistelm\u00e4n\u00e4 Shift + nuoli)<\/span><\/span><\/td>\nCrtl+R<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Tallentaa<\/span><\/span><\/td>\nCtrl+S<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Alleviivaa valitun solun sis\u00e4lt\u00f6<\/span><\/span><\/td>\nCtrl+U<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Liit\u00e4 valitun solun sis\u00e4lt\u00f6<\/span><\/span><\/td>\nCtrl+V<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Leikkaa valitun solun sis\u00e4lt\u00f6<\/span><\/span><\/td>\nCtrl+X<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Toista viimeinen toiminto<\/span><\/span><\/td>\nCtrl+Y<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Kumoa viimeinen toiminto.<\/span><\/span><\/td>\nCtrl+Z<\/span><\/span><\/strong><\/td>\n<\/tr>\n
T\u00e4yt\u00e4 solumerkint\u00e4 ja valitse alla oleva solu<\/span><\/span><\/td>\nTulla sis\u00e4\u00e4n<\/span><\/span><\/strong><\/td>\n<\/tr>\n
T\u00e4yt\u00e4 solumerkint\u00e4 ja valitse edellinen solu yll\u00e4<\/span><\/span><\/td>\nVaihto+Enter<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Aloita uusi rivi samassa solussa<\/span><\/span><\/td>\nAlt+Enter<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Lis\u00e4\u00e4 rivinvaihto soluun<\/span><\/span><\/td>\nCtrl+Enter<\/span><\/span><\/strong><\/td>\n<\/tr>\n
T\u00e4ydenn\u00e4 solun sy\u00f6tt\u00f6 ja valitse seuraava solu oikealta<\/span><\/span><\/td>\nTab<\/span><\/span><\/strong><\/td>\n<\/tr>\n
T\u00e4ydenn\u00e4 solun sy\u00f6tt\u00f6 ja valitse edellinen solu vasemmalta<\/span><\/span><\/td>\nVaihto+Sarkain<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Muokkaa aktiivista solua ja sijoita lis\u00e4yskohta solun sis\u00e4ll\u00f6n loppuun<\/span><\/span><\/td>\nF2 (PC)<\/span><\/span><\/strong> tai <\/span><\/span>Enter (Mac)<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Muokkaa kommenttia<\/span><\/span><\/td>\nVaihto+F2<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Peruuta solun sy\u00f6tt\u00f6<\/span><\/span><\/td>\npoistu<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Muokkaa aktiivista solua ja tyhjenn\u00e4 se tai poista edellinen merkki aktiivisesta solusta, kun muokkaat solun sis\u00e4lt\u00f6\u00e4<\/span><\/span><\/td>\nAskelpalautin<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Poista lis\u00e4yskohdan oikealla puolella oleva merkki tai poista valinta<\/span><\/span><\/td>\nPoistaa<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Valitse koko sarake<\/span><\/span><\/td>\nCtrl+v\u00e4lily\u00f6nti<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Valitse koko rivi<\/span><\/span><\/td>\n
Vaihto+v\u00e4lily\u00f6nti<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Manuaalinen valinta<\/span><\/span><\/td>\nVaihto+alas, yl\u00f6s, vasen, oikea nuolin\u00e4pp\u00e4in<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Tee asiakirjasta kopio<\/span><\/span><\/td>\nCtrl+Shift+S<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Solun sis\u00e4ll\u00f6n yliviivausmuotoilu<\/span><\/span><\/td>\nAlt+Vaihto+5<\/span><\/span><\/strong><\/td>\n<\/tr>\n
K\u00e4yt\u00e4 reunuksen \u00e4\u00e4riviivaa valittuihin soluihin<\/span><\/span><\/td>\nAlt+Vaihto+&<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Poista reunuksen \u00e4\u00e4riviivat valituista soluista<\/span><\/span><\/td>\nAlt+Vaihto+_<\/span><\/span><\/strong><\/td>\n<\/tr>\n
K\u00e4yt\u00e4 tai poista yl\u00e4reuna valituista soluista<\/span><\/span><\/td>\nAlt+Vaihto+T<\/span><\/span><\/strong><\/td>\n<\/tr>\n
K\u00e4yt\u00e4 tai poista alareuna valituista soluista<\/span><\/span><\/td>\nAlt+Vaihto+B<\/span><\/span><\/strong><\/td>\n<\/tr>\n
K\u00e4yt\u00e4 tai poista oikea reuna valituissa soluissa<\/span><\/span><\/td>\nAlt+Vaihto+R<\/span><\/span><\/strong><\/td>\n<\/tr>\n
K\u00e4yt\u00e4 tai poista vasen reunus valituista soluista<\/span><\/span><\/td>\nAlt+Vaihto+L<\/span><\/span><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n\n\n\n
K\u00e4\u00e4ri nykyinen kaava ArrayFormulaan<\/span><\/span><\/td>\nCtrl+Shift+Enter<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Siirr\u00e4 kohdistus valikkoriville<\/span><\/span><\/td>\nAlt+Vaihto+F<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Lis\u00e4\u00e4 nykyinen p\u00e4iv\u00e4m\u00e4\u00e4r\u00e4 soluun<\/span><\/span><\/td>\nCtrl+;<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Lis\u00e4\u00e4 nykyinen aika soluun<\/span><\/span><\/td>\nCtrl+:<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Avaa pikan\u00e4pp\u00e4inten ohje<\/span><\/span><\/td>\nCtrl+\/<\/span><\/span><\/strong><\/td>\n<\/tr>\n
N\u00e4yt\u00e4 kaikki kaavat<\/span><\/span><\/td>\nCtrl+'<\/span><\/span><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

[ l\u00e4hde<\/a> ]<\/p>\n

: www.gtricks.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"

Lis\u00e4\u00e4 tuottavuuttasi Google Sheetsin Shift-, Control- ja muiden erilaisten pikan\u00e4pp\u00e4inyhdistelmien avulla.<\/p>\n","protected":false},"author":1,"featured_media":188017,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[814,677,826],"tags":[],"class_list":["post-217890","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-5","category-google-docs-4","category-oppikirjoja"],"_links":{"self":[{"href":"https:\/\/goodroid.mediadoma.com\/fi\/wp-json\/wp\/v2\/posts\/217890","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/goodroid.mediadoma.com\/fi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/goodroid.mediadoma.com\/fi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/goodroid.mediadoma.com\/fi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/goodroid.mediadoma.com\/fi\/wp-json\/wp\/v2\/comments?post=217890"}],"version-history":[{"count":0,"href":"https:\/\/goodroid.mediadoma.com\/fi\/wp-json\/wp\/v2\/posts\/217890\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/goodroid.mediadoma.com\/fi\/wp-json\/wp\/v2\/media\/188017"}],"wp:attachment":[{"href":"https:\/\/goodroid.mediadoma.com\/fi\/wp-json\/wp\/v2\/media?parent=217890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/goodroid.mediadoma.com\/fi\/wp-json\/wp\/v2\/categories?post=217890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/goodroid.mediadoma.com\/fi\/wp-json\/wp\/v2\/tags?post=217890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}