{"id":732,"date":"2023-09-25T00:44:32","date_gmt":"2023-09-25T00:44:32","guid":{"rendered":"https:\/\/exceladvisor.org\/pt\/aplicar-fronteiras\/"},"modified":"2023-12-06T11:34:44","modified_gmt":"2023-12-06T11:34:44","slug":"aplicar-fronteiras","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/pt\/aplicar-fronteiras\/","title":{"rendered":"Como aplicar uma borda atrav\u00e9s de um atalho do excel?"},"content":{"rendered":"<div class=\"excel-before-content-2\" id=\"excel-628397523\"><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-4142502275\"><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>O Excel n\u00e3o aplica nenhuma borda \u00e0 c\u00e9lula, mas existem v\u00e1rios tipos de op\u00e7\u00f5es de borda dispon\u00edveis para serem aplicadas em c\u00e9lulas, intervalo ou planilha manualmente pelos usu\u00e1rios ou usando atalhos de teclado.<\/p><p> Neste tutorial, explicamos alguns atalhos de teclado para aplicar bordas no Excel.<\/p><h2 class=\"wp-block-heading\"> Teclas de atalho para aplicar borda no Excel<\/h2><p> A op\u00e7\u00e3o de borda mais comumente usada \u00e9 \u201cTodas as Bordas\u201d, que aplica uma borda a todos os lados da c\u00e9lula.<\/p><p> <kbd>Alt<\/kbd> \u2192 <kbd>H<\/kbd> \u2192 <kbd>B<\/kbd> \u2192 <kbd>A<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70418\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png\" sizes=\"auto, \" srcset=\"\" alt=\"atalho para aplicar borda\" width=\"774\" height=\"303\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Etapas para aplicar uma borda usando um atalho de teclado<\/h2><ul><li> Primeiro, selecione a c\u00e9lula, o intervalo de c\u00e9lulas ou os dados inteiros na planilha usando \u201cCtrl + A\u201d para selecionar as c\u00e9lulas \u00e0s quais deseja aplicar bordas. <br><img loading=\"lazy\" decoding=\"async\" title=\"2 faixas de sele\u00e7\u00e3o\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-selectionner-la-gamme.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-range\" width=\"437\" height=\"206\"><\/li><li> Depois disso, pressione Alt \u2192 H \u2192 B \u2192 A na ordem e voc\u00ea ter\u00e1 as bordas aplicadas em todos os lados de cada c\u00e9lula selecionada. <br><img loading=\"lazy\" decoding=\"async\" title=\"3 bordas aplicadas \u00e0s c\u00e9lulas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-bordure-appliquee-aux-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"border-applied-to-the-cells\" width=\"438\" height=\"207\"><\/li><\/ul><h2 class=\"wp-block-heading\"> Teclas de atalho para aplicar diferentes tipos de bordas<\/h2><p> A combina\u00e7\u00e3o de teclas de atalho para aplicar todos os tipos de bordas \u00e9 a mesma, exceto que a \u00faltima tecla da combina\u00e7\u00e3o muda dependendo do tipo de borda que voc\u00ea deseja aplicar.<\/p><ol><li> Aplique bordas na parte inferior das c\u00e9lulas: <kbd>Alt<\/kbd> \u2192 <kbd>H<\/kbd> \u2192 <kbd>B<\/kbd> \u2192 <kbd>O<\/kbd><\/li><li> Aplique bordas no topo das c\u00e9lulas: Alt \u2192 H \u2192 B \u2192 P<\/li><li> Aplique bordas \u00e0 esquerda das c\u00e9lulas: Alt \u2192 H \u2192 B \u2192 L<\/li><li> Aplique bordas \u00e0 direita das c\u00e9lulas: Alt \u2192 H \u2192 B \u2192 R<\/li><li> Aplique bordas somente fora do intervalo selecionado: Alt \u2192 H \u2192 B \u2192 S<\/li><li> Aplique bordas grossas somente fora do intervalo selecionado: Alt \u2192 H \u2192 B \u2192 T<\/li><li> Aplique bordas duplas na parte inferior das c\u00e9lulas: Alt \u2192 H \u2192 B \u2192 B<\/li><li> Aplique bordas duplas grossas na parte inferior das c\u00e9lulas: Alt \u2192 H \u2192 B \u2192 H <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70421\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-types-de-bordures-multiples.png\" sizes=\"auto, \" srcset=\"\" alt=\"v\u00e1rios tipos de borda\" width=\"225\" height=\"512\"><\/figure><\/div><p> Para encontrar e aplicar mais op\u00e7\u00f5es de borda Pressione \u201cAlt \u2192 H \u2192 B \u2192 M\u201d e voc\u00ea abrir\u00e1 a caixa de di\u00e1logo \u201cFormatar c\u00e9lulas\u201d com mais op\u00e7\u00f5es de borda para escolher. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70422\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-autres-options-de-bordure.png\" sizes=\"auto, \" srcset=\"\" alt=\"mais op\u00e7\u00f5es de borda\" width=\"549\" height=\"441\"><\/figure><\/div><div class=\"gb-container gb-container-2116538e gb-container-mt\"> <a class=\"gb-button gb-button-f7d2c131 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/pt\/atalhos-do-teclado\/\">Atalhos de teclado do Excel<\/a><h2 class=\"gb-headline gb-headline-7ed68554 gb-headline-text gb-headline-mt-heading\"> Mais atalhos <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-edeef538 gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-6ab6fbc6\"><div class=\"gb-container gb-container-6ab6fbc6\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/pt\/abrir-opcoes-de-formato-de-celula\/\">Op\u00e7\u00e3o para abrir c\u00e9lulas de formato<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/ajuste-automatico\/\">Ajuste autom\u00e1tico<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/formato-de-pintor-1\/\">Formato do pintor<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/quebrar-texto\/\">Quebrar texto<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/pt\/adicione-comentarios\/\">Adicione coment\u00e1rios<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-766d598b\"><div class=\"gb-container gb-container-766d598b\"><\/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-732","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 aplicar uma borda atrav\u00e9s de um atalho do Excel?<\/title>\n<meta name=\"description\" content=\"Neste tutorial, voc\u00ea aprender\u00e1 como usar um atalho de teclado para aplicar bordas no Excel e todas as informa\u00e7\u00f5es relacionadas.\" \/>\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\/aplicar-fronteiras\/\" \/>\n<meta property=\"og:locale\" content=\"pt_PT\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Como aplicar uma borda atrav\u00e9s de um atalho do Excel?\" \/>\n<meta property=\"og:description\" content=\"Neste tutorial, voc\u00ea aprender\u00e1 como usar um atalho de teclado para aplicar bordas no Excel e todas as informa\u00e7\u00f5es relacionadas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/pt\/aplicar-fronteiras\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T11:34:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.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\/aplicar-fronteiras\/\",\"url\":\"https:\/\/exceladvisor.org\/pt\/aplicar-fronteiras\/\",\"name\":\"\u25b7 Como aplicar uma borda atrav\u00e9s de um atalho do Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/aplicar-fronteiras\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/aplicar-fronteiras\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png\",\"datePublished\":\"2023-09-25T00:44:32+00:00\",\"dateModified\":\"2023-12-06T11:34:44+00:00\",\"description\":\"Neste tutorial, voc\u00ea aprender\u00e1 como usar um atalho de teclado para aplicar bordas no Excel e todas as informa\u00e7\u00f5es relacionadas.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/pt\/aplicar-fronteiras\/#breadcrumb\"},\"inLanguage\":\"pt-PT\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/pt\/aplicar-fronteiras\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-PT\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/aplicar-fronteiras\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/pt\/aplicar-fronteiras\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Lar\",\"item\":\"https:\/\/exceladvisor.org\/pt\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Como aplicar uma borda atrav\u00e9s de um atalho do 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 aplicar uma borda atrav\u00e9s de um atalho do Excel?","description":"Neste tutorial, voc\u00ea aprender\u00e1 como usar um atalho de teclado para aplicar bordas no Excel e todas as informa\u00e7\u00f5es relacionadas.","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\/aplicar-fronteiras\/","og_locale":"pt_PT","og_type":"article","og_title":"\u25b7 Como aplicar uma borda atrav\u00e9s de um atalho do Excel?","og_description":"Neste tutorial, voc\u00ea aprender\u00e1 como usar um atalho de teclado para aplicar bordas no Excel e todas as informa\u00e7\u00f5es relacionadas.","og_url":"https:\/\/exceladvisor.org\/pt\/aplicar-fronteiras\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T11:34:44+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.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\/aplicar-fronteiras\/","url":"https:\/\/exceladvisor.org\/pt\/aplicar-fronteiras\/","name":"\u25b7 Como aplicar uma borda atrav\u00e9s de um atalho do Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/pt\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/pt\/aplicar-fronteiras\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/pt\/aplicar-fronteiras\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png","datePublished":"2023-09-25T00:44:32+00:00","dateModified":"2023-12-06T11:34:44+00:00","description":"Neste tutorial, voc\u00ea aprender\u00e1 como usar um atalho de teclado para aplicar bordas no Excel e todas as informa\u00e7\u00f5es relacionadas.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/pt\/aplicar-fronteiras\/#breadcrumb"},"inLanguage":"pt-PT","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/pt\/aplicar-fronteiras\/"]}]},{"@type":"ImageObject","inLanguage":"pt-PT","@id":"https:\/\/exceladvisor.org\/pt\/aplicar-fronteiras\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/pt\/aplicar-fronteiras\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Lar","item":"https:\/\/exceladvisor.org\/pt\/"},{"@type":"ListItem","position":2,"name":"Como aplicar uma borda atrav\u00e9s de um atalho do 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\/732","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=732"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/732\/revisions"}],"predecessor-version":[{"id":849,"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/pages\/732\/revisions\/849"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/pt\/wp-json\/wp\/v2\/media?parent=732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}