{"id":615,"date":"2023-10-18T22:16:48","date_gmt":"2023-10-18T22:16:48","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/a-grade\/"},"modified":"2023-12-06T11:44:16","modified_gmt":"2023-12-06T11:44:16","slug":"a-grade","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/a-grade\/","title":{"rendered":"Como usar linhas de grade no excel?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-3161176379\"><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-2562684067\"><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>No Excel, ao abrir uma pasta de trabalho, voc\u00ea pode ver que existem linhas de grade (linhas cinza claro) que tornam as c\u00e9lulas vis\u00edveis. Neste tutorial, aprenderemos como gerenciar essas grades. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61132\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-quadrillage-dans-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"grade no Excel\" width=\"379\" height=\"236\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Remover linhas de grade no Excel<\/h2><ol type=\"1\"><li> Voc\u00ea precisa navegar at\u00e9 a guia \u201cExibir\u201d na faixa de op\u00e7\u00f5es.<\/li><li> A partir da\u00ed, v\u00e1 para o grupo \u201cMostrar\u201d acima.<\/li><li> Depois, h\u00e1 uma caixa de sele\u00e7\u00e3o de grade ali.<\/li><li> Desmarque a caixa para remover as grades da pasta de trabalho. <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61133\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-supprimer-le-quadrillage.png\" sizes=\"auto, \" srcset=\"\" alt=\"remover grade\" width=\"619\" height=\"150\"><\/figure><\/div><p> Se quiser mostrar as linhas de grade novamente, basta marcar a caixa novamente, mas tamb\u00e9m deseja ocultar e mostrar as linhas de grade na aba \u201cLayout\u201d, no grupo de op\u00e7\u00f5es Linhas de grade. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61134\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-masquage-du-quadrillage.png\" sizes=\"auto, \" srcset=\"\" alt=\"ocultar-mostrar linhas de grade\" width=\"545\" height=\"164\"><\/figure><\/div><p> E h\u00e1 outra maneira que voc\u00ea pode encontrar nas op\u00e7\u00f5es do Excel. V\u00e1 para <strong>guia Arquivo \u2192 Op\u00e7\u00f5es do Excel \u2192 Avan\u00e7ado \u2192 Op\u00e7\u00f5es de exibi\u00e7\u00e3o da planilha \u2192 Desmarque a caixa \u201cMostrar linhas de grade\u201d<\/strong> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61135\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-decochez-Afficher-le-quadrillage.png\" sizes=\"auto, \" srcset=\"\" alt=\"desmarque mostrar grade\" width=\"677\" height=\"353\"><\/figure><\/div><p class=\"qt-tip\"> <strong>Nota:<\/strong> Quando voc\u00ea usa qualquer uma das op\u00e7\u00f5es acima para remover as linhas de grade, elas ser\u00e3o aplicadas apenas \u00e0 planilha ativa, n\u00e3o \u00e0 pasta de trabalho inteira. Mas se quiser remover ou adicionar linhas de grade de v\u00e1rias planilhas, voc\u00ea pode selecionar um grupo de planilhas e desmarcar a op\u00e7\u00e3o de grade.<\/p><h2 class=\"wp-block-heading\"> Atalho de teclado para linhas de grade no Excel<\/h2><p> Da mesma forma, voc\u00ea pode ocultar e mostrar as linhas de grade usando a seguinte <a href=\"https:\/\/exceladvisor.org\/pt\/atalhos-do-teclado\/\">tecla de atalho<\/a> . A seguinte tecla de atalho usa a op\u00e7\u00e3o da guia \u201cExibir\u201d.<\/p><p> <kbd>Alt<\/kbd> \u2192 <kbd>W<\/kbd> \u2192 <kbd>V<\/kbd> \u2192 <kbd>G<\/kbd><\/p><h2 class=\"wp-block-heading\"> Imprimir linhas de grade no Excel<\/h2><p> Ao imprimir a planilha, voc\u00ea n\u00e3o encontrar\u00e1 as linhas de grade na impress\u00e3o. Mas voc\u00ea habilita a impress\u00e3o em grade.<\/p><ol type=\"1\"><li> V\u00e1 para a guia \u201cLayout\u201d e navegue at\u00e9 o grupo \u201cOp\u00e7\u00f5es de planilha\u201d.<\/li><li> Ent\u00e3o, voc\u00ea encontrar\u00e1 as grades de op\u00e7\u00f5es.<\/li><li> A partir da\u00ed, marque a segunda caixa de sele\u00e7\u00e3o \u201cImprimir\u201d.<\/li><\/ol><p class=\"qt-tip\"> <strong>Nota:<\/strong> Depois de ativar a impress\u00e3o em grade, o Excel imprimir\u00e1 apenas as linhas de grade do intervalo em uso (c\u00e9lulas onde voc\u00ea possui conte\u00fado). Assim como o seguinte: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61136\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-imprimer-le-quadrillage.png\" sizes=\"auto, \" srcset=\"\" alt=\"imprimir a grade\" width=\"383\" height=\"308\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Alterar a cor da grade<\/h2><p> Por padr\u00e3o, as linhas de grade t\u00eam uma cor cinza claro, mas voc\u00ea pode alterar a cor das linhas de grade nas Op\u00e7\u00f5es do Excel. V\u00e1 para <strong>guia Arquivo \u2192 <a href=\"https:\/\/exceladvisor.org\/pt\/opcoes\/\">Op\u00e7\u00f5es do Excel<\/a> \u2192 Avan\u00e7ado \u2192 Op\u00e7\u00f5es de exibi\u00e7\u00e3o da planilha \u2192 Selecionar cor da grade<\/strong> . <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-61137\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-changer-la-couleur-des-grilles.png\" sizes=\"auto, \" srcset=\"\" alt=\"mudar a cor da grade\" width=\"548\" height=\"339\"><\/figure><\/div><p> Quando voc\u00ea altera a cor da grade, tamb\u00e9m altera a cor da grade para impress\u00e3o, se voc\u00ea estiver usando impress\u00e3o colorida.<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/pt\/nocoes-basicas-de-excel\/\">No\u00e7\u00f5es b\u00e1sicas do Microsoft Excel (componentes, pe\u00e7as e notas de conhecimento)<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriais relacionados <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/pt\/formato-de-numero-contabil\/\">Aplicar formato de n\u00famero cont\u00e1bil no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/cor-da-celula\/\">Aplicar cor de fundo a uma c\u00e9lula ou a toda a planilha no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/adicione-um-numero-de-pagina\/\">Adicione um n\u00famero de p\u00e1gina no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/aplicar-estilo-de-virgula\/\">Aplicar estilo de v\u00edrgula no Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/haste\/\">Aplicar tachado no Exce<\/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-615","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>\u25b7 Como usar linhas de grade no Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Vamos aprender como ativar\/desativar linhas de grade no Excel e usar todas as op\u00e7\u00f5es dispon\u00edveis.\" \/>\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\/a-grade\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Como usar linhas de grade no Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Vamos aprender como ativar\/desativar linhas de grade no Excel e usar todas as op\u00e7\u00f5es dispon\u00edveis.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/a-grade\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:44:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-quadrillage-dans-excel.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=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/a-grade\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/a-grade\/\",\"name\":\"\u25b7 Como usar linhas de grade no Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/a-grade\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/a-grade\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-quadrillage-dans-excel.png\",\"datePublished\":\"2023-10-18T22:16:48+00:00\",\"dateModified\":\"2023-12-06T11:44:16+00:00\",\"description\":\"Vamos aprender como ativar\/desativar linhas de grade no Excel e usar todas as op\u00e7\u00f5es dispon\u00edveis.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/a-grade\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/a-grade\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/a-grade\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-quadrillage-dans-excel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-quadrillage-dans-excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/a-grade\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como usar linhas de grade 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":"\u25b7 Como usar linhas de grade no Excel? (Tutorial 2023)","description":"Vamos aprender como ativar\/desativar linhas de grade no Excel e usar todas as op\u00e7\u00f5es dispon\u00edveis.","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\/a-grade\/","og_locale":"pt_PT","og_type":"article","og_title":"\u25b7 Como usar linhas de grade no Excel? (Tutorial 2023)","og_description":"Vamos aprender como ativar\/desativar linhas de grade no Excel e usar todas as op\u00e7\u00f5es dispon\u00edveis.","og_url":"https:\/\/exceladvisor.org\/pt\/a-grade\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:44:16+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-quadrillage-dans-excel.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tempo estimado de leitura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/pt\/a-grade\/","url":"https:\/\/exceladvisor.org\/pt\/a-grade\/","name":"\u25b7 Como usar linhas de grade no Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/a-grade\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/a-grade\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-quadrillage-dans-excel.png","datePublished":"2023-10-18T22:16:48+00:00","dateModified":"2023-12-06T11:44:16+00:00","description":"Vamos aprender como ativar\/desativar linhas de grade no Excel e usar todas as op\u00e7\u00f5es dispon\u00edveis.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/a-grade\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/a-grade\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/a-grade\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-quadrillage-dans-excel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-quadrillage-dans-excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/a-grade\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como usar linhas de grade 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\/615","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=615"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/615\/revisions"}],"predecessor-version":[{"id":1358,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/615\/revisions\/1358"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}