{"id":363,"date":"2023-10-31T21:51:48","date_gmt":"2023-10-31T21:51:48","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/mostrar\/"},"modified":"2023-12-25T10:26:10","modified_gmt":"2023-12-25T10:26:10","slug":"mostrar","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/mostrar\/","title":{"rendered":"\u00bfc\u00f3mo mostrar una hoja de excel o todas las hojas?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-3566632086\"><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>Puede ver r\u00e1pidamente una o m\u00e1s hojas en Excel. Y en este tutorial vamos a aprender c\u00f3mo hacerlo en unos sencillos pasos.<\/p>\n<h2 id=\"h-unhide-a-single-sheet-in-excel\" class=\"wp-block-heading\"> Ver una sola hoja en Excel<\/h2>\n<ol>\n<li> Primero, coloque el cursor sobre una de las pesta\u00f1as de las hojas de su libro.<\/li>\n<li> Ahora, haga clic derecho y luego haga clic en la opci\u00f3n \u00abMostrar\u00bb. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"1-mostrar-una-hoja-de-excel\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-une-feuille-excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"1-unhide-an-excel-sheet\" width=\"372\" height=\"358\"><\/li>\n<li> Despu\u00e9s de eso, en el cuadro de di\u00e1logo, haga clic en el nombre de la hoja que desea ver. <br \/><img loading=\"lazy\" decoding=\"async\" title=\"2-elige-el-nombre-de-la-hoja-a-mostrar\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-choisissez-le-nom-de-la-feuille-a-afficher.png\" sizes=\"auto, \" srcset=\"\" alt=\"2-choose-sheetname-to-unhide\" width=\"378\" height=\"236\"><\/li>\n<li> Al final, haga clic en Aceptar para ver la hoja.<\/li>\n<\/ol>\n<p> Al hacer clic en Aceptar, se mostrar\u00e1 la hoja que seleccion\u00f3 en el cuadro de di\u00e1logo. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92283\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-feuilles-selectionnees-afficher.png\" sizes=\"auto, \" srcset=\"\" alt=\"hoja seleccionada-mostrar\" width=\"615\" height=\"180\"><\/figure>\n<\/div>\n<p> <strong>Nota:<\/strong> Tambi\u00e9n puedes usar la misma opci\u00f3n \u00abMostrar&#8230;\u00bb en Inicio &gt; Formato &gt; Ocultar y mostrar &gt; Mostrar hoja. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92284\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-formats-masquer-afficher-les-feuilles.png\" sizes=\"auto, \" srcset=\"\" alt=\"formato-ocultar-mostrar-hojas\" width=\"522\" height=\"508\"><\/figure>\n<\/div>\n<h2 id=\"h-unhide-all-the-hidden-sheets-in-excel\" class=\"wp-block-heading\"> Mostrar todas las hojas ocultas en Excel<\/h2>\n<p> Recientemente, Microsoft actualiz\u00f3 la opci\u00f3n de seleccionar varias hojas en el cuadro de di\u00e1logo para verlas a la vez.<\/p>\n<ol type=\"1\">\n<li> Primero, haga clic derecho en la pesta\u00f1a de la hoja.<\/li>\n<li> Ahora en el cuadro de di\u00e1logo, mantenga presionada la tecla Ctrl.<\/li>\n<li> A continuaci\u00f3n, seleccione varias o todas las hojas de la lista.<\/li>\n<li> Al final, haga clic en Aceptar para ver las hojas seleccionadas. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92285\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-afficher-toutes-les-feuilles-masquees.png\" sizes=\"auto, \" srcset=\"\" alt=\"mostrar todas las hojas ocultas\" width=\"640\" height=\"348\"><\/figure>\n<\/div>\n<p> Una vez que hace clic en Aceptar, se muestran todas las hojas que seleccion\u00f3 en el cuadro de di\u00e1logo a la vez. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92286\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-toutes-les-feuilles-ont-ete-masquees.png\" sizes=\"auto, \" srcset=\"\" alt=\"todas las hojas tienen mostrar\" width=\"682\" height=\"145\"><\/figure>\n<\/div>\n<div class=\"gb-container gb-container-3044ba66 gb-container-mt\">\n<p class=\"gb-headline gb-headline-b5bb6270 gb-headline-text\"> <strong><a href=\"https:\/\/exceladvisor.org\/es\/conceptos-basicos-de-excel\/\">Conceptos b\u00e1sicos de Excel<\/a><\/strong> \/ <strong><a href=\"https:\/\/exceladvisor.org\/es\/hoja-de-calculo\/\" data-wpil=\"url\">Hoja de c\u00e1lculo de Excel<\/a><\/strong><\/p>\n<h2 class=\"gb-headline gb-headline-819d540d gb-headline-text gb-headline-mt-heading\"> M\u00e1s tutoriales <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-7f3d805a gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-530ab33a\">\n<div class=\"gb-container gb-container-530ab33a\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/duplicar\/\">Duplicar una hoja u hoja de c\u00e1lculo en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/enlace-a-otra-hoja\/\">Crear un hiperv\u00ednculo (enlace) a otra hoja de c\u00e1lculo<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/cerrar\/\">Bloquear una hoja (hoja de trabajo) en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/actualizar\/\">Actualizar una hoja (hoja de c\u00e1lculo) en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/abierto\/\">Desbloquear una hoja con contrase\u00f1a (sin contrase\u00f1a)<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Puede ver r\u00e1pidamente una o m\u00e1s hojas en Excel. Y en este tutorial vamos a aprender c\u00f3mo hacerlo en unos sencillos pasos. Ver una sola hoja en Excel Primero, coloque el cursor sobre una de las pesta\u00f1as de las hojas de su libro. Ahora, haga clic derecho y luego haga clic en la opci\u00f3n \u00abMostrar\u00bb. [&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-363","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 una hoja de excel o todas las hojas?<\/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\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo mostrar una hoja de excel o todas las hojas?\" \/>\n<meta property=\"og:description\" content=\"Puede ver r\u00e1pidamente una o m\u00e1s hojas en Excel. Y en este tutorial vamos a aprender c\u00f3mo hacerlo en unos sencillos pasos. Ver una sola hoja en Excel Primero, coloque el cursor sobre una de las pesta\u00f1as de las hojas de su libro. Ahora, haga clic derecho y luego haga clic en la opci\u00f3n \u00abMostrar\u00bb. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/mostrar\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:26:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-une-feuille-excel.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\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/mostrar\/\",\"name\":\"\u00bfc\u00f3mo mostrar una hoja de excel o todas las hojas?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/mostrar\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/mostrar\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-une-feuille-excel.png\",\"datePublished\":\"2023-10-31T21:51:48+00:00\",\"dateModified\":\"2023-12-25T10:26:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/mostrar\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/mostrar\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/mostrar\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-une-feuille-excel.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-une-feuille-excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/mostrar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo mostrar una hoja de excel o todas las hojas?\"}]},{\"@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 una hoja de excel o todas las hojas?","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\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo mostrar una hoja de excel o todas las hojas?","og_description":"Puede ver r\u00e1pidamente una o m\u00e1s hojas en Excel. Y en este tutorial vamos a aprender c\u00f3mo hacerlo en unos sencillos pasos. Ver una sola hoja en Excel Primero, coloque el cursor sobre una de las pesta\u00f1as de las hojas de su libro. Ahora, haga clic derecho y luego haga clic en la opci\u00f3n \u00abMostrar\u00bb. [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/mostrar\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:26:10+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-une-feuille-excel.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\/","url":"https:\/\/exceladvisor.org\/es\/mostrar\/","name":"\u00bfc\u00f3mo mostrar una hoja de excel o todas las hojas?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/mostrar\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/mostrar\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-une-feuille-excel.png","datePublished":"2023-10-31T21:51:48+00:00","dateModified":"2023-12-25T10:26:10+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/mostrar\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/mostrar\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/mostrar\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-une-feuille-excel.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-une-feuille-excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/mostrar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo mostrar una hoja de excel o todas las hojas?"}]},{"@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\/363","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=363"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/363\/revisions"}],"predecessor-version":[{"id":1124,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/363\/revisions\/1124"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}