{"id":260,"date":"2023-11-08T20:55:33","date_gmt":"2023-11-08T20:55:33","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/linea-total\/"},"modified":"2023-12-25T10:23:08","modified_gmt":"2023-12-25T10:23:08","slug":"linea-total","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/linea-total\/","title":{"rendered":"\u00bfc\u00f3mo agregar una fila total en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-3984933806\"><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, al trabajar con datos, es posible que necesites tener un total en la parte inferior para tener una suma de todos los valores que tienes en cada columna. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77879\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-ligne-totale-dans-les-donnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"agregar datos-de-fila-total\" width=\"659\" height=\"269\"><\/figure>\n<\/div>\n<p> En este tutorial, aprenderemos c\u00f3mo sumar una fila con el total usando dos m\u00e9todos r\u00e1pidos.<\/p>\n<ul>\n<li> Fila total en una tabla.<\/li>\n<li> Total con suma autom\u00e1tica.<\/li>\n<\/ul>\n<h2 class=\"wp-block-heading\"> Agregar una fila de total en Excel a una tabla<\/h2>\n<ol>\n<li> Primero, seleccione una de las celdas de los datos y presione el m\u00e9todo abreviado de teclado Ctrl + T, luego haga clic en Aceptar para aplicar la tabla. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"2-agregar-fila-total-en-tabla-de-excel\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-ajouter-une-ligne-totale-dans-le-tableau-Excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"add-total-row-in-excel-table\" width=\"531\" height=\"275\"><\/li>\n<li> A continuaci\u00f3n, vaya a la pesta\u00f1a Tabla y marque la casilla Fila total. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"Casilla de verificaci\u00f3n 3-verificaciones-total-fila\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Case-a-cocher-3-coches-pour-le-nombre-total-de-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"tickmark-total-row-checkbox\" width=\"402\" height=\"148\"><\/li>\n<li> Aqu\u00ed tiene una fila de totales en la parte inferior de la tabla donde tiene un total solo para la \u00faltima columna. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"4 filas en total agregadas en la \u00faltima columna\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-lignes-au-total-ajoutees-dans-la-derniere-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"total-row-added-in-last-column\" width=\"601\" height=\"251\"><\/li>\n<li> Ahora necesitas seleccionar la suma de cada celda en la fila total para obtener la suma de cada columna. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"5-seleccionar-suma-para-cada-celda-de-filas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-selectionner-la-somme-pour-chaque-cellule-de-lignes.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-sum-for-each-cell-of-rows\" width=\"636\" height=\"274\"><\/li>\n<li> Una vez que seleccione SUMA en el men\u00fa desplegable para cada una de las columnas que tiene en la tabla, tendr\u00e1 una fila total. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"6 filas de suma total\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Ligne-de-total-de-6-sommes.png\" sizes=\"auto, \" srcset=\"\" alt=\"sum-total-row\" width=\"631\" height=\"276\"><\/li>\n<li> Una vez que haya aplicado la tabla a los datos, puede hacer clic derecho en ella, luego navegar hasta la tabla y hacer clic en la fila total desde all\u00ed. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"Opci\u00f3n de 7 clics derecho y l\u00ednea total\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-clic-droit-et-option-de-ligne-totale.png\" sizes=\"auto, \" srcset=\"\" alt=\"right-click-and-total-row-option\" width=\"421\" height=\"399\"><\/li>\n<\/ol>\n<h2 class=\"wp-block-heading\"> Agregar una l\u00ednea total con suma autom\u00e1tica<\/h2>\n<ol>\n<li> Primero, seleccione la fila despu\u00e9s de la \u00faltima fila de datos. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"8 l\u00edneas en total con autosuma\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-lignes-au-total-avec-somme-automatique.png\" sizes=\"auto, \" srcset=\"\" alt=\"total-row-with-autosum\" width=\"596\" height=\"300\"><\/li>\n<li> Despu\u00e9s de eso, presione este m\u00e9todo abreviado de teclado Alt + = ( <a href=\"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/\">Autosuma<\/a> ) para agregar la funci\u00f3n de suma en todas las celdas de la fila para convertirla en una fila total para los datos. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"9-presione-el-atajo-de-teclado-alt-m\u00e1s-igual\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-appuyez-sur-le-raccourci-clavier-alt-plus-egal.png\" sizes=\"auto, \" srcset=\"\" alt=\"press-keyboard-shortcut-alt-plus-equal\" width=\"595\" height=\"297\"><\/li>\n<\/ol>\n<p> Aparte de eso, una vez que seleccione la fila inferior, puede ir a la pesta\u00f1a Inicio, editar el grupo y hacer clic en el bot\u00f3n autosuma para agregar la funci\u00f3n de suma en todas 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-77889\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-icone-de-somme-automatique-de-longlet-daccueil.png\" sizes=\"auto, \" srcset=\"\" alt=\"icono de autosuma de la pesta\u00f1a de inicio\" width=\"449\" height=\"198\"><\/figure>\n<\/div>\n<p> En el momento en que haces clic en el bot\u00f3n de autosuma, obtienes los valores totales en la fila seleccionada. <\/p>\n<div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\">\n<h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtener el archivo Excel<\/h2>\n<p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/sumif-vlookup-2.xlsx\" rel=\"nofollow\">Descargar<\/a><\/p>\n<\/div>\n<div class=\"gb-container gb-container-0df56012 gb-container-mt\"> <a class=\"gb-button gb-button-f9f432f4 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/es\/formulas\/\">Lista de f\u00f3rmulas de Excel<\/a><\/p>\n<h2 class=\"gb-headline gb-headline-233444e8 gb-headline-text gb-headline-mt-heading\"> F\u00f3rmulas relacionadas <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-a16fa65c gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-50d07e0d\">\n<div class=\"gb-container gb-container-50d07e0d\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/agregar-toda-la-columna\/\">Agregue una columna o fila completa en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/agregar-solo-celdas-visibles\/\">Suma solo celdas visibles en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/agregar-celdas-aleatorias\/\">Suma de celdas aleatorias en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/suma-automatica-1\/\">Utilice r\u00e1pidamente Autosuma en Excel<\/a> <\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"gb-grid-column gb-grid-column-5b4a0cf9\">\n<div class=\"gb-container gb-container-5b4a0cf9\"><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En Excel, al trabajar con datos, es posible que necesites tener un total en la parte inferior para tener una suma de todos los valores que tienes en cada columna. En este tutorial, aprenderemos c\u00f3mo sumar una fila con el total usando dos m\u00e9todos r\u00e1pidos. Fila total en una tabla. Total con suma autom\u00e1tica. Agregar [&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-260","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 agregar una fila total en 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\/linea-total\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo agregar una fila total en excel?\" \/>\n<meta property=\"og:description\" content=\"En Excel, al trabajar con datos, es posible que necesites tener un total en la parte inferior para tener una suma de todos los valores que tienes en cada columna. En este tutorial, aprenderemos c\u00f3mo sumar una fila con el total usando dos m\u00e9todos r\u00e1pidos. Fila total en una tabla. Total con suma autom\u00e1tica. Agregar [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/linea-total\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:23:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-ligne-totale-dans-les-donnees.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\/linea-total\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/linea-total\/\",\"name\":\"\u00bfc\u00f3mo agregar una fila total en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/linea-total\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/linea-total\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-ligne-totale-dans-les-donnees.png\",\"datePublished\":\"2023-11-08T20:55:33+00:00\",\"dateModified\":\"2023-12-25T10:23:08+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/linea-total\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/linea-total\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/linea-total\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-ligne-totale-dans-les-donnees.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-ligne-totale-dans-les-donnees.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/linea-total\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo agregar una fila total en 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 agregar una fila total en 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\/linea-total\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo agregar una fila total en excel?","og_description":"En Excel, al trabajar con datos, es posible que necesites tener un total en la parte inferior para tener una suma de todos los valores que tienes en cada columna. En este tutorial, aprenderemos c\u00f3mo sumar una fila con el total usando dos m\u00e9todos r\u00e1pidos. Fila total en una tabla. Total con suma autom\u00e1tica. Agregar [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/linea-total\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:23:08+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-ligne-totale-dans-les-donnees.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\/linea-total\/","url":"https:\/\/exceladvisor.org\/es\/linea-total\/","name":"\u00bfc\u00f3mo agregar una fila total en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/linea-total\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/linea-total\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-ligne-totale-dans-les-donnees.png","datePublished":"2023-11-08T20:55:33+00:00","dateModified":"2023-12-25T10:23:08+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/linea-total\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/linea-total\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/linea-total\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-ligne-totale-dans-les-donnees.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-ajouter-une-ligne-totale-dans-les-donnees.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/linea-total\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo agregar una fila total en 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\/260","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=260"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/260\/revisions"}],"predecessor-version":[{"id":819,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/260\/revisions\/819"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}