{"id":699,"date":"2023-09-26T07:18:38","date_gmt":"2023-09-26T07:18:38","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/mostrar-formulas\/"},"modified":"2023-12-25T10:26:07","modified_gmt":"2023-12-25T10:26:07","slug":"mostrar-formulas","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/mostrar-formulas\/","title":{"rendered":"\u00bfc\u00f3mo mostrar f\u00f3rmulas en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1712528902\"><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, hay tantas f\u00f3rmulas para usar y cada vez que el usuario ingresa la f\u00f3rmula en cualquier celda, Excel muestra los valores resultantes de esa f\u00f3rmula.<\/p>\n<p> Pero en algunos casos los usuarios quieren ver las celdas que contienen f\u00f3rmulas para mostrar y validar la f\u00f3rmula y, a veces, imprimir los datos con las f\u00f3rmulas en lugar de los valores resultantes y para esto Excel tiene las opciones para mostrar las f\u00f3rmulas existentes.<\/p>\n<h2 class=\"wp-block-heading\"> Atajo de teclado para mostrar f\u00f3rmulas<\/h2>\n<p> Como muchas otras caracter\u00edsticas y funciones de Excel, Excel tambi\u00e9n tiene un atajo de teclado configurado para mostrar f\u00f3rmulas existentes en la hoja de c\u00e1lculo. El atajo de teclado para mostrar f\u00f3rmulas es: <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67542\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-afficher-les-formules.png\" sizes=\"auto, \" srcset=\"\" alt=\"acceso directo para mostrar f\u00f3rmulas\" width=\"813\" height=\"319\"><\/figure>\n<\/div>\n<p> Ctrl + `<\/p>\n<p> En el siguiente ejemplo, presionamos las teclas \u00abCtrl + `\u00bb y Excel mostr\u00f3 todas las f\u00f3rmulas existentes en lugar de sus valores resultantes. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67543\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formules-affichees.png\" sizes=\"auto, \" srcset=\"\" alt=\"f\u00f3rmulas mostradas\" width=\"738\" height=\"168\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Pasos para ver y f\u00f3rmulas usando el m\u00e9todo abreviado de teclado<\/h2>\n<ol>\n<li> Haga clic en cualquier celda de la hoja de c\u00e1lculo.<\/li>\n<li> Despu\u00e9s de eso, simplemente presione las teclas de m\u00e9todo abreviado de teclado \u00bb Ctrl + ` \u00bb y obtendr\u00e1 todas las f\u00f3rmulas mostradas en lugar de los valores resultantes.<\/li>\n<li> Para regresar y ver los valores resultantes, presione las teclas \u201cCtrl + `\u201d nuevamente. <\/li>\n<\/ol>\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-87\">\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\/suma-automatica-2\/\">Suma autom\u00e1tica<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/contenido-claro\/\">Borrar contenido<\/a><\/li>\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 class=\"wp-block-column is-layout-flow\"><\/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>En Excel, hay tantas f\u00f3rmulas para usar y cada vez que el usuario ingresa la f\u00f3rmula en cualquier celda, Excel muestra los valores resultantes de esa f\u00f3rmula. Pero en algunos casos los usuarios quieren ver las celdas que contienen f\u00f3rmulas para mostrar y validar la f\u00f3rmula y, a veces, imprimir los datos con las f\u00f3rmulas [&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-699","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 mostrar f\u00f3rmulas 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\/mostrar-formulas\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo mostrar f\u00f3rmulas en excel?\" \/>\n<meta property=\"og:description\" content=\"En Excel, hay tantas f\u00f3rmulas para usar y cada vez que el usuario ingresa la f\u00f3rmula en cualquier celda, Excel muestra los valores resultantes de esa f\u00f3rmula. Pero en algunos casos los usuarios quieren ver las celdas que contienen f\u00f3rmulas para mostrar y validar la f\u00f3rmula y, a veces, imprimir los datos con las f\u00f3rmulas [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/mostrar-formulas\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:26:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-afficher-les-formules.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\/mostrar-formulas\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/mostrar-formulas\/\",\"name\":\"\u00bfc\u00f3mo mostrar f\u00f3rmulas en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/mostrar-formulas\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/mostrar-formulas\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-afficher-les-formules.png\",\"datePublished\":\"2023-09-26T07:18:38+00:00\",\"dateModified\":\"2023-12-25T10:26:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/mostrar-formulas\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/mostrar-formulas\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/mostrar-formulas\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-afficher-les-formules.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-afficher-les-formules.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/mostrar-formulas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo mostrar f\u00f3rmulas 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 mostrar f\u00f3rmulas 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\/mostrar-formulas\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo mostrar f\u00f3rmulas en excel?","og_description":"En Excel, hay tantas f\u00f3rmulas para usar y cada vez que el usuario ingresa la f\u00f3rmula en cualquier celda, Excel muestra los valores resultantes de esa f\u00f3rmula. Pero en algunos casos los usuarios quieren ver las celdas que contienen f\u00f3rmulas para mostrar y validar la f\u00f3rmula y, a veces, imprimir los datos con las f\u00f3rmulas [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/mostrar-formulas\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:26:07+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-afficher-les-formules.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\/mostrar-formulas\/","url":"https:\/\/exceladvisor.org\/es\/mostrar-formulas\/","name":"\u00bfc\u00f3mo mostrar f\u00f3rmulas en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/mostrar-formulas\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/mostrar-formulas\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-afficher-les-formules.png","datePublished":"2023-09-26T07:18:38+00:00","dateModified":"2023-12-25T10:26:07+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/mostrar-formulas\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/mostrar-formulas\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/mostrar-formulas\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-afficher-les-formules.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-afficher-les-formules.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/mostrar-formulas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo mostrar f\u00f3rmulas 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\/699","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=699"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/699\/revisions"}],"predecessor-version":[{"id":1121,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/699\/revisions\/1121"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=699"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}