{"id":733,"date":"2023-09-25T00:44:32","date_gmt":"2023-09-25T00:44:32","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/aplicar-fronteras\/"},"modified":"2023-12-25T10:23:32","modified_gmt":"2023-12-25T10:23:32","slug":"aplicar-fronteras","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/aplicar-fronteras\/","title":{"rendered":"\u00bfc\u00f3mo aplicar un borde mediante un atajo de excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-4014906904\"><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>Excel no aplica ning\u00fan borde a la celda, pero hay varios tipos de opciones de borde disponibles para que los usuarios las apliquen manualmente a las celdas, al rango o a la hoja de c\u00e1lculo o mediante atajos de teclado.<\/p>\n<p> En este tutorial, explicamos algunos atajos de teclado para aplicar bordes en Excel.<\/p>\n<h2 class=\"wp-block-heading\"> Teclas de acceso directo para aplicar borde en Excel<\/h2>\n<p> La opci\u00f3n de borde m\u00e1s utilizada es \u00abTodos los bordes\u00bb, que aplica un borde a todos los lados de la celda.<\/p>\n<p> <kbd>Alt<\/kbd> \u2192 <kbd>H<\/kbd> \u2192 <kbd>B<\/kbd> \u2192 <kbd>A<\/kbd> <\/p>\n<div class=\"wp-block-image\">\n<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=\"atajo-para-aplicar-borde\" width=\"774\" height=\"303\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Pasos para aplicar un borde usando un atajo de teclado<\/h2>\n<ul>\n<li> Primero, seleccione la celda, el rango de celdas o los datos completos en la hoja de trabajo usando \u00abCtrl + A\u00bb para seleccionar las celdas a las que desea aplicar bordes. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"rango de 2 selecciones\" 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>\n<li> Despu\u00e9s de eso, presione Alt \u2192 H \u2192 B \u2192 A en orden y obtendr\u00e1 los bordes aplicados a todos los lados de cada celda seleccionada. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"3 bordes aplicados a las celdas.\" 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>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Teclas de acceso directo para aplicar diferentes tipos de bordes.<\/h2>\n<p> La combinaci\u00f3n de teclas de m\u00e9todo abreviado para aplicar todos los tipos de bordes es la misma excepto que la \u00faltima tecla de la combinaci\u00f3n cambia seg\u00fan el tipo de borde que desea aplicar.<\/p>\n<ol>\n<li> Aplicar bordes en la parte inferior de las celdas: <kbd>Alt<\/kbd> \u2192 <kbd>H<\/kbd> \u2192 <kbd>B<\/kbd> \u2192 <kbd>O<\/kbd><\/li>\n<li> Aplicar bordes en la parte superior de las celdas: Alt \u2192 H \u2192 B \u2192 P<\/li>\n<li> Aplicar bordes a la izquierda de las celdas: Alt \u2192 H \u2192 B \u2192 L<\/li>\n<li> Aplicar bordes a la derecha de las celdas: Alt \u2192 H \u2192 B \u2192 R<\/li>\n<li> Aplicar bordes solo fuera del rango seleccionado: Alt \u2192 H \u2192 B \u2192 S<\/li>\n<li> Aplicar bordes gruesos solo fuera del rango seleccionado: Alt \u2192 H \u2192 B \u2192 T<\/li>\n<li> Aplicar bordes dobles en la parte inferior de las celdas: Alt \u2192 H \u2192 B \u2192 B<\/li>\n<li> Aplique bordes dobles gruesos en la parte inferior de las celdas: Alt \u2192 H \u2192 B \u2192 H <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<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=\"m\u00faltiples tipos de fronteras\" width=\"225\" height=\"512\"><\/figure>\n<\/div>\n<p> Para buscar y aplicar m\u00e1s opciones de borde Presione \u201cAlt \u2192 H \u2192 B \u2192 M\u201d y se abrir\u00e1 el cuadro de di\u00e1logo \u201cFormato de celdas\u201d con m\u00e1s opciones de borde para elegir. <\/p>\n<div class=\"wp-block-image\">\n<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=\"m\u00e1s opciones de frontera\" width=\"549\" height=\"441\"><\/figure>\n<\/div>\n<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\/es\/atajos-de-teclado\/\">Atajos de teclado de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-7ed68554 gb-headline-text gb-headline-mt-heading\"> M\u00e1s atajos <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-edeef538 gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-6ab6fbc6\">\n<div class=\"gb-container gb-container-6ab6fbc6\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/opciones-de-celda-de-formato-abierto\/\">Opci\u00f3n para abrir celdas de formato.<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ajuste-automatico\/\">Ajuste autom\u00e1tico<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/formato-pintor-1\/\">Formato pintor<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ajustar-texto\/\">Ajustar texto<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/anadir-comentarios\/\">A\u00f1adir comentarios<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-766d598b\">\n<div class=\"gb-container gb-container-766d598b\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Excel no aplica ning\u00fan borde a la celda, pero hay varios tipos de opciones de borde disponibles para que los usuarios las apliquen manualmente a las celdas, al rango o a la hoja de c\u00e1lculo o mediante atajos de teclado. En este tutorial, explicamos algunos atajos de teclado para aplicar bordes en Excel. Teclas de [&hellip;]<\/p>\n","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-733","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>\u00bfc\u00f3mo aplicar un borde mediante un atajo de excel?<\/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:\/\/exceladvisor.org\/es\/aplicar-fronteras\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo aplicar un borde mediante un atajo de excel?\" \/>\n<meta property=\"og:description\" content=\"Excel no aplica ning\u00fan borde a la celda, pero hay varios tipos de opciones de borde disponibles para que los usuarios las apliquen manualmente a las celdas, al rango o a la hoja de c\u00e1lculo o mediante atajos de teclado. En este tutorial, explicamos algunos atajos de teclado para aplicar bordes en Excel. Teclas de [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/aplicar-fronteras\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:23:32+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=\"Tiempo de lectura\" \/>\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\/es\/aplicar-fronteras\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/aplicar-fronteras\/\",\"name\":\"\u00bfc\u00f3mo aplicar un borde mediante un atajo de excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/aplicar-fronteras\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/aplicar-fronteras\/#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-25T10:23:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/aplicar-fronteras\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/aplicar-fronteras\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/aplicar-fronteras\/#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\/es\/aplicar-fronteras\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo aplicar un borde mediante un atajo de excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo aplicar un borde mediante un atajo de 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\/es\/aplicar-fronteras\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo aplicar un borde mediante un atajo de excel?","og_description":"Excel no aplica ning\u00fan borde a la celda, pero hay varios tipos de opciones de borde disponibles para que los usuarios las apliquen manualmente a las celdas, al rango o a la hoja de c\u00e1lculo o mediante atajos de teclado. En este tutorial, explicamos algunos atajos de teclado para aplicar bordes en Excel. Teclas de [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/aplicar-fronteras\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:23:32+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":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/aplicar-fronteras\/","url":"https:\/\/exceladvisor.org\/es\/aplicar-fronteras\/","name":"\u00bfc\u00f3mo aplicar un borde mediante un atajo de excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/aplicar-fronteras\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/aplicar-fronteras\/#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-25T10:23:32+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/aplicar-fronteras\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/aplicar-fronteras\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/aplicar-fronteras\/#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\/es\/aplicar-fronteras\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo aplicar un borde mediante un atajo de excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/733","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=733"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/733\/revisions"}],"predecessor-version":[{"id":852,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/733\/revisions\/852"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=733"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}