{"id":217814,"date":"2022-10-21T10:00:00","date_gmt":"2022-10-21T07:00:00","guid":{"rendered":"https:\/\/goodroid.mediadoma.com\/?p=217814"},"modified":"2022-11-10T02:52:39","modified_gmt":"2022-11-09T23:52:39","slug":"genvaegstangenter-foer-google-sheets","status":"publish","type":"post","link":"https:\/\/goodroid.mediadoma.com\/sv\/genvaegstangenter-foer-google-sheets\/","title":{"rendered":"Genv\u00e4gstangenter f\u00f6r Google Sheets"},"content":{"rendered":"

Naturligtvis \u00e4r kortkommandon<\/a> ett utm\u00e4rkt s\u00e4tt att spara tid n\u00e4r du arbetar med alla program. Det finns ett direkt samband mellan produktivitet och tid som kr\u00e4vs f\u00f6r att utf\u00f6ra ett jobb. Forskning visar att kortkommandon kan \u00f6ka din produktivitet med upp till 30 %.<\/p>\n

Dessa kortkommandon \u00e4r n\u00e4stan samma som MS Office, vilket g\u00f6r dem l\u00e4tta att komma ih\u00e5g<\/strong>. F\u00f6r Mac Safari-webbl\u00e4saren, anv\u00e4nd Kommando- eller Apple-tangenten ist\u00e4llet f\u00f6r Ctrl-tangenten.<\/p>\n

[Se \u00e4ven: Allm\u00e4nna kortkommandon f\u00f6r Google Dokument<\/a> ]<\/p>\n

Nog om det h\u00e4r tekniska snacket, l\u00e5t oss se kompletta kortkommandon f\u00f6r Google Spreadsheets:<\/p>\n

R\u00f6relse inom arbetsblad<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Flytta en cell upp, ner, v\u00e4nster eller h\u00f6ger<\/span><\/span><\/td>\nPiltangenter<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Flytta en cell \u00e5t h\u00f6ger<\/span><\/span><\/td>\nFlik<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Flytta en cell till v\u00e4nster<\/span><\/span><\/td>\nSkift+Tabb<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Flytta till slutet av raden<\/span><\/span><\/td>\nEnd (PC)<\/span><\/span><\/strong> eller <\/span><\/span>Fn+h\u00f6gerpil (Mac)<\/span><\/span><\/strong><\/td>\n<\/tr>\n
G\u00e5 till sista cellen i dataomr\u00e5det<\/span><\/span><\/td>\nCtrl+End (PC)<\/span><\/span><\/strong> eller <\/span><\/span>Ctrl+Fn+h\u00f6gerpil (Mac)<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Flytta till b\u00f6rjan av raden<\/span><\/span><\/td>\nHem (PC)<\/span><\/span><\/strong> eller <\/span><\/span>Fn+v\u00e4nsterpil (Mac)<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Flytta till b\u00f6rjan av kalkylbladet<\/span><\/span><\/td>\nCtrl+Hem (PC)<\/span><\/span><\/strong> eller <\/span><\/span>Ctrl+Fn+v\u00e4nsterpil (Mac)<\/span><\/span><\/strong><\/td>\n<\/tr>\n
G\u00e5 till cellen l\u00e4ngst till v\u00e4nster i den aktuella raden<\/span><\/span><\/td>\nCtrl+v\u00e4nsterpil<\/span><\/span><\/strong><\/td>\n<\/tr>\n
G\u00e5 till cellen l\u00e4ngst till h\u00f6ger i den aktuella raden<\/span><\/span><\/td>\nCtrl+h\u00f6gerpil<\/span><\/span><\/strong><\/td>\n<\/tr>\n
G\u00e5 till den nedersta cellen i aktuell kolumn<\/span><\/span><\/td>\nCtrl+ned\u00e5tpil<\/span><\/span><\/strong><\/td>\n<\/tr>\n
G\u00e5 till den \u00f6versta cellen i aktuell kolumn<\/span><\/span><\/td>\nCtrl+upp\u00e5tpil<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Flytta till n\u00e4sta arbetsblad<\/span><\/span><\/td>\nCtrl+Page Down<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Flytta till f\u00f6reg\u00e5ende arbetsblad<\/span><\/span><\/td>\nCtrl+Page Up<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Flytta en sk\u00e4rm till h\u00f6ger.<\/span><\/span><\/td>\nAlt+Page Down<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Flytta en sk\u00e4rm till v\u00e4nster<\/span><\/span><\/td>\nAlt+Page Up<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Bl\u00e4ddra till den aktiva cellen n\u00e4r flera celler \u00e4r markerade<\/span><\/span><\/td>\nCtrl+Backsteg<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Byt ark<\/span><\/span><\/td>\nCtrl+Skift+PageUp\/Down<\/span><\/span><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

R\u00f6relse inom ett valt omr\u00e5de<\/strong><\/p>\n\n\n\n\n\n\n
Flytta uppifr\u00e5n och ner inom det valda omr\u00e5det<\/span><\/span><\/td>\nStiga p\u00e5<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Flytta fr\u00e5n botten till toppen inom det valda omr\u00e5det<\/span><\/span><\/td>\nSkift+Enter<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Flytta fr\u00e5n v\u00e4nster till h\u00f6ger inom det valda omr\u00e5det. <\/span>Om celler i en enda kolumn \u00e4r markerade, flytta ned\u00e5t.<\/span><\/span><\/td>\nFlik<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Flytta fr\u00e5n h\u00f6ger till v\u00e4nster inom det valda omr\u00e5det. <\/span>Om celler i en enda kolumn \u00e4r markerade flyttar du upp\u00e5t.<\/span><\/span><\/td>\nSkift+Tabb<\/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
V\u00e4lj hela arbetsbladet<\/span><\/span><\/td>\nCtrl+A<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Fet inneh\u00e5llet i den markerade cellen<\/span><\/span><\/td>\nCtrl+B<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Kopiera inneh\u00e5llet i den markerade cellen<\/span><\/span><\/td>\nCtrl+C<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Hitta ord eller fraser i kalkylarket<\/span><\/span><\/td>\nCtrl+F<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Kursivera inneh\u00e5llet i den markerade cellen<\/span><\/span><\/td>\nCtrl+I<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Skriva ut<\/span><\/span><\/td>\nCtrl+P<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Kopiera inneh\u00e5llet i den markerade cellen till h\u00f6ger (anv\u00e4nds i kombination med Skift + pil)<\/span><\/span><\/td>\nCrtl+R<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Spara<\/span><\/span><\/td>\nCtrl+S<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Understryka inneh\u00e5llet i den markerade cellen<\/span><\/span><\/td>\nCtrl+U<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Klistra in inneh\u00e5llet i den markerade cellen<\/span><\/span><\/td>\nCtrl+V<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Klipp ut inneh\u00e5llet i den markerade cellen<\/span><\/span><\/td>\nCtrl+X<\/span><\/span><\/strong><\/td>\n<\/tr>\n
G\u00f6r om den senaste \u00e5tg\u00e4rden<\/span><\/span><\/td>\nCtrl+Y<\/span><\/span><\/strong><\/td>\n<\/tr>\n
\u00c5ngra den senaste \u00e5tg\u00e4rden.<\/span><\/span><\/td>\nCtrl+Z<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Fyll i en cellpost och v\u00e4lj cellen nedan<\/span><\/span><\/td>\nStiga p\u00e5<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Fyll i en cellpost och v\u00e4lj f\u00f6reg\u00e5ende cell ovan<\/span><\/span><\/td>\nSkift+Enter<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Starta en ny rad i samma cell<\/span><\/span><\/td>\nAlt+Enter<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Infoga radbrytning i en cell<\/span><\/span><\/td>\nCtrl+Enter<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Fyll i en cellpost och v\u00e4lj n\u00e4sta cell till h\u00f6ger<\/span><\/span><\/td>\nFlik<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Fyll i en cellpost och v\u00e4lj f\u00f6reg\u00e5ende cell till v\u00e4nster<\/span><\/span><\/td>\nSkift+Tabb<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Redigera den aktiva cellen och placera ins\u00e4ttningspunkten i slutet av cellinneh\u00e5llet<\/span><\/span><\/td>\nF2 (PC)<\/span><\/span><\/strong> eller <\/span><\/span>Enter (Mac)<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Redigera kommentar<\/span><\/span><\/td>\nSkift+F2<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Avbryt cellinmatning<\/span><\/span><\/td>\nEsc<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Redigera den aktiva cellen och rensa den, eller ta bort f\u00f6reg\u00e5ende tecken i den aktiva cellen n\u00e4r du redigerar cellinneh\u00e5llet<\/span><\/span><\/td>\nBacksteg<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Ta bort tecknet till h\u00f6ger om ins\u00e4ttningspunkten eller ta bort markeringen<\/span><\/span><\/td>\nRadera<\/span><\/span><\/strong><\/td>\n<\/tr>\n
V\u00e4lj hela kolumnen<\/span><\/span><\/td>\nCtrl+mellanslag<\/span><\/span><\/strong><\/td>\n<\/tr>\n
V\u00e4lj hela raden<\/span><\/span><\/td>\n
Skift+mellanslagstangenten<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Manuellt val<\/span><\/span><\/td>\nSkift+ned, upp, v\u00e4nster, h\u00f6ger piltangent<\/span><\/span><\/strong><\/td>\n<\/tr>\n
G\u00f6r en kopia av dokumentet<\/span><\/span><\/td>\nCtrl+Skift+S<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Genomstruken formatering f\u00f6r inneh\u00e5llet i cellen<\/span><\/span><\/td>\nAlt+Skift+5<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Anv\u00e4nd ramkontur p\u00e5 markerade celler<\/span><\/span><\/td>\nAlt+Skift+&<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Ta bort ramkontur fr\u00e5n markerade celler<\/span><\/span><\/td>\nAlt+Skift+_<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Anv\u00e4nd eller ta bort den \u00f6vre kanten fr\u00e5n de markerade cellerna<\/span><\/span><\/td>\nAlt+Skift+T<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Anv\u00e4nd eller ta bort den nedre kanten fr\u00e5n de markerade cellerna<\/span><\/span><\/td>\nAlt+Skift+B<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Anv\u00e4nd eller ta bort h\u00f6ger kant fr\u00e5n de markerade cellerna<\/span><\/span><\/td>\nAlt+Skift+R<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Anv\u00e4nd eller ta bort v\u00e4nster kant fr\u00e5n de markerade cellerna<\/span><\/span><\/td>\nAlt+Skift+L<\/span><\/span><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n\n\n\n
Sl\u00e5 in aktuell formel i en ArrayFormula<\/span><\/span><\/td>\nCtrl+Skift+Enter<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Flytta fokus till menyraden<\/span><\/span><\/td>\nAlt+Skift+F<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Infoga aktuellt datum i cellen<\/span><\/span><\/td>\nCtrl+;<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Infoga aktuell tid i cellen<\/span><\/span><\/td>\nCtrl+:<\/span><\/span><\/strong><\/td>\n<\/tr>\n
\u00d6ppna kortkommandon hj\u00e4lp<\/span><\/span><\/td>\nCtrl+\/<\/span><\/span><\/strong><\/td>\n<\/tr>\n
Visa alla formler<\/span><\/span><\/td>\nCtrl+'<\/span><\/span><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

[ k\u00e4lla<\/a> ]<\/p>\n

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

\u00d6ka din produktivitet med shift, kontroll och andra olika kombinationer av kortkommandon p\u00e5 Google Sheets.<\/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":[819,682,830],"tags":[],"class_list":["post-217814","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-10","category-google-docs-9","category-larobocker"],"_links":{"self":[{"href":"https:\/\/goodroid.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts\/217814","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/goodroid.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/goodroid.mediadoma.com\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/goodroid.mediadoma.com\/sv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/goodroid.mediadoma.com\/sv\/wp-json\/wp\/v2\/comments?post=217814"}],"version-history":[{"count":0,"href":"https:\/\/goodroid.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts\/217814\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/goodroid.mediadoma.com\/sv\/wp-json\/wp\/v2\/media\/188017"}],"wp:attachment":[{"href":"https:\/\/goodroid.mediadoma.com\/sv\/wp-json\/wp\/v2\/media?parent=217814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/goodroid.mediadoma.com\/sv\/wp-json\/wp\/v2\/categories?post=217814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/goodroid.mediadoma.com\/sv\/wp-json\/wp\/v2\/tags?post=217814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}