{"id":629,"date":"2023-10-17T00:17:04","date_gmt":"2023-10-17T00:17:04","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/rango\/"},"modified":"2023-12-25T10:32:12","modified_gmt":"2023-12-25T10:32:12","slug":"rango","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/rango\/","title":{"rendered":"\u00bfqu\u00e9 es un rango de excel y sus caracter\u00edsticas?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2917695598\"><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><h2 class=\"wp-block-heading\">\u00bfQu\u00e9 es un rango en Excel?<\/h2>\n<p> Un rango es un grupo de varias celdas en Excel. Puede haber un rango continuo y discontinuo. Al igual que una sola celda, cada rango tiene una direcci\u00f3n que puede usar para hacer referencia a ese rango. Una columna y una fila tambi\u00e9n son una forma de rango continuo porque es un grupo de celdas.<\/p>\n<h2 class=\"wp-block-heading\"> Seleccionar rango de celdas<\/h2>\n<p> Cuando trabaja con datos en Excel, necesita seleccionar un rango que le permita copiarlos, pegarlos, moverlos y eliminarlos (muchas otras cosas tambi\u00e9n).<\/p>\n<p> Para seleccionar todo el rango, seleccione la celda desde la que desea iniciar la selecci\u00f3n (C1). Manteniendo presionado el bot\u00f3n izquierdo del mouse, seleccione la celda donde desea ampliar su selecci\u00f3n de rango. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-78750\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/image-gif.gif\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"480\" height=\"321\"><\/figure>\n<\/div>\n<p> Otra forma de seleccionar el rango es presionar la tecla Shift y usar las teclas de navegaci\u00f3n. Como puede ver en la instant\u00e1nea anterior, seleccionamos el rango de C1 a C10.<\/p>\n<p class=\"tips\"> Al seleccionar un rango, Excel muestra el n\u00famero de filas y columnas en el cuadro Nombre a la izquierda de la barra de f\u00f3rmulas.<\/p>\n<p class=\"tips\"> Una vez que haya completado la selecci\u00f3n, el cuadro de nombre muestra la direcci\u00f3n de la celda activa que no est\u00e1 resaltada. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-78744\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-case-nom-dans-la-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"nombre-de-campo-en-la-hoja\" width=\"500\" height=\"216\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Refiri\u00e9ndose a un rango contiguo<\/h2>\n<p> Para hacer referencia a un rango en una funci\u00f3n o f\u00f3rmula, tienes dos m\u00e9todos diferentes:<\/p>\n<ul>\n<li> <strong>Rat\u00f3n:<\/strong> Puede seleccionar el rango usando el mouse mientras ingresa una funci\u00f3n o f\u00f3rmula.<\/li>\n<li> <strong>Escriba:<\/strong> Tambi\u00e9n puede escribir la direcci\u00f3n del rango con su teclado al ingresar una funci\u00f3n o f\u00f3rmula. <\/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-78745\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-plage-continue-de-reference.png\" sizes=\"auto, \" srcset=\"\" alt=\"rango-de-referencia-contin\u00faa\" width=\"721\" height=\"196\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Referencia a un rango no contiguo<\/h2>\n<p> Para hacer referencia a un rango no continuo, siga estos pasos:<\/p>\n<ol>\n<li> Primero, seleccione la primera celda o rango y escriba un comando.<\/li>\n<li> Despu\u00e9s de eso, mantenga presionada la tecla Ctrl y seleccione la segunda fila en su hoja de trabajo, luego escriba una coma nuevamente.<\/li>\n<li> Al final, seleccione la tercera fila de celdas.<\/li>\n<\/ol>\n<p> A continuaci\u00f3n hemos seleccionado B3:B5, C2:C6 y D3:D5. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-78746\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-gamme-non-continue-de-reference.png\" sizes=\"auto, \" srcset=\"\" alt=\"referencia-de-alcance-no-continua\" width=\"646\" height=\"332\"><\/figure>\n<\/div>\n<p> Otra forma de ingresar la direcci\u00f3n del primer rango, luego usar una coma y escribir el segundo rango, y ahora usar una coma nuevamente y escribir el tercer rango de celdas en la f\u00f3rmula o funci\u00f3n.<\/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\/conceptos-basicos-de-excel\/\">Conceptos b\u00e1sicos de Microsoft Excel (componentes, piezas y notas de conocimiento)<\/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\/agregar-eliminar-hipervinculos\/\">Agregar y eliminar hiperv\u00ednculos en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/agregar-marca-de-agua\/\">Agregar una marca de agua en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/eliminar-columnas-de-filas-ocultas\/\">Eliminar filas ocultas en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/deseleccionar-celdas\/\">Deseleccionar celdas en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/agregar-una-columna\/\">Agregar una columna en Excel<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u00bfQu\u00e9 es un rango en Excel? Un rango es un grupo de varias celdas en Excel. Puede haber un rango continuo y discontinuo. Al igual que una sola celda, cada rango tiene una direcci\u00f3n que puede usar para hacer referencia a ese rango. Una columna y una fila tambi\u00e9n son una forma de rango continuo [&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-629","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>\u00bfqu\u00e9 es un rango de excel y sus caracter\u00edsticas?<\/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\/rango\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfqu\u00e9 es un rango de excel y sus caracter\u00edsticas?\" \/>\n<meta property=\"og:description\" content=\"\u00bfQu\u00e9 es un rango en Excel? Un rango es un grupo de varias celdas en Excel. Puede haber un rango continuo y discontinuo. Al igual que una sola celda, cada rango tiene una direcci\u00f3n que puede usar para hacer referencia a ese rango. Una columna y una fila tambi\u00e9n son una forma de rango continuo [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/rango\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:32:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/image-gif.gif\" \/>\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\/rango\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/rango\/\",\"name\":\"\u00bfqu\u00e9 es un rango de excel y sus caracter\u00edsticas?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/rango\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/rango\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/image-gif.gif\",\"datePublished\":\"2023-10-17T00:17:04+00:00\",\"dateModified\":\"2023-12-25T10:32:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/rango\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/rango\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/rango\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/image-gif.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/image-gif.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/rango\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfqu\u00e9 es un rango de excel y sus caracter\u00edsticas?\"}]},{\"@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":"\u00bfqu\u00e9 es un rango de excel y sus caracter\u00edsticas?","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\/rango\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfqu\u00e9 es un rango de excel y sus caracter\u00edsticas?","og_description":"\u00bfQu\u00e9 es un rango en Excel? Un rango es un grupo de varias celdas en Excel. Puede haber un rango continuo y discontinuo. Al igual que una sola celda, cada rango tiene una direcci\u00f3n que puede usar para hacer referencia a ese rango. Una columna y una fila tambi\u00e9n son una forma de rango continuo [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/rango\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:32:12+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/image-gif.gif","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\/rango\/","url":"https:\/\/exceladvisor.org\/es\/rango\/","name":"\u00bfqu\u00e9 es un rango de excel y sus caracter\u00edsticas?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/rango\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/rango\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/image-gif.gif","datePublished":"2023-10-17T00:17:04+00:00","dateModified":"2023-12-25T10:32:12+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/rango\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/rango\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/rango\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/image-gif.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/image-gif.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/rango\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfqu\u00e9 es un rango de excel y sus caracter\u00edsticas?"}]},{"@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\/629","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=629"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/629\/revisions"}],"predecessor-version":[{"id":1405,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/629\/revisions\/1405"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=629"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}