{"id":437,"date":"2023-10-29T04:55:26","date_gmt":"2023-10-29T04:55:26","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/numeros-de-columna\/"},"modified":"2023-12-25T10:24:07","modified_gmt":"2023-12-25T10:24:07","slug":"numeros-de-columna","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/numeros-de-columna\/","title":{"rendered":"\u00bfc\u00f3mo cambiar los alfabetos de las columnas a n\u00fameros?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-4143443688\"><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, las columnas tienen alfabetos como identidad, pero puedes reemplazarlas con un n\u00famero. Esto significa que para la columna A, puedes usar la columna 1. En este tutorial, aprenderemos dos formas diferentes que puedes usar.<\/p>\n<ul>\n<li> Crear una fila de encabezado con un n\u00famero de columna<\/li>\n<li> Cambie la referencia de celda a R1C1 para solicitar n\u00fameros de columna <\/li>\n<\/ul>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-74845\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-les-numeros-de-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"utilizar n\u00fameros de columna\" width=\"531\" height=\"306\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Cambiar alfabetos de columnas a n\u00fameros (R1C1)<\/h2>\n<ol>\n<li> Primero, haga clic en la pesta\u00f1a Archivo. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"pesta\u00f1a 2 archivos\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-onglet-fichier.png\" sizes=\"auto, \" srcset=\"\" alt=\"file-tab\" width=\"486\" height=\"235\"><\/li>\n<li> Despu\u00e9s de eso, vaya a \u00abOpciones\u00bb. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"3 opciones\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-allez-dans-les-options.png\" sizes=\"auto, \" srcset=\"\" alt=\"go-to-options\" width=\"266\" height=\"236\"><\/li>\n<li> A continuaci\u00f3n, haga clic en \u201cF\u00f3rmulas\u201d y desde all\u00ed verifique el \u201cEstilo de referencia R1C1\u201d. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"4-tick-r1c1-estilo de referencia\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-cochez-le-style-de-reference-r1c1.png\" sizes=\"auto, \" srcset=\"\" alt=\"tick-r1c1-reference-style\" width=\"500\" height=\"315\"><\/li>\n<li> Al final, haga clic en Aceptar para aplicar la configuraci\u00f3n. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"5 configuraciones de aplicaci\u00f3n\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-appliquer-les-parametres.png\" sizes=\"auto, \" srcset=\"\" alt=\"apply-settings\" width=\"378\" height=\"213\"><\/li>\n<\/ol>\n<p> Cuando hace esto, cambia el estilo de referencia para toda la aplicaci\u00f3n Excel. Esto significa que ahora debes referirte a una columna usando un n\u00famero, no el alfabeto. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-74850\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-styles-de-reference-pour-toute-lapplication-Excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"estilo-de-referencia-para-toda-la-aplicaci\u00f3n-excel\" width=\"456\" height=\"134\"><\/figure>\n<\/div>\n<p> Ver\u00e1 en el ejemplo anterior donde me refiero a la celda A1, muestra R[-1]C[-2] en lugar de A1. Bueno, eso significa que te refieres a la fila y las dos columnas atr\u00e1s.<\/p>\n<p> <em>Puede obtener m\u00e1s informaci\u00f3n al respecto con esta gu\u00eda completa del <a href=\"https:\/\/exceladvisor.org\/es\/r1c1\/\">estilo de referencia R1C1<\/a> .<\/em><\/p>\n<h2 class=\"wp-block-heading\"> Crear un encabezado con n\u00fameros de columna<\/h2>\n<p> Este m\u00e9todo podr\u00eda usarse en diferentes situaciones, pero tan efectivo como el primero.<\/p>\n<ol>\n<li> Primero, <a href=\"https:\/\/exceladvisor.org\/es\/editar-celda\/\">edite la celda<\/a> A1 e ingrese \u201c=COLUMNA()\u201d en ella. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"7-encabezado-con-n\u00fameros-de-columna\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-en-tete-avec-numeros-de-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"header-with-column-numbers\" width=\"544\" height=\"114\"><\/li>\n<li> Despu\u00e9s de eso, presione Enter para obtener el n\u00famero de columna actual. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"8-obtener-n\u00famero-de-columna-actual\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-obtenir-le-numero-de-la-colonne-en-cours.png\" sizes=\"auto, \" srcset=\"\" alt=\"get-the-number-of-current-column\" width=\"544\" height=\"114\"><\/li>\n<li> Ahora use el controlador de relleno y <a href=\"https:\/\/exceladvisor.org\/es\/bajar-deslizandose\/\">extienda la f\u00f3rmula a la columna en<\/a> la que desea tener n\u00fameros de columna. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"Relleno de f\u00f3rmula de 9 asas para expandir\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-poignee-de-remplissage-pour-etendre-la-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"fill-handle-to-extend-formula\" width=\"545\" height=\"144\"><\/li>\n<li> Al final, puedes convertir todas estas f\u00f3rmulas en valores usando el m\u00e9todo abreviado de teclado ( <a href=\"https:\/\/exceladvisor.org\/es\/copiar-pegar\/\">Ctrl + C para copiar<\/a> y luego presiona Alt \u2192 H \u2192 V \u2192 V para <a href=\"https:\/\/exceladvisor.org\/es\/pegar-valores\/\">pegar los valores<\/a> ).<\/li>\n<\/ol>\n<p> Este m\u00e9todo funciona mejor cuando no desea cambiar la referencia de la celda, sino solo el n\u00famero de columna.<\/p>\n<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\/es\/avance-de-excel\/\">Tutoriales avanzados de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutoriales relacionados <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-65ddf67e\">\n<div class=\"gb-container gb-container-65ddf67e\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/herramienta-de-analisis-rapido\/\">Herramienta de an\u00e1lisis r\u00e1pido en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/aplicar-multiples-filtros\/\">Aplicar m\u00faltiples filtros a las columnas<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/resaltar-los-valores-superiores-e-inferiores\/\">Resalte los valores N superiores e inferiores en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/casilla-de-verificacion\/\">Insertar una casilla de verificaci\u00f3n en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/fusionar-celdas-sin-perder-datos\/\">Fusionar celdas sin perder datos en Excel<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En Excel, las columnas tienen alfabetos como identidad, pero puedes reemplazarlas con un n\u00famero. Esto significa que para la columna A, puedes usar la columna 1. En este tutorial, aprenderemos dos formas diferentes que puedes usar. Crear una fila de encabezado con un n\u00famero de columna Cambie la referencia de celda a R1C1 para solicitar [&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-437","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 cambiar los alfabetos de las columnas a n\u00fameros?<\/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\/numeros-de-columna\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo cambiar los alfabetos de las columnas a n\u00fameros?\" \/>\n<meta property=\"og:description\" content=\"En Excel, las columnas tienen alfabetos como identidad, pero puedes reemplazarlas con un n\u00famero. Esto significa que para la columna A, puedes usar la columna 1. En este tutorial, aprenderemos dos formas diferentes que puedes usar. Crear una fila de encabezado con un n\u00famero de columna Cambie la referencia de celda a R1C1 para solicitar [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/numeros-de-columna\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:24:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-les-numeros-de-colonne.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\/numeros-de-columna\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/numeros-de-columna\/\",\"name\":\"\u00bfc\u00f3mo cambiar los alfabetos de las columnas a n\u00fameros?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/numeros-de-columna\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/numeros-de-columna\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-les-numeros-de-colonne.png\",\"datePublished\":\"2023-10-29T04:55:26+00:00\",\"dateModified\":\"2023-12-25T10:24:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/numeros-de-columna\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/numeros-de-columna\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/numeros-de-columna\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-les-numeros-de-colonne.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-les-numeros-de-colonne.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/numeros-de-columna\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo cambiar los alfabetos de las columnas a n\u00fameros?\"}]},{\"@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 cambiar los alfabetos de las columnas a n\u00fameros?","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\/numeros-de-columna\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo cambiar los alfabetos de las columnas a n\u00fameros?","og_description":"En Excel, las columnas tienen alfabetos como identidad, pero puedes reemplazarlas con un n\u00famero. Esto significa que para la columna A, puedes usar la columna 1. En este tutorial, aprenderemos dos formas diferentes que puedes usar. Crear una fila de encabezado con un n\u00famero de columna Cambie la referencia de celda a R1C1 para solicitar [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/numeros-de-columna\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:24:07+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-les-numeros-de-colonne.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\/numeros-de-columna\/","url":"https:\/\/exceladvisor.org\/es\/numeros-de-columna\/","name":"\u00bfc\u00f3mo cambiar los alfabetos de las columnas a n\u00fameros?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/numeros-de-columna\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/numeros-de-columna\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-les-numeros-de-colonne.png","datePublished":"2023-10-29T04:55:26+00:00","dateModified":"2023-12-25T10:24:07+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/numeros-de-columna\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/numeros-de-columna\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/numeros-de-columna\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-les-numeros-de-colonne.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-les-numeros-de-colonne.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/numeros-de-columna\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo cambiar los alfabetos de las columnas a n\u00fameros?"}]},{"@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\/437","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=437"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/437\/revisions"}],"predecessor-version":[{"id":900,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/437\/revisions\/900"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=437"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}