{"id":607,"date":"2023-10-20T00:30:00","date_gmt":"2023-10-20T00:30:00","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/banda\/"},"modified":"2023-12-06T11:51:31","modified_gmt":"2023-12-06T11:51:31","slug":"banda","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/banda\/","title":{"rendered":"Qual \u00e9 o atalho de teclado para grupo no excel?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-2746044625\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><div class=\"excel-before-content\" id=\"excel-818428094\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Agrupar no Excel \u00e9 um recurso usado para agrupar linhas e colunas. Se voc\u00ea trabalha com grandes conjuntos de dados, nunca sentiu a necessidade de agrupar linhas e\/ou colunas em grupos para ocultar grupos de linhas ou colunas e tornar os dados mais eficientes.<\/p><p> Usando este recurso de grupo, voc\u00ea pode criar v\u00e1rios grupos adicionando diferentes linhas ou colunas selecionadas nesses grupos e, como outros recursos do Excel, voc\u00ea pode fazer isso manualmente ou usando o atalho do teclado.<\/p><p> Se voc\u00ea adora atalhos, este tutorial o ajudar\u00e1 a aprender como agrupar linhas e colunas usando o atalho do teclado.<\/p><h2 class=\"wp-block-heading\"> Atalho de teclado para agrupar no Excel<\/h2><p> <kbd>Alt<\/kbd> + <kbd>Shift<\/kbd> + <kbd>\u279e<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70444\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-pour-le-regroupement.png\" sizes=\"auto, \" srcset=\"\" alt=\"tecla de atalho para agrupamento\" width=\"724\" height=\"284\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Etapas para agrupar linhas ou colunas usando um atalho de teclado<\/h2><ol><li> Primeiro, selecione as linhas ou colunas que deseja agrupar. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-selecionar linhas para agrupamento\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-lignes-de-selection-pour-le-regroupement.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-rows-for-grouping\" width=\"534\" height=\"200\"><\/li><li> Depois disso, pressione as teclas \u201cAlt + Shift + \u279e (Seta para a direita)\u201d e voc\u00ea agrupar\u00e1 as linhas ou colunas selecionadas.<\/li><li> Agora, para recolher as linhas agrupadas, voc\u00ea pode ir para qualquer c\u00e9lula nas linhas agrupadas e pressionar as teclas \u201cAlt \u2192 A \u2192 H\u201d e seu grupo ser\u00e1 recolhido e as linhas ocultadas.<\/li><li> Ou voc\u00ea pode clicar nos sinais de agrupamento (-) na barra esquerda da planilha para recolher as linhas agrupadas. <br><img loading=\"lazy\" decoding=\"async\" title=\"3 linhas agrupadas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-rangees-groupees.png\" sizes=\"auto, \" srcset=\"\" alt=\"grouped-rows\" width=\"572\" height=\"199\"><\/li><li> Para expandir as linhas agrupadas, v\u00e1 at\u00e9 a linha agrupada e pressione as teclas \u201cAlt \u2192 A \u2192 H\u201d ou pressione o sinal (+) e seu grupo ser\u00e1 expandido. <br><img loading=\"lazy\" decoding=\"async\" title=\"4 linhas agrupadas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-rangees-groupees-collees.png\" sizes=\"auto, \" srcset=\"\" alt=\"collaped-grouped-rows\" width=\"616\" height=\"100\"><\/li><\/ol><p> Se voc\u00ea selecionar apenas as c\u00e9lulas em vez de selecionar as linhas ou colunas inteiras, ao pressionar as teclas \u201cAlt + Shift + \u279e\u201d, ser\u00e1 exibido um pop-up solicitando que voc\u00ea selecione a op\u00e7\u00e3o de linhas ou colunas para agrupamento. <\/p><div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70448\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Boite-de-dialogue-a-5-groupes.png\" sizes=\"auto, \" srcset=\"\" alt=\"di\u00e1logo de grupo\" width=\"200\" height=\"156\"><\/figure><\/div><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Mais tutoriais <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-19\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/pt\/fechar\/\">Fechar<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/tela-cheia\/\">Tela cheia<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/visualizacao-de-impressao-1\/\">Visualizar antes de imprimir<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-607","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Qual \u00e9 o atalho de teclado para grupo no Excel?<\/title>\n<meta name=\"description\" content=\"Neste tutorial, voc\u00ea aprender\u00e1 como usar um atalho de teclado para agrupar linhas e colunas no Excel.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/pt\/banda\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Qual \u00e9 o atalho de teclado para grupo no Excel?\" \/>\n<meta property=\"og:description\" content=\"Neste tutorial, voc\u00ea aprender\u00e1 como usar um atalho de teclado para agrupar linhas e colunas no Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/banda\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:51:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-pour-le-regroupement.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tempo estimado de leitura\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/banda\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/banda\/\",\"name\":\"Qual \u00e9 o atalho de teclado para grupo no Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/banda\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/banda\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-pour-le-regroupement.png\",\"datePublished\":\"2023-10-20T00:30:00+00:00\",\"dateModified\":\"2023-12-06T11:51:31+00:00\",\"description\":\"Neste tutorial, voc\u00ea aprender\u00e1 como usar um atalho de teclado para agrupar linhas e colunas no Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/banda\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/banda\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/banda\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-pour-le-regroupement.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-pour-le-regroupement.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/banda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Qual \u00e9 o atalho de teclado para grupo no excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"name\":\"Excel Advisor\",\"description\":\"O seu guia definitivo para dominar os dados!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-PT\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/pt\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Qual \u00e9 o atalho de teclado para grupo no Excel?","description":"Neste tutorial, voc\u00ea aprender\u00e1 como usar um atalho de teclado para agrupar linhas e colunas no Excel.","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:\/\/exceladvisor.org\/pt\/banda\/","og_locale":"pt_PT","og_type":"article","og_title":"Qual \u00e9 o atalho de teclado para grupo no Excel?","og_description":"Neste tutorial, voc\u00ea aprender\u00e1 como usar um atalho de teclado para agrupar linhas e colunas no Excel.","og_url":"https:\/\/exceladvisor.org\/pt\/banda\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:51:31+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-pour-le-regroupement.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/banda\/","url":"https:\/\/exceladvisor.org\/pt\/banda\/","name":"Qual \u00e9 o atalho de teclado para grupo no Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/banda\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/banda\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-pour-le-regroupement.png","datePublished":"2023-10-20T00:30:00+00:00","dateModified":"2023-12-06T11:51:31+00:00","description":"Neste tutorial, voc\u00ea aprender\u00e1 como usar um atalho de teclado para agrupar linhas e colunas no Excel.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/banda\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/banda\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/banda\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-pour-le-regroupement.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-pour-le-regroupement.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/banda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Qual \u00e9 o atalho de teclado para grupo no excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/pt\/#website","url":"https:\/\/exceladvisor.org\/pt\/","name":"Excel Advisor","description":"O seu guia definitivo para dominar os dados!","publisher":{"@id":"https:\/\/exceladvisor.org\/pt\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/pt\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-PT"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/pt\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/pt\/","logo":{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/pt\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/607","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/comments?post=607"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/607\/revisions"}],"predecessor-version":[{"id":1482,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/607\/revisions\/1482"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}