{"id":110,"date":"2023-11-16T09:04:35","date_gmt":"2023-11-16T09:04:35","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/"},"modified":"2023-12-25T10:26:49","modified_gmt":"2023-12-25T10:26:49","slug":"suma-automatica-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/","title":{"rendered":"\u00bfc\u00f3mo realizar una suma autom\u00e1tica en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-2485313215\"><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>Para realizar una suma autom\u00e1tica en Excel de los valores que tienes en las celdas arriba de la celda activa o los valores en las celdas de la izquierda, puedes usar la tecla de acceso directo <kbd>Alt<\/kbd> + <kbd>=<\/kbd> . Cuando presiona esta tecla de acceso directo, inserta la funci\u00f3n de suma en la celda activa haciendo referencia al rango de arriba o hacia la izquierda. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-62308\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-automatique.png\" sizes=\"auto, \" srcset=\"\" alt=\"suma autom\u00e1tica\" width=\"302\" height=\"460\"><\/figure>\n<\/div>\n<p> <kbd>Alt<\/kbd> + <kbd>=<\/kbd> <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-62315\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-raccourcis-de-somme-automatique.png\" sizes=\"auto, \" srcset=\"\" alt=\"atajo de autosuma\" width=\"896\" height=\"207\"><\/figure>\n<\/div>\n<p> Ahora, como dije, tambi\u00e9n puedes insertar una autosuma para los valores que tenemos en el lado izquierdo. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-62322\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-valeurs-dinsertion-et-de-somme-automatique.png\" sizes=\"auto, \" srcset=\"\" alt=\"valores de inserci\u00f3n y autosuma\" width=\"614\" height=\"128\"><\/figure>\n<\/div>\n<p> Pero si tiene valores tanto en el lado izquierdo como encima de la celda activa, insertar\u00e1 una suma autom\u00e1tica m\u00e1s adelante en los valores. Hay una cosa m\u00e1s cuando presionas la tecla de acceso r\u00e1pido, inserta la funci\u00f3n, pero debes presionar Enter para obtener el resultado. <\/p>\n<div class=\"wp-block-group more-tutorials is-layout-flow\">\n<div class=\"wp-block-group__inner-container\">\n<h2 class=\"wp-block-heading\"> M\u00e1s atajos <\/h2>\n<div class=\"wp-block-columns is-layout-flex wp-container-29\">\n<div class=\"wp-block-column is-layout-flow\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/filtro-1\/\">Aplicar y quitar filtro<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/contenido-claro\/\">Borrar contenido<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/mostrar-formulas\/\">Mostrar f\u00f3rmulas<\/a><\/li>\n<\/ul>\n<\/div>\n<div class=\"wp-block-column is-layout-flow\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/bajar-deslizandose\/\">Deslizar hacia abajo<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/borrar\/\">BORRAR<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<p> \u21e0 Volver a <a href=\"https:\/\/exceladvisor.org\/es\/atajos-de-teclado\/\">los atajos de Excel (hoja de referencia en PDF)<\/a><\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Para realizar una suma autom\u00e1tica en Excel de los valores que tienes en las celdas arriba de la celda activa o los valores en las celdas de la izquierda, puedes usar la tecla de acceso directo Alt + = . Cuando presiona esta tecla de acceso directo, inserta la funci\u00f3n de suma en la celda [&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-110","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 realizar una suma autom\u00e1tica 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\/suma-automatica-2\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo realizar una suma autom\u00e1tica en excel?\" \/>\n<meta property=\"og:description\" content=\"Para realizar una suma autom\u00e1tica en Excel de los valores que tienes en las celdas arriba de la celda activa o los valores en las celdas de la izquierda, puedes usar la tecla de acceso directo Alt + = . Cuando presiona esta tecla de acceso directo, inserta la funci\u00f3n de suma en la celda [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:26:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-automatique.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=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/\",\"name\":\"\u00bfc\u00f3mo realizar una suma autom\u00e1tica en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-automatique.png\",\"datePublished\":\"2023-11-16T09:04:35+00:00\",\"dateModified\":\"2023-12-25T10:26:49+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-automatique.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-automatique.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo realizar una suma autom\u00e1tica 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 realizar una suma autom\u00e1tica 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\/suma-automatica-2\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo realizar una suma autom\u00e1tica en excel?","og_description":"Para realizar una suma autom\u00e1tica en Excel de los valores que tienes en las celdas arriba de la celda activa o los valores en las celdas de la izquierda, puedes usar la tecla de acceso directo Alt + = . Cuando presiona esta tecla de acceso directo, inserta la funci\u00f3n de suma en la celda [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:26:49+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-automatique.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/","url":"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/","name":"\u00bfc\u00f3mo realizar una suma autom\u00e1tica en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-automatique.png","datePublished":"2023-11-16T09:04:35+00:00","dateModified":"2023-12-25T10:26:49+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/suma-automatica-2\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-automatique.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-automatique.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/suma-automatica-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo realizar una suma autom\u00e1tica 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\/110","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=110"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/110\/revisions"}],"predecessor-version":[{"id":1163,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/110\/revisions\/1163"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}