{"id":727,"date":"2023-09-25T06:25:20","date_gmt":"2023-09-25T06:25:20","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/ajuste-automatico\/"},"modified":"2023-12-25T10:23:20","modified_gmt":"2023-12-25T10:23:20","slug":"ajuste-automatico","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/ajuste-automatico\/","title":{"rendered":"\u00bfc\u00f3mo ajustar el texto autom\u00e1ticamente mediante una f\u00f3rmula de excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1819770663\"><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>En Excel, la funci\u00f3n AutoAjustar se utiliza para cambiar el tama\u00f1o de la altura de la fila y el ancho de la celda seg\u00fan el tama\u00f1o del valor en las celdas.<\/p>\n<p> Como sabe, Excel tiene altura de fila y ancho de celda de forma predeterminada y cuando el usuario ingresa un valor cuya longitud es mayor que el ancho de la celda, el valor desborda las celdas y para cambiar el tama\u00f1o de las celdas dependiendo de este valor, podemos usar AutoAjustar.<\/p>\n<p> En la imagen a continuaci\u00f3n, puede ver que la longitud de los valores ingresados era mayor que el tama\u00f1o de celda predeterminado, por lo que los valores se derramaban sobre las celdas. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67515\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-debordees.png\" sizes=\"auto, \" srcset=\"\" alt=\"desbordamiento de valores\" width=\"327\" height=\"225\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Atajo de teclado para usar AutoFit en Excel <\/h2>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67516\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-raccourcis-clavier-pour-ajuster-automatiquement-la-largeur-des-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"m\u00e9todo abreviado de teclado para ajustar autom\u00e1ticamente el ancho de celda\" width=\"821\" height=\"322\"><\/figure>\n<\/div>\n<p> <strong>Ajustar autom\u00e1ticamente el ancho de celda (columna):<\/strong> Alt \u2192 H \u2192 O \u2192 I <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67517\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-raccourci-pour-ajuster-automatiquement-la-hauteur-de-ligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"acceso directo para ajustar autom\u00e1ticamente la altura de la fila\" width=\"804\" height=\"315\"><\/figure>\n<\/div>\n<p> <strong>Ajustar autom\u00e1ticamente la altura de la l\u00ednea (filas):<\/strong> Alt \u2192 H \u2192 O \u2192 A<\/p>\n<h2 class=\"wp-block-heading\"> Pasos para utilizar el ancho de celda de ajuste autom\u00e1tico mediante el m\u00e9todo abreviado de teclado<\/h2>\n<ol>\n<li> Primero, seleccione la celda individual o la columna completa usando las teclas \u00abCtrl + Barra espaciadora\u00bb. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"4 columnas de selecci\u00f3n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-selectionner-la-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-column\" width=\"334\" height=\"229\"><\/li>\n<li> Ahora simplemente presione \u201cAlt \u2192 H \u2192 O \u2192 I\u201d y el ancho de sus celdas se ampliar\u00e1 seg\u00fan el valor de celda m\u00e1s grande de la columna. <br \/><img decoding=\"async\" title=\"5 celdas despu\u00e9s del ajuste autom\u00e1tico\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-cellules-apres-ajustement-automatique.png\" sizes=\"\" srcset=\"\" alt=\"cells-after-autofit\"><\/li>\n<\/ol>\n<h2 class=\"wp-block-heading\"> Pasos para utilizar AutoAjustar altura de fila mediante el m\u00e9todo abreviado de teclado<\/h2>\n<p> Supongamos que tienes datos no estructurados donde en una columna tienes valores en el texto envolvente y algunos no lo son debido a que el alto de fila de los datos no es el mismo y para hacer filas y columnas AutoFit sigue los pasos a continuaci\u00f3n: <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67520\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-donnees-non-structurees-dans-les-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"datos-no estructurados-en-celdas\" width=\"285\" height=\"306\"><\/figure>\n<\/div>\n<ol>\n<li> Primero, seleccione la columna y expanda manualmente el ancho de la columna hasta un nivel donde se puedan cubrir todos los valores. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"7-ampliar-ancho-de-columna\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-augmenter-la-largeur-de-la-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"expand-the-column-width\" width=\"382\" height=\"241\"><\/li>\n<li> Despu\u00e9s de eso, simplemente presione \u201cAlt \u2192 H \u2192 O \u2192 A\u201d y obtendr\u00e1 la altura de fila ajustada. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"8 filas de altura ajustada mediante ajuste autom\u00e1tico\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-rangees-hauteur-ajustee-par-autofit.png\" sizes=\"auto, \" srcset=\"\" alt=\"rows-height-adjusted-by-autofit\" width=\"431\" height=\"223\"><\/li>\n<\/ol>\n<p> En el caso anterior, si utiliza el acceso directo de celda de AutoAjustar para ajustar autom\u00e1ticamente el ancho de la celda, no funcionar\u00e1 correctamente porque el ajuste autom\u00e1tico no funciona en celdas de texto ajustadas.<\/p>\n<p> Puede existir la posibilidad de tener un valor mayor en cualquier celda de texto ajustada, por lo que es recomendable expandir la columna manualmente y luego usar el acceso directo AutoAjustar altura de fila.<\/p>\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\/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\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/agregar-una-sangria\/\">Agregar una sangr\u00eda<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/aplicar-fronteras\/\">Aplicar borde<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/color-de-relleno\/\">Color de relleno<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En Excel, la funci\u00f3n AutoAjustar se utiliza para cambiar el tama\u00f1o de la altura de la fila y el ancho de la celda seg\u00fan el tama\u00f1o del valor en las celdas. Como sabe, Excel tiene altura de fila y ancho de celda de forma predeterminada y cuando el usuario ingresa un valor cuya longitud es [&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-727","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 ajustar el texto autom\u00e1ticamente mediante una f\u00f3rmula 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\/ajuste-automatico\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo ajustar el texto autom\u00e1ticamente mediante una f\u00f3rmula de excel?\" \/>\n<meta property=\"og:description\" content=\"En Excel, la funci\u00f3n AutoAjustar se utiliza para cambiar el tama\u00f1o de la altura de la fila y el ancho de la celda seg\u00fan el tama\u00f1o del valor en las celdas. Como sabe, Excel tiene altura de fila y ancho de celda de forma predeterminada y cuando el usuario ingresa un valor cuya longitud es [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/ajuste-automatico\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:23:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-debordees.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\/ajuste-automatico\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/ajuste-automatico\/\",\"name\":\"\u00bfc\u00f3mo ajustar el texto autom\u00e1ticamente mediante una f\u00f3rmula de excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/ajuste-automatico\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/ajuste-automatico\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-debordees.png\",\"datePublished\":\"2023-09-25T06:25:20+00:00\",\"dateModified\":\"2023-12-25T10:23:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/ajuste-automatico\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/ajuste-automatico\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/ajuste-automatico\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-debordees.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-debordees.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/ajuste-automatico\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo ajustar el texto autom\u00e1ticamente mediante una f\u00f3rmula 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 ajustar el texto autom\u00e1ticamente mediante una f\u00f3rmula 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\/ajuste-automatico\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo ajustar el texto autom\u00e1ticamente mediante una f\u00f3rmula de excel?","og_description":"En Excel, la funci\u00f3n AutoAjustar se utiliza para cambiar el tama\u00f1o de la altura de la fila y el ancho de la celda seg\u00fan el tama\u00f1o del valor en las celdas. Como sabe, Excel tiene altura de fila y ancho de celda de forma predeterminada y cuando el usuario ingresa un valor cuya longitud es [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/ajuste-automatico\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:23:20+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-debordees.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\/ajuste-automatico\/","url":"https:\/\/exceladvisor.org\/es\/ajuste-automatico\/","name":"\u00bfc\u00f3mo ajustar el texto autom\u00e1ticamente mediante una f\u00f3rmula de excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/ajuste-automatico\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/ajuste-automatico\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-debordees.png","datePublished":"2023-09-25T06:25:20+00:00","dateModified":"2023-12-25T10:23:20+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/ajuste-automatico\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/ajuste-automatico\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/ajuste-automatico\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-debordees.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-debordees.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/ajuste-automatico\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo ajustar el texto autom\u00e1ticamente mediante una f\u00f3rmula 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\/727","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=727"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/727\/revisions"}],"predecessor-version":[{"id":836,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/727\/revisions\/836"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=727"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}