{"id":692,"date":"2023-09-27T13:31:42","date_gmt":"2023-09-27T13:31:42","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/congelar-el-obturador\/"},"modified":"2023-12-25T10:24:31","modified_gmt":"2023-12-25T10:24:31","slug":"congelar-el-obturador","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/congelar-el-obturador\/","title":{"rendered":"\u00bfc\u00f3mo congelar el panel usando el m\u00e9todo abreviado de teclado de excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-3371167561\"><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, Inmovilizar panel es una funci\u00f3n que se utiliza para congelar o bloquear paneles mientras se desplaza hacia cualquier lugar de la hoja para que los datos congelados sean visibles.<\/p>\n<p> Cuando los usuarios trabajan con grandes conjuntos de datos, prefieren congelar el encabezado o algunas filas y columnas espec\u00edficas para que sean visibles todo el tiempo cuando se desplazan a cualquier parte de la hoja.<\/p>\n<p> Con el panel Inmovilizar, los usuarios pueden congelar solo el encabezado o solo la primera columna, o la combinaci\u00f3n de filas y columnas espec\u00edficas seg\u00fan sus necesidades.<\/p>\n<h2 class=\"wp-block-heading\"> Atajo de teclado para congelar el panel en Excel<\/h2>\n<p> <kbd>Otro<\/kbd> \u2192 <kbd>W<\/kbd> \u2192 <kbd>F<\/kbd> \u2192 <kbd>R<\/kbd> (solo congelar encabezado) <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69452\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"atajo para congelar la columna\" width=\"781\" height=\"306\"><\/figure>\n<\/div>\n<p> <kbd>Alt<\/kbd> \u2192 <kbd>W<\/kbd> \u2192 <kbd>F<\/kbd> \u2192 <kbd>C<\/kbd> (Para congelar solo la primera columna) <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69453\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-raccourci-pour-geler-len-tete.png\" sizes=\"auto, \" srcset=\"\" alt=\"acceso directo al encabezado congelado\" width=\"781\" height=\"306\"><\/figure>\n<\/div>\n<p> <kbd>Alt<\/kbd> \u2192 <kbd>W<\/kbd> \u2192 <kbd>F<\/kbd> \u2192 <kbd>F<\/kbd> (Para congelar la combinaci\u00f3n de filas y columnas, o descongelar el panel ya congelado) <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69454\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-raccourci-pour-figer-les-lignes-et-les-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"atajo-para-congelar-filas-y-columnas\" width=\"793\" height=\"311\"><\/figure>\n<\/div>\n<h2 class=\"wp-block-heading\"> Pasos para congelar el panel usando el m\u00e9todo abreviado de teclado<\/h2>\n<ol>\n<li> Para congelar solo la fila del encabezado (primera fila), simplemente haga clic en cualquier lugar de la hoja y presione \u00abAlt \u2192 W \u2192 F \u2192 R\u00bb en orden, y su fila del encabezado se congelar\u00e1 y ser\u00e1 visible todo el tiempo, incluso cuando se desplace a cualquier lugar. en la hoja.<\/li>\n<li> Si desea desplazarse hacia la derecha y congelar la primera columna en lugar de la fila, simplemente haga clic en cualquier lugar de la hoja y presione \u00abAlt \u2192 W \u2192 F \u2192 C\u00bb en orden, y su primera columna se congelar\u00e1.<\/li>\n<li> Para congelar la combinaci\u00f3n espec\u00edfica de fila y columna, navegue hasta la celda a la izquierda y encima de la columna y las filas que desea congelar, luego presione \u00abAlt \u2192 W \u2192 F \u2192 F\u00bb y su combinaci\u00f3n de filas y columnas se congelar\u00e1n juntas.<\/li>\n<li> Para descongelar el panel, simplemente presione \u201cAlt \u2192 W \u2192 F \u2192 F\u201d. <\/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-69455\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-colonnes-pour-figer-les-lignes-et-les-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"columna para congelar filas y columnas\" width=\"565\" height=\"195\"><\/figure>\n<\/div>\n<p> En la imagen de arriba, primero fuimos a la celda C3 y luego presionamos Alt \u2192 W \u2192 F \u2192 F debido a lo cual las filas sobre esta celda y las columnas a la izquierda de esta celda est\u00e1n congeladas ahora si nos desplazamos hacia abajo en las dos primeras filas. estar\u00e1 visible todo el tiempo y si nos desplazamos hacia la derecha las dos primeras columnas estar\u00e1n visibles todo el tiempo. <\/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 tutoriales <\/h2>\n<div class=\"wp-block-columns is-layout-flex wp-container-55\">\n<div class=\"wp-block-column is-layout-flow\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/agregar-una-nueva-hoja\/\">Agregar una nueva hoja<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/eliminar-una-hoja\/\">Eliminar hoja<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/encontrar-reemplazar-1\/\">Encontrar y reemplazar<\/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\/hipervinculo-2\/\">Hiperv\u00ednculo<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ampliar-reducir\/\">Ampliar reducir<\/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>En Excel, Inmovilizar panel es una funci\u00f3n que se utiliza para congelar o bloquear paneles mientras se desplaza hacia cualquier lugar de la hoja para que los datos congelados sean visibles. Cuando los usuarios trabajan con grandes conjuntos de datos, prefieren congelar el encabezado o algunas filas y columnas espec\u00edficas para que sean visibles todo [&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-692","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 congelar el panel usando el m\u00e9todo abreviado de teclado de 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\/congelar-el-obturador\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo congelar el panel usando el m\u00e9todo abreviado de teclado de excel?\" \/>\n<meta property=\"og:description\" content=\"En Excel, Inmovilizar panel es una funci\u00f3n que se utiliza para congelar o bloquear paneles mientras se desplaza hacia cualquier lugar de la hoja para que los datos congelados sean visibles. Cuando los usuarios trabajan con grandes conjuntos de datos, prefieren congelar el encabezado o algunas filas y columnas espec\u00edficas para que sean visibles todo [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/congelar-el-obturador\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:24:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.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\/congelar-el-obturador\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/congelar-el-obturador\/\",\"name\":\"\u00bfc\u00f3mo congelar el panel usando el m\u00e9todo abreviado de teclado de excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/congelar-el-obturador\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/congelar-el-obturador\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png\",\"datePublished\":\"2023-09-27T13:31:42+00:00\",\"dateModified\":\"2023-12-25T10:24:31+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/congelar-el-obturador\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/congelar-el-obturador\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/congelar-el-obturador\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/congelar-el-obturador\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo congelar el panel usando el m\u00e9todo abreviado de teclado de 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 congelar el panel usando el m\u00e9todo abreviado de teclado de 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\/congelar-el-obturador\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo congelar el panel usando el m\u00e9todo abreviado de teclado de excel?","og_description":"En Excel, Inmovilizar panel es una funci\u00f3n que se utiliza para congelar o bloquear paneles mientras se desplaza hacia cualquier lugar de la hoja para que los datos congelados sean visibles. Cuando los usuarios trabajan con grandes conjuntos de datos, prefieren congelar el encabezado o algunas filas y columnas espec\u00edficas para que sean visibles todo [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/congelar-el-obturador\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:24:31+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.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\/congelar-el-obturador\/","url":"https:\/\/exceladvisor.org\/es\/congelar-el-obturador\/","name":"\u00bfc\u00f3mo congelar el panel usando el m\u00e9todo abreviado de teclado de excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/congelar-el-obturador\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/congelar-el-obturador\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png","datePublished":"2023-09-27T13:31:42+00:00","dateModified":"2023-12-25T10:24:31+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/congelar-el-obturador\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/congelar-el-obturador\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/congelar-el-obturador\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-figer-la-colonne.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/congelar-el-obturador\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo congelar el panel usando el m\u00e9todo abreviado de teclado de 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\/692","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=692"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/692\/revisions"}],"predecessor-version":[{"id":933,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/692\/revisions\/933"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}