{"id":6529,"date":"2022-04-22T14:20:20","date_gmt":"2022-04-22T17:20:20","guid":{"rendered":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/22\/30-google-sheets-shortcuts-marketers-need-to-know\/"},"modified":"2022-04-22T14:20:20","modified_gmt":"2022-04-22T17:20:20","slug":"30-google-sheets-shortcuts-marketers-need-to-know","status":"publish","type":"post","link":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/22\/30-google-sheets-shortcuts-marketers-need-to-know\/","title":{"rendered":"30 Google Sheets Shortcuts Marketers Need to Know"},"content":{"rendered":"<p>As a marketer, you already know you love Google Sheets for storing data, tracking performance metrics, and creating collaborative reports. But are using the full arsenal of Google Sheets shortcuts available to streamline your workflow and save valuable time?<\/p>\n<\/p>\n<p>Whether you\u2019re experienced with Google Sheets or you\u2019re just getting started, you\u2019ll be happy to know there are many simple and time-saving Google Sheets keyboard shortcuts at your disposal.<\/p>\n<p>Keeping track of the numerous keyboard shortcuts may sound daunting but, luckily, I\u2019m here with a list of Google Sheets shortcuts you can bookmark and return to again and again.<\/p>\n<p><a class=\"cta_button\" href=\"https:\/\/www.hubspot.com\/cs\/ci\/?pg=e7cd3f82-cab9-4017-b019-ee3fc550e0b5&amp;pid=53&amp;ecid=&amp;hseid=&amp;hsic=\"><\/a><\/p>\n<h2>30 Google Sheets Keyboard Shortcuts<\/h2>\n<h3>1. Select column<\/h3>\n<p>Ctrl + Space (PC and Mac)<\/p>\n<h3>2. Insert columns to the left<\/h3>\n<p>Alt + i, then C (PC), Ctrl + Options + i, then C (Mac)<\/p>\n<h3>3. Insert columns to the right<\/h3>\n<p>Alt + i, then O (PC), Ctrl + Option + i, then O (Mac)<\/p>\n<h3>4. Select row<\/h3>\n<p>Shift + Space (PC and Mac)<\/p>\n<h3>5. Insert rows above<\/h3>\n<p>Alt + i, then R (PC), Ctrl + Option + i, then R (Mac)<\/p>\n<h3>6. Insert rows below<\/h3>\n<p>Alt + i, then W (PC), Ctrl + Option + i, then B (Mac)<\/p>\n<p><span><\/span><\/p>\n<h3>7. Select all<\/h3>\n<p>Ctrl + A (PC), Command + A (Mac)<\/p>\n<h3>8. Fill range<\/h3>\n<p>Ctrl + Enter (PC), Command + Enter (Mac)<\/p>\n<h3>9. Fill down<\/h3>\n<p>Ctrl + D (PC), Command + D (Mac)<\/p>\n<h3>10. Fill right<\/h3>\n<p>Ctrl + R (PC), Command + R (Mac)<\/p>\n<p><span><\/span><\/p>\n<h3>11. Save<\/h3>\n<p>Ctrl + S (PC), Command + S (Mac)<\/p>\n<h3>12. Open<\/h3>\n<p>Ctrl + O (PC), Command + O (Mac)<\/p>\n<h3>13. Paste values<\/h3>\n<p>Ctrl + Shift + V (PC), Command + Shift + V (Mac)<\/p>\n<\/p>\n<h3>14. Insert new sheet<\/h3>\n<p>Shift + F11(PC), Shift + Fn + F11 (Mac)<\/p>\n<h3>15. Insert time<\/h3>\n<p>Ctrl + Shift + ; (PC), Command + Shift +; (Mac)<\/p>\n<h3>16. Insert date<\/h3>\n<p>Ctrl + ; (PC) , Command + ; (Mac)<\/p>\n<h3>17. Insert date and time<\/h3>\n<p>Ctrl + Alt + Shift + ; (PC), Command + Option + Shift + ; (Mac)<\/p>\n<p><span><\/span><\/p>\n<h3>18. Format as decimals<\/h3>\n<p>Ctrl + Shift + 1 (PC and Mac)<\/p>\n<h3>19. Format as time<\/h3>\n<p>Ctrl + Shift + 2 (PC and Mac)<\/p>\n<h3>20. Format as date<\/h3>\n<p>Ctrl + Shift + 3 (PC and Mac)<\/p>\n<h3>21. Format as currency<\/h3>\n<p>Ctrl + Shift + 4 (PC and Mac)<\/p>\n<h3>22. Format as percentage<\/h3>\n<p>Ctrl + Shift + 5 (PC and Mac)<\/p>\n<h3>23. Clear formatting<\/h3>\n<p>Ctrl +  (PC), Command +  (Mac)<\/p>\n<p><span><\/span><\/p>\n<h3>24. Show all formulas<\/h3>\n<p>Ctrl + ~ (PC and Mac)<\/p>\n<h3>25. Insert array formula<\/h3>\n<p>Ctrl + Shift + Enter (PC), Command + Shift + Enter (Mac)<\/p>\n<h3>26. Collapse an expanded array formula<\/h3>\n<p>Ctrl + E (PC), Command + E (Mac)<\/p>\n<h3>27. Show\/Hide Formula Help<\/h3>\n<p>Shift + F1 (PC), Shift + Fn + F1 (Mac)<\/p>\n<h3>28. Full Compact Formula Help<\/h3>\n<p>F1 (PC), Fn + F1 (Mac)<\/p>\n<h3>29. Absolute\/relative references<\/h3>\n<p>F4 (PC), Fn + F4 (Mac)<\/p>\n<h3>30. Toggle Formula<\/h3>\n<p>F9 (PC), Fn + F9 (Mac)<\/p>\n<p><span><\/span><\/p>\n<h2>An Alternative to Google Sheets Custom Keyboard Shortcuts<\/h2>\n<p>In the past, Google Sheets custom keyboard shortcuts were an option users could perform to customize their shortcuts in a way that suited them best. However, nowadays custom keyboard shortcuts in Google Sheets are not an option.<span><\/span><\/p>\n<p>But don\u2019t worry! Another feature that can help you further streamline your work in Google Sheets is the ability to use compatible keyboard shortcuts from other digital spreadsheets, like Excel, in Google Sheets.<span><\/span><\/p>\n<p>To do this, press Ctrl + \/ then click the button next to \u201cEnable compatible spreadsheet shortcuts.\u201d<\/p>\n<\/p>\n<p>Afterward, you\u2019ll have more than 100 new keyboard shortcuts you can use to record and sort your data in Google Sheets.<\/p>\n<h2>Work Smarter, Not Harder, with Google Sheets Keyboard Shortcuts<\/h2>\n<p>Keyboard shortcuts allow you, as a busy marketer, to streamline your workflow and cut down on the time it takes to record and sort data in Google Sheets. Best of all, these shortcuts are easy to implement whether you\u2019re on a Mac or PC.<\/p>\n<p>Not only will these time-saving shortcuts make data recording more convenient, they\u2019ll also allow you to spend more time focusing on other tasks \u2014because, let\u2019s face it, a marketer\u2019s work is never done.<\/p>\n<p><a class=\"cta_button\" href=\"https:\/\/www.hubspot.com\/cs\/ci\/?pg=0cedc81d-d358-4517-bd55-4a26f49c5a4e&amp;pid=53&amp;ecid=&amp;hseid=&amp;hsic=\"><\/a><\/p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>As a marketer, you already know you love Google Sheets for storing data, tracking performance metrics, and creating collaborative reports. But are using the full arsenal of Google Sheets shortcuts available to streamline your workflow and save valuable time? Whether you\u2019re experienced with Google Sheets or you\u2019re just getting started, you\u2019ll be happy to know [&hellip;]<\/p>\n","protected":false},"author":0,"featured_media":6530,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-6529","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-noticias-marketing"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":6}},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>30 Google Sheets Shortcuts Marketers Need to Know - Contabilidade Caxias<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/22\/30-google-sheets-shortcuts-marketers-need-to-know\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"30 Google Sheets Shortcuts Marketers Need to Know - Contabilidade Caxias\" \/>\n<meta property=\"og:description\" content=\"As a marketer, you already know you love Google Sheets for storing data, tracking performance metrics, and creating collaborative reports. But are using the full arsenal of Google Sheets shortcuts available to streamline your workflow and save valuable time? Whether you\u2019re experienced with Google Sheets or you\u2019re just getting started, you\u2019ll be happy to know [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/22\/30-google-sheets-shortcuts-marketers-need-to-know\/\" \/>\n<meta property=\"og:site_name\" content=\"Contabilidade Caxias\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-22T17:20:20+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/22\\\/30-google-sheets-shortcuts-marketers-need-to-know\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/22\\\/30-google-sheets-shortcuts-marketers-need-to-know\\\/\"},\"author\":{\"name\":\"\",\"@id\":\"\"},\"headline\":\"30 Google Sheets Shortcuts Marketers Need to Know\",\"datePublished\":\"2022-04-22T17:20:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/22\\\/30-google-sheets-shortcuts-marketers-need-to-know\\\/\"},\"wordCount\":594,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/22\\\/30-google-sheets-shortcuts-marketers-need-to-know\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/e7cd3f82-cab9-4017-b019-ee3fc550e0b5-gWWwuj.png\",\"articleSection\":[\"Marketing\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/22\\\/30-google-sheets-shortcuts-marketers-need-to-know\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/22\\\/30-google-sheets-shortcuts-marketers-need-to-know\\\/\",\"url\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/22\\\/30-google-sheets-shortcuts-marketers-need-to-know\\\/\",\"name\":\"30 Google Sheets Shortcuts Marketers Need to Know - Contabilidade Caxias\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/22\\\/30-google-sheets-shortcuts-marketers-need-to-know\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/22\\\/30-google-sheets-shortcuts-marketers-need-to-know\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/e7cd3f82-cab9-4017-b019-ee3fc550e0b5-gWWwuj.png\",\"datePublished\":\"2022-04-22T17:20:20+00:00\",\"author\":{\"@id\":\"\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/22\\\/30-google-sheets-shortcuts-marketers-need-to-know\\\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/22\\\/30-google-sheets-shortcuts-marketers-need-to-know\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/22\\\/30-google-sheets-shortcuts-marketers-need-to-know\\\/#primaryimage\",\"url\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/e7cd3f82-cab9-4017-b019-ee3fc550e0b5-gWWwuj.png\",\"contentUrl\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/wp-content\\\/uploads\\\/2022\\\/04\\\/e7cd3f82-cab9-4017-b019-ee3fc550e0b5-gWWwuj.png\",\"width\":443,\"height\":59},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/index.php\\\/2022\\\/04\\\/22\\\/30-google-sheets-shortcuts-marketers-need-to-know\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"30 Google Sheets Shortcuts Marketers Need to Know\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/#website\",\"url\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/\",\"name\":\"Contabilidade Caxias\",\"description\":\"Site especializado em Contabilidade para Caxias.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/contabilidadecaxias.com.br\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"30 Google Sheets Shortcuts Marketers Need to Know - Contabilidade Caxias","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/22\/30-google-sheets-shortcuts-marketers-need-to-know\/","og_locale":"pt_BR","og_type":"article","og_title":"30 Google Sheets Shortcuts Marketers Need to Know - Contabilidade Caxias","og_description":"As a marketer, you already know you love Google Sheets for storing data, tracking performance metrics, and creating collaborative reports. But are using the full arsenal of Google Sheets shortcuts available to streamline your workflow and save valuable time? Whether you\u2019re experienced with Google Sheets or you\u2019re just getting started, you\u2019ll be happy to know [&hellip;]","og_url":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/22\/30-google-sheets-shortcuts-marketers-need-to-know\/","og_site_name":"Contabilidade Caxias","article_published_time":"2022-04-22T17:20:20+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. tempo de leitura":"3 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/22\/30-google-sheets-shortcuts-marketers-need-to-know\/#article","isPartOf":{"@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/22\/30-google-sheets-shortcuts-marketers-need-to-know\/"},"author":{"name":"","@id":""},"headline":"30 Google Sheets Shortcuts Marketers Need to Know","datePublished":"2022-04-22T17:20:20+00:00","mainEntityOfPage":{"@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/22\/30-google-sheets-shortcuts-marketers-need-to-know\/"},"wordCount":594,"commentCount":0,"image":{"@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/22\/30-google-sheets-shortcuts-marketers-need-to-know\/#primaryimage"},"thumbnailUrl":"https:\/\/contabilidadecaxias.com.br\/wp-content\/uploads\/2022\/04\/e7cd3f82-cab9-4017-b019-ee3fc550e0b5-gWWwuj.png","articleSection":["Marketing"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/22\/30-google-sheets-shortcuts-marketers-need-to-know\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/22\/30-google-sheets-shortcuts-marketers-need-to-know\/","url":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/22\/30-google-sheets-shortcuts-marketers-need-to-know\/","name":"30 Google Sheets Shortcuts Marketers Need to Know - Contabilidade Caxias","isPartOf":{"@id":"https:\/\/contabilidadecaxias.com.br\/#website"},"primaryImageOfPage":{"@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/22\/30-google-sheets-shortcuts-marketers-need-to-know\/#primaryimage"},"image":{"@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/22\/30-google-sheets-shortcuts-marketers-need-to-know\/#primaryimage"},"thumbnailUrl":"https:\/\/contabilidadecaxias.com.br\/wp-content\/uploads\/2022\/04\/e7cd3f82-cab9-4017-b019-ee3fc550e0b5-gWWwuj.png","datePublished":"2022-04-22T17:20:20+00:00","author":{"@id":""},"breadcrumb":{"@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/22\/30-google-sheets-shortcuts-marketers-need-to-know\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/22\/30-google-sheets-shortcuts-marketers-need-to-know\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/22\/30-google-sheets-shortcuts-marketers-need-to-know\/#primaryimage","url":"https:\/\/contabilidadecaxias.com.br\/wp-content\/uploads\/2022\/04\/e7cd3f82-cab9-4017-b019-ee3fc550e0b5-gWWwuj.png","contentUrl":"https:\/\/contabilidadecaxias.com.br\/wp-content\/uploads\/2022\/04\/e7cd3f82-cab9-4017-b019-ee3fc550e0b5-gWWwuj.png","width":443,"height":59},{"@type":"BreadcrumbList","@id":"https:\/\/contabilidadecaxias.com.br\/index.php\/2022\/04\/22\/30-google-sheets-shortcuts-marketers-need-to-know\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/contabilidadecaxias.com.br\/"},{"@type":"ListItem","position":2,"name":"30 Google Sheets Shortcuts Marketers Need to Know"}]},{"@type":"WebSite","@id":"https:\/\/contabilidadecaxias.com.br\/#website","url":"https:\/\/contabilidadecaxias.com.br\/","name":"Contabilidade Caxias","description":"Site especializado em Contabilidade para Caxias.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/contabilidadecaxias.com.br\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"}]}},"_links":{"self":[{"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/posts\/6529","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/comments?post=6529"}],"version-history":[{"count":0,"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/posts\/6529\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/media\/6530"}],"wp:attachment":[{"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=6529"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/categories?post=6529"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/contabilidadecaxias.com.br\/index.php\/wp-json\/wp\/v2\/tags?post=6529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}